Laravel 数据库 *** 作 Eloquent ORM

概述laravel *** 作数据库一般都使用它的Eloquent ORM才 *** 作建立模型<?phpnamespace App;use IlluminateDatabaseEloquentModel;class Student extends Model{//指定表名 默认 模型名的复数protected $table='student';//指定主键 默认主键 为IDprotected $primaryKey='id';//指定允许批量赋值的字段protected $fillable=['name','age'];//指定不允许批量赋值的字段protected $guarded=[];//是否维护时间戳 默认维护//$timestamps=falst 不维护public $timestamps=true;//维护时间的时候保存时间戳protected function getDateFormat(){return time(); // TODO: Change the autogenerated stub}//查询的时候返回时间戳protected function asDateTime($value){// return parent::asDateTime($value); // TODO: Change the autogenerated stubreturn $value;}}ORM 查询//all() 查询所有数据 查询数据为集合$students=Student::all();dd($students);//根据主键查询 查询一条数据$student=Student::find(2);dd($student);//findOrFail() 根据主键查询 如果没有查到 报错$student=Student::findOrFail(2);dd($student);//get() 查询所有数据$students=Student::get();dd($students);//first() 查询第一条$students=Student::where('id','>','1')->orderBy('age','desc')->first();dd($students);//chunk() 每次查询一定条数Student::chunk(2,function($students){var_dump($students);});//聚合函数//count() 条数$num = Student::count();var_dump($num);//max() 查询最大值$max=Student::where('id','>',1)->max('age');var_dump($max);添加//新增//save()$student=new Student();$student->name='vbb';$student->age=34;$rs=$student->save();dd($rs);//create()$rs=Student::create(['name'=>'momo','age'=>23]);dd($rs);//firstOrCreate()以属性查询数据 如果没有 新建数据$rs=Student::firstOrCreate(['name'=>'vbb4']);//firstOrNew() 以属性查询数据 如果没有 新建实例 如果想保存调用save()$rs=Student::firstOrNew(['name'=>'vbb4']);$bool=$rs->save();dd($rs);更新//更新//通过模型更新数据$student=Student::find(2);$student->age=2;$bool=$student->save();var_dump($bool);//批量更新$num=Student::where('id','>',5)->update(['age'=>41]);var_dump($num);删除//删除//通过模型删除$student=Student::find(2);$bool=$student->delete();var_dump($bool);//通过主键删除$num=Student::destroy(3,4,5);$num=Student::destroy([3,4,5]);var_dump($num);//删除指定条件$num=Student::where('id','>',7)->delete();var_dump($num); 

<div >

建立模型

use Illuminate\Database\Eloquent\Model;

class Student extends Model
{
//指定表名 默认 模型名的复数
protected $table='student';

//指定主键 <a href="https://www.jb51.cc/tag/mo/" target="_blank" >默</a>认主键 为<a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a>protected  $primaryKey='<a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a>';//指定允许批量赋值的字段protected $fillable=['<a href="https://m.jb51.cc/tag/name/" target="_blank" >name</a>','age'];//指定不允许批量赋值的字段protected $guarded=[];//是否维护<a href="https://m.jb51.cc/tag/shijian/" target="_blank" >时间</a>戳  <a href="https://www.jb51.cc/tag/mo/" target="_blank" >默</a>认维护//$timestamps=falst 不维护pub<a href="https://m.jb51.cc/tag/li/" target="_blank" >li</a>c $timestamps=true;//维护时<a href="https://www.jb51.cc/tag/jiande/" target="_blank" >间的</a>时候保存<a href="https://m.jb51.cc/tag/shijian/" target="_blank" >时间</a>戳protected function getDateFormat(){    return time(); // T<a href="https://www.jb51.cc/tag/odo/" target="_blank" >odo</a>: Change the <a href="https://m.jb51.cc/tag/auto/" target="_blank" >auto</a>generated stub}//<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>的时候返回<a href="https://m.jb51.cc/tag/shijian/" target="_blank" >时间</a>戳protected function asDateTime($value){

// return parent::asDateTime($value); // Todo: Change the autogenerated stub
return $value;
}
}

　　

