Search code examples
phplaravellaravel-5.3php-7

SQLSTATE[22007]: Invalid datetime format: 1366 in laravel


I am new to laravel i am trying to insert data to database and i am getting this error

enter image description here

this is my table its have no date fields

enter image description here

controller and insert code

public function save_data(Request $request){

$data= $request->all();
$name=$data['name'];
$insert=array('name'=>$name);
DB::table('data')->insert($insert);
}

Solution

  • Your name column is of type int(11). It expects an integer, not a string (VARCHAR). Change your column type (preferably with a migration) from int(11) to a VARCHAR.