Level 47
what is in your User Model?
there should be a line :
protected $fillable = ['name','email',.....];
1 like
Jul 17, 2018
5
Level 1
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null (SQL: insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (, , $2y$10$sFHcGna6Q7vofl9.yIqNBOkQ7NzBVKnY3QoNLFUTkezRrqiIE9wRO, 2018-07-17 11:
I am stuck with this error trying to submit a form Can someone help me out, please help
UsersController.php
public function store(Request $request) {
//dd($request->all());
$user=User::create([
'name'=>$request->name,
'email'=>$request->email,
'password'=>bcrypt('password')
]);
$profile=Profile::create([
'user_id'=>$user->id, 'avatar'=>'uploads/avatars/11.png' ]);
Session::flash('success','User Added Successfull!');
return redirect()->route('users'); }
Create table user
Level 53
The User model should have that pre setup already.
I'm inclined to think there is no name / email posted in the form.
Level 104
Makes a case for validating your request @mian :
$user=User::create($request->validate([
'name'=>'required',
'email'=>'required|unique:users,email,
'password'=>required
]);
You will get validation error rather than a QueryException.
As @lostdreamer_nl says, there probably is no fields called name and email in the form since both values are empty in the SQL above. Remember that an input must have a name attribute in order to be submitted.
1 like
Level 1
Show me your code of following files....
- add blade form, model, migration
I think the form field name and migration field name does not match
Level 1
Your model receives name and email fields as empty and these fields are marked required in the table structure, make sure that you receive both fields with values in the controller from the form.
Please or to participate in this conversation.