在laravel中我们有很多种方法来操作数据库

今天我们来看看如何用DB来执行原生的sql

首次在controller中用

use IlluminateSupportFacadesDB;

public function db(){
       //添加数据
       DB::insert("insert into `table` ( `value`, version) values (?, ? )",[1, 'Laravel']);
       DB::insert("insert into `table` set `value`=?,version=?",['value1','1']);
               
       //查询
       $user = DB::select('select * from `table` where id = ?', [1]);
       echo "<pre>";
       print_r(get_object_vars($user[0]));
       $user = DB::select('select * from `table` where id = :id', [':id'=>2]);
       print_r(get_object_vars($user[0]));
               
       //更新
       $result = DB::update('update `table` set value="laraveltest" where id = ?', ['1']);
       if($result){
           echo "修改成功!";
       }else{
           echo "修改失败";
       }
               
       //删除
       $deleted = DB::delete("delete from `table` where id=?",[3]);
       if($deleted){
           echo "删除成功";
       }else{
           echo "删除失败";
       }
   }

如有问题，可以QQ搜索群1028468525加入群聊，欢迎一起研究技术

有疑问联系站长，请联系QQ：