[PHP][thinkphp5] 學習一：增刪改查

標籤：php5   fetch   val   data   delete   括弧   預設   into   word   

 1 <?php 2 namespace app\index\controller; 3  4 use think\Controller; 5 use think\Db; 6  7 class Test extends Controller 8 { 9 10     public function index()11     {12         $name ="Hello word TP5";13         14         $this->assign(‘name‘,$name);15 16         return $this->fetch();17     }18 19     public function select()20     {21         //增22         //$res = DB::name(‘lee_user‘)->insert([‘uname‘=>‘lpc‘]);23         $res = DB::execute("insert into lee_user(uname) values(:uname) ",[‘uname‘=>‘tp5‘]);24         25         //刪26         //$res = DB::name(‘lee_user‘)->delete(3);//括弧裡預設是ID27         //$res = DB::name(‘lee_user‘)->delete([‘uname‘=>5]);//這個就執行成功啦,刪除ID是5的28         //$res = DB::name(‘lee_user‘)->delete(‘uname‘=>2);//這就沒執行成功29         30         //改31         // $res = DB::query(" update lee_user set uname=‘23‘ where uid = 4");32          if($res)33          return $this->fetch(‘index‘); 34 35         //查詢36         // $data = DB::name(‘lee_user‘)->find();37         // $this->assign(‘data‘,$data);38         //return $this->fetch(‘add‘);39     }40 }

 

[PHP][thinkphp5] 學習一：增刪改查