據(jù)官方文檔的說(shuō)明,使用Eloquent ORM,插數(shù)據(jù)庫(kù)的時(shí)候可以自動(dòng)生成created_at,updated_at,代碼如下:
Model里的代碼:
?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Notice extends Model
{
protected $guarded = [];
//獲取部門(mén)名稱
public function fromDep(){
return $this->belongsTo('App\Models\Department','from','id');
}
public function toDep(){
return $this->belongsTo('App\Models\Department','to','id');
}
public function toUser(){
return $this->belongsTo('App\User','create_user','id');
}
}
新增的代碼
public function store(Request $request)
{
$data = $request->only(['title','sort','level','from','content','document']);
$data['creater'] = Auth::user()->id;
if(Notice::insert($data)){
return ResponseLayout::apply(true);
}else{
return ResponseLayout::apply(false);
}
}
插入一條數(shù)據(jù),數(shù)據(jù)庫(kù)中created_at和updated_at字段為0000-00-00 00:00:00。
原因分析:原生的插入語(yǔ)句,Laravel是不會(huì)自動(dòng)幫你插入created_at和updated_at字段的。
解決方法
create
public function store(Request $request)
{
$data = $request->only(['title','sort','level','from','content','document']);
$data['creater'] = Auth::user()->id;
if(Notice::create($data)){
return ResponseLayout::apply(true);
}else{
return ResponseLayout::apply(false);
}
}
save
public function store(Request $request)
{
$data = $request->only(['title','sort','level','from','content','document']);
$data['creater'] = Auth::user()->id;
$notice = new Notice($data);
if($notice->save()){
return ResponseLayout::apply(true);
}else{
return ResponseLayout::apply(false);
}
}
以上這篇解決Laravel 使用insert插入數(shù)據(jù),字段created_at為0000的問(wèn)題就是小編分享給大家的全部?jī)?nèi)容了,希望能給大家一個(gè)參考,也希望大家多多支持腳本之家。
您可能感興趣的文章:- Laravel timestamps 設(shè)置為unix時(shí)間戳的方法
- laravel model模型定義實(shí)現(xiàn)開(kāi)啟自動(dòng)管理時(shí)間created_at,updated_at