Query builder not inserting timestamps
All right. Fields created_at
,update_at
and deleted_at
are "part" of Eloquent
. You use Query Builder
=> inserting doesn't affect on these two fields (created_at
and updated_at
). You should define it manually like:
$id = DB::table('widgets') ->insertGetId(array( 'creator' => Auth::user()->id, 'widget_name' => $request->input('widget_name'), 'pages' => json_encode($request->input('pages')), 'domain' => $request->input('domain'), "settings" => $settings, "created_at" => \Carbon\Carbon::now(), # new \Datetime() "updated_at" => \Carbon\Carbon::now(), # new \Datetime() ));
In my case, I'm using date('Y-m-d H:i:s');
to get current dateTime. It works every time.
$id = DB::table('widgets') ->insertGetId(array( 'creator' => Auth::user()->id, 'widget_name' => $request->input('widget_name'), 'pages' => json_encode($request->input('pages')), 'domain' => $request->input('domain'), "settings" => $settings, "created_at" => date('Y-m-d H:i:s'), "updated_at" => date('Y-m-d H:i:s'), ));