本文介绍了查询生成器未插入时间戳的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用查询构建器来插入数据,所有字段均已插入,但是诸如created_at和updated_at之类的时间戳未插入,它们都具有默认的0:0:0值 我的插入查询是
I am using Query builder to insert data all fields are been inserted but timestamps like created_at and updated_at are not inserting they all have default 0:0:0 values my insert query is
$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,update_at和deleted_at是Eloquent的部分".您使用Query Builder =>插入不会影响这两个字段(created_at和updated_at).您应该手动定义它,例如:
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() ));更多推荐
查询生成器未插入时间戳
发布评论