Laravel 5.2 Submitting Form Data

Question

I am submitting form to /add route BUT when i click on submit button it gives this error Using : Larvel 5

{ SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '$name' for key 'name' (SQL: insert into projects (id, name, money, anything) values (, $name, 20, asfsf)) }

FORM :

{!! Form::open(array('url' => 'add')) !!}
  {!! Form::text('name', '[email protected]') !!}
  {!! Form::submit('Click Me!')!}
{!! Form::close() !!}

Routes.php

Route::post('add', function () {
   $test = Input::get('name');
   echo $test;
});

DB Snap:

PS: I want to echo the input field value but it gives the above mentioned error.

Can you share your migration file or table schema for projects? — Jeff Lambert
Probably, you are typing '$name' somewhere, where you should type just $name. — Laerte
I've just tested your code and it works fine. I can see [email protected] as output. I've created view and copy-pasted your form there. Also, I've copy-pasted your route. Works fine. — Alexey Mezenin

askilondz askilondz · Accepted Answer · 2016-03-01T17:29:02

You're inserting nothing for the id. notice the blank space before the comma in values (, $name, 20, asfsf)) }.

If your id field is set to auto-increment (looks like it is) then remove id from your insert statement.

insert into projects (name, money, anything) values ($name, 20, 'asfsf')

Laravel 5.2 Submitting Form Data

1 Answers