1、数据库的配置
2、使用DB语句先要引入DB类
public function querys(){$res = DB::select('select * from admin');var_dump($res);}
3、laravel数据库原生查询及页面渲染
public function querys(){$data['admin_list'] = DB::select('select * from admin');// echo '<pre>';// var_dump($res);// print_r($res);return view('querys',$data);}
<body>@foreach($admin_list as $key=>$val)<div>用户名：{{$val->username}}</div>@endforeach</body>
1、查看数据
// 原生查询操作public function querys(){$data['admin_list'] = DB::select('select * from admin limit 0,:n',['n'=>3]);// echo '<pre>';// var_dump($res);// print_r($res);return view('querys',$data);}
2、修改操作
// 修改操作public function updates(){$res = DB::update('update admin set ispasswd=1 where id=12');var_dump($res);}
int(1)表示的是受影响的行数
3、新增操作
// 新增操作public function inserts(){$res = DB::insert('insert into admin(username,password,real_name) values("mingzai","asdasdasdfasdf","明仔")');var_dump($res);}
4、删除操作
// 删除操作public function deletes(){$res = DB::delete('delete from admin where id=:n',['n'=>33]);var_dump($res);}
// 链式操作public function item(){// 原生$res = DB::select('select * from admin limit 0,:n',['n'=>1]);// 链式$res2 = DB::table('admin')->first();echo '<pre>';print_r($res);print_r($res2);}
// $res2 = DB::table('admin')->where('ispasswd',2)->where('gid','<>',10)->get();$res2 = DB::table('admin')->where(['ispasswd'=>2,'gid'=>0])->get();
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
