here's the error
SQLSTATE[HY000]: General error: 1364 Field 'department_id' doesn't have a default value (SQL: insert into `ms_user` (`name`, `username`, `role`, `email`, `password`, `updated_at`, `created_at`)
ms_user model
protected $fillable = [
'department_id','name', 'email', 'password','username','role',
];
create function :
{
return ms_user::create([
'name' => $data['name'],
'username' => $data['username'],
'role' => $data['role'],
'email' => $data['email'],
'department_id' => $data['department_id'],
'password' => bcrypt($data['password'])
]);
}
validator function :
protected function validator(array $data)
{
return Validator::make($data, [
'name' => 'required|string|max:255',
'username' => 'required|string|max:255',
'role' => 'required|in:user,admin',
'department_id' => 'required|string',
'email' => 'required|string|email|max:255|unique:ms_user',
'password' => 'required|string|min:6|confirmed',
]);
}
department_id is a dropdown menu that contains data from the ms_department table, department_id becomes the foreign key in the ms_user table and as the primary key in the ms_department
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire