- <?php
- namespace App;
- use Illuminate\Database\Eloquent\Model;
- use Illuminate\Database\Eloquent\SoftDeletes;
- use DB;
- class User extends Model {
- static function getResult(){
- $res=null;
- /*
- //插入
- $user=array('username'=>'test','password'=>'123456','age'=>23);
- $res = DB::table('users')->insert($user);
- */
- /*
- //查询
- res = DB::table('users')->where('username','test')->first();//一维
- $res = DB::table('users')->where('username','test')->get(); //二维
- $res = DB::select('SELECT * FROM users WHERE username="test"');
- */
- /*
- //更新数据
- $res =DB::update('UPDATE users SET age=25 WHERE username="test"');
- $res =DB::table('users')->where('username','test')->update(array('age' =>23));
- */
- /*
- //删除数据
- $res = DB::delete('DELETE FROM users WHERE username="joy"');
- $res = DB::table('users')->where('username','joy')->delete();
- */
- /*
- //字段添加
- $res = DB::statement('ALTER TABLE users ADD sex tinyint(1) not null default 0');
- */
- /*事务
- DB::transaction(function(){
- $user=array(xxxx);
- DB::table('user')->insert($user);
- DB.....
- });
- */
- /*
- //结果查询器
- $res = DB::table('users')->where('username','test')->pluck('age');//去特定字段值
- $res = DB::table('users')->lists('age');//特殊字段list值
- $res = DB::table('users')->select(array('id','username'))->get();多个特殊字段查询
- $res = DB::table('users')->where('id','>',1)->get();
- $res = DB::table('users')->where('id',1)->get();
- $res = DB::table('users')->whereId(1)->get();
- $res = DB::table('users')->where('id','<',3)->where('username','test')->get();
- $res = DB::table('users')->where('id','>',3)->orWhere('username','test')->get();
- $res = DB::table('users')->where('username','test')->where(function($query){
- $query->where('age','>',13)->orWhere('sex',0);
- })->get();//相当于username = 'test' and (age>13 or sex=0)
- $res = DB::table('users')->whereBetween('age',array(0,15))->get();
- $res = DB::table('users')->whereNotBetween('age',array(0,15))->get();
- $res = DB::table('users')->whereIn('age',array(23,30))->get();
- $res = DB::table('users')->whereNot In('age',array(23,30))->get();
- */
- //$res = DB::table('users')->groupBy('sex')->orderBy('id','DESC')->having('sex','=',0)->get();
- //$res = DB::table('users')->limit(2,3)->get();
- //$res = DB::table('users')->skip(2)->take(1)->get();
- //$res = DB::table('posts')->join('users','posts.user_id','=','users.id')->get();
- // $res = DB::table('posts')->join('users',function($query){
- // $query->on('posts.user_id','=','users.id');//->On(...);
- // })->get();
- /*
- //嵌套查询
- $res = DB::table('users')->where(function($query){
- if(Input::get('status')){
- $query->whereStatus(Input::get('status'));
- }
- if(Input::get('source')){
- $query->whereSource(Input::get('source'));
- }
- })->get();
- */
- /*
- $res = DB::table('users')->whereExists(function($query){
- $query->select('*')->from('posts')->whereRaw(DB::raw('users.id = posts.user_id'));
- })->get();
- */
- $res = DB::table('users')->where('id','>','2')->count();
- $res = DB::table('posts')->where('id',6)->decrement('view_count',5);//减5
- //$res=DB::table('posts')->truncate();//清表
- print_r($res);exit;
- }
- }
laravel5.2数据库基本操作
最新推荐文章于 2021-02-26 09:10:22 发布