ORM 查询 =Student:: </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;根据主键<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a> <a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>一条数据</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$student</span>=Student::find(2<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); dd(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$student</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;findOrFail() 根据主键<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a> 如果没有查到 <a href="https://m.jb51.cc/tag/baocuo/" target="_blank" >报错</a></span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$student</span>=Student::findOrFail(2<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); dd(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$student</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;get() <a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>所有数据</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$students</span>=Student::<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;get(); dd(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$students</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;f<a href="https://www.jb51.cc/tag/irs/" target="_blank" >irs</a>t() <a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>第一条</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$students</span>=Student::where('<a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a>','>','1')->orderBy('age','desc')-><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;f<a href="https://www.jb51.cc/tag/irs/" target="_blank" >irs</a>t(); dd(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$students</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;chunk() 每次<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>一定条数 </span> Student::chunk(2,<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #0000ff"&gt;function</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$students</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;){ </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;var_dump</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$students</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); }); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;聚合<a href="https://www.jb51.cc/tag/hanshu/" target="_blank" >函数</a> //count() 条数</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span> = Student::<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;count</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;(); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;var_dump</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;max() <a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>最大值</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$max</span>=Student::where('<a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a>',1)-><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;max</span>('age'<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;var_dump</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$max</span>);</pre>添加 =->name='vbb'->age=34=-> </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;create()</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$rs</span>=Student::<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;create([ </span>'<a href="https://m.jb51.cc/tag/name/" target="_blank" >name</a>'=>'momo','age'=>23<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt; ]); dd(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$rs</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;f<a href="https://www.jb51.cc/tag/irs/" target="_blank" >irs</a>tOrCreate()以<a href="https://www.jb51.cc/tag/shuxing/" target="_blank" >属性</a><a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>数据 如果没有 新建数据</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$rs</span>=Student::<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;f<a href="https://www.jb51.cc/tag/irs/" target="_blank" >irs</a>tOrCreate( [</span>'<a href="https://m.jb51.cc/tag/name/" target="_blank" >name</a>'=>'vbb4'<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;] ); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;f<a href="https://www.jb51.cc/tag/irs/" target="_blank" >irs</a>tOrNew() 以<a href="https://www.jb51.cc/tag/shuxing/" target="_blank" >属性</a><a href="https://www.jb51.cc/tag/chaxun/" target="_blank" >查询</a>数据 如果没有 新建实例 如果想保存<a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" >调用</a>save()</span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$rs</span>=Student::<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;f<a href="https://www.jb51.cc/tag/irs/" target="_blank" >irs</a>tOrNew( [</span>'<a href="https://m.jb51.cc/tag/name/" target="_blank" >name</a>'=>'vbb4'<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;] ); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$bo<a href="https://m.jb51.cc/tag/ol/" target="_blank" >ol</a></span>=<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$rs</span>-><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;save(); dd(</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$rs</span>);</pre>更新 =Student::find(2->age=2=->( </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;批量<a href="https://m.jb51.cc/tag/gengxin/" target="_blank" >更新</a></span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span>=Student::where('<a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a>',5)-><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;update( [</span>'age'=>41<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;] ); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;var_dump</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span>);</pre>删除 =Student::find(2=->( </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;通过主键<a href="https://www.jb51.cc/tag/shanchu/" target="_blank" >删除</a></span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span>=Student::destroy(3,4,5<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span>=Student::destroy([3,5<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;]); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;var_dump</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;//</span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008000"&gt;<a href="https://www.jb51.cc/tag/shanchu/" target="_blank" >删除</a>指定<a href="https://m.jb51.cc/tag/tiaojian/" target="_blank" >条件</a></span> <span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span>=Student::where('<a href="https://m.jb51.cc/tag/ID/" target="_blank" >ID</a>',7)-><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #000000"&gt;delete(); </span><span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #008080"&gt;var_dump</span>(<span https://m.jb51.cc/tag/color/" target="_blank" >color</a>: #800080"&gt;$num</span>);</pre> 总结

以上是内存溢出为你收集整理的Laravel 数据库 *** 作 Eloquent ORM全部内容，希望文章能够帮你解决Laravel 数据库 *** 作 Eloquent ORM所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/langs/1268830.html