<?phpnamespace app/index/controller;use think/Db;class Demo{//1、全局配置 config/database.php配置public function dbTest(){return Db::table('pzq_article')->where('id','29')->value('title');}//2、動態配置 think/db/Query.php中有一個方法connect()public function dbTest2(){return Db::connect(['type'=>'mysql','hostname'=>'localhost','database'=>'top789','username'=>'root','password'=>'root',])->table('pzq_article')->where('id','76')->value('title');}//3、DSN連接public function dbTest3(){$dsn = 'mysql://root:root@localhost:3306/top789#utf8';return Db::connect($dsn)->table('pzq_article')->where('id','88')->value('title');}//4、單條查旬public function dbTest4(){$res = Db::table('pzq_article')->field(['title'=>'標題','id'=>'編號'])//可添加別名->where('id','=',20)//如果是等號，=可以省略->find();//如果是主鍵查詢，可省略上面where,這行寫->find(20);dump(is_null($res)?'沒有查到':$res);}//5、多條查旬public function dbTest5(){$res = Db::table('pzq_article')->field(['id','cat_id','title'])->where([['id','>',20],['cat_id','=',2],])//一個條件，直接用表達式->where('id','>',20)。多個條件用數組->order('id desc')->limit(3)->select();if(empty($res)){return '沒有查到';}else{dump($res);}}//6、數據添加public function dbTest6(){$data = ['name'=>'Sam2','age'=>'29','posttime'=>time()];$dataall=[['name'=>'Sam3','age'=>'29','posttime'=>time()],['name'=>'Sam4','age'=>'30','posttime'=>time()],];//(1)單條插入//return Db::table('test')->data($data)->insert();//(2)插入同時返回新增主鍵id//return Db::table('test')->insertGetId($data);//(3)插入多條數據return Db::table('test')->data($dataall)->insertAll();}//更新數據public function dbTest7(){// return Db::table('test')// ->where('id','=',4)// ->update(['name'=>'SamC','age'=>'31']);//如果where條件是主鍵，還可以如下使用return Db::table('test')->update(['name'=>'SamCheng','age'=>'30','id'=>4]);}//刪除操作public function dbTest8(){//return Db::table('test')->delete(6);//或者return Db::table('test')->where('id',5)->delete();}//mysql原生語句 查詢public function dbTest9(){$sql = "select name,age from test where id>2";dump(Db::query($sql));}//mysql 增、刪、改 用Db::execute($sql)public function dbTest10(){//$sql = "update test set name='samC' where id=4";//$sql = "insert test set name='Yan',age='30'";$sql = "delete from test where id=4";return Db::execute($sql);}}