laravel5数据库操作
来源:互联网 发布:做微信推文用什么软件 编辑:程序博客网 时间:2024/05/16 09:29
<?phpnamespace 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;}}
1 0
- laravel5数据库操作
- laravel5.2数据库基本操作
- laravel5.1 数据库相关,操作底层实现
- Laravel5的数据库表建立问题 数据库迁移操作报错问题解决
- laravel5.4 把excal的数据上传到数据库的操作
- laravel5 数据库配置(MySQL)
- laravel5数据库配置及其注意事项
- laravel5 数据库配置(MySQL)
- laravel5数据库配置及其注意事项
- laravel5.3-数据库操作下的局部or条件与全局or条件(orWhere的局部与全局)
- laravel5模型、控制器、视图基本操作
- Laravel5.4的数据库迁移报错
- Laravel5.4常见问题-Migrate数据库问题
- laravel5.4 迁移数据库 出错(一)
- laravel5.4 迁移数据库 出错(二)
- Laravel5.4框架中数据库迁移
- laravel5.2 DB数据库 读写分离
- mysql数据库分表查询(基于laravel5.2)
- Redis 和 Memcache 的性能对比基础篇
- Codeforces-448【A数学函数ceil】【B思维】【D二分】
- HDU 1551 Cable master / UVALive 2452 Cable master(切电缆,二分)
- Ionic环境搭建
- Memcache的最佳实践方案
- laravel5数据库操作
- 什么东西只花十分钟,但是受益终身
- 认识Servlet
- tjut 4630
- MDK注释时用@使单词高亮
- BD___单例模式
- HDOJ-----4004二分
- HDU 1698 Just a Hook(线段树区间置换)
- Android打电话,发短信【JAVA】