//模型文件app/models/Archives.php class Archives extends Eloquent{ protected $table = 'archives';public $timestamps = false; } //路由文件 Route::get('/test',array('as'=>'routetest',function(){ //DB類位于 vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php//$arr = DB::select('select * from archives where id=?',[1]);//查//$arr = DB::insert('insert into archives (title,body)values(?,?)',array('title2','body2'));//增//$arr = DB::update('update archives set title=?,body=? where id=?',array('new1','newbody1',4));//改//$arr = DB::delete('delete from archives where id=?',array(4));//刪//$arr = DB::table('archives')->where('id','>',1)->orderBy('id','desc')->get();//獲取多條數(shù)據(jù)//$arr = DB::table('archives')->orderBy('id','desc')->first();//獲取第一條數(shù)據(jù)//$arr = DB::table('archives')->where('id',2)->pluck('title');//獲取一條數(shù)據(jù)的指定字段//$arr = DB::table('archives')->where('id','>',1)->lists('title');//獲取一張表的一列字段//$arr = DB::table('archives')->join('arctype','arctype.id','=','archives.typeid')->select('archives.*','arctype.typename')->get();//JOIN試?yán)?/$arr = DB::table('archives')->where('id','>',1)->toSql();//獲取查詢的SQL語(yǔ)句，公用于條件，不能用于get()之類的有結(jié)果之中//模型查詢，模型類的父類Eloquent 位于/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php$arr = Archives::find(3);//查詢id為3的一條數(shù)據(jù)$arr = Archives::all(array('id','title'));//查詢?nèi)繑?shù)據(jù)$arr = Archives::where('typeid','=',1)->orderBy('id','desc')->get(); }));

轉(zhuǎn)載于:https://my.oschina.net/tongjh/blog/194460

新人創(chuàng)作打卡挑戰(zhàn)賽發(fā)博客就能抽獎(jiǎng)！定制產(chǎn)品紅包拿不停！

總結(jié)

以上是生活随笔為你收集整理的laravel 模型(2)的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。