查询生成器未插入时间戳

本文介绍了查询生成器未插入时间戳的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用查询构建器来插入数据，所有字段均已插入，但是诸如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() ));