thinkphp6：數據庫增刪查改語句、表達式語句 **1.數據庫原生的增刪改查** ~~~ ?//用query方式(原生方式)查詢 ????????$data?=?Db::query('select?*?from?user?'); ????????echo?'<pre>'.print_r($data,true); ????????//原生方法插入 $execute?=?Db::execute("insert?into?user?set?`phone`='13211111111',`u_name`='一燈大師'?"); $execute?=?Db::execute("insert?into?user?set?`phone`?=?'13233334445',`u_name`?=?'小飛俠'"); ????????print_r($execute); ????????//原生方法更新 ?????????$execute?=?Db::execute("update?user?set?`u_name`='武三通'?where?`uid`=5?"); ?????????$execute?=?Db::execute("update?user?set?`u_name`?=?'月牙兒',?`phone`?=?'15643436653'?where?`uid`?=?16"); ?????????print_r($execute); ~~~ **2.用單鏈模式查詢** ~~~ ?//單鏈查詢方法之單條數據查詢,一般應用于只有一條數據的查詢,比如超級管理員,當前會員等等 ????????//?$find?=?Db::table('user')?->where('uid',1)?->?find(); ????????//?$find?=?Db::table('user')?->where('uid',1)?->find(); ????????//?print_r($find); ~~~ **3.用select,insert,save,update,delete方法** ~~~ //select方法查詢,select?方法查詢結果是一個二維數組，如果結果不存在，返回空數組 ???? $select?=?Db::table('user')?->?where('status',1)?->?select(); ???? print_r($select); ???? ? ???? //?查詢某個字段的值?value???,value?方法查詢結果不存在 ???? $value?=?DB::table('user')?->where('status',1)?->?value('u_name'); ???? print_r($value); ???? ???? ???? //?查詢某一列的值?column?,column('a','b'),a代表值?,b代表Key ???? $column?=?DB::table('user')?->where('age',22)?->?column('u_name','uid');? ???? print_r($column); ???? //?insert?方法添加數據成功返回添加成功的條數，通常情況返回1 ???? $insert?=?DB::table('user')?->insert(['u_name'?=>?'花兒菲兒','age'?=>?'16','sex'?=>?'2','phone'?=>?'13366662233']); ???? $data?=?['u_name'?=>?'日月星辰','age'?=>?'18','sex'?=>?'2','phone'?=>?'13366662233']; ???? $insert?=?Db::table('user')?->insert($data); ???? print_r($insert); ???? //save?方法統一寫入數據，自動判斷是新增還是更新數據（以寫入數據中是否存在主鍵數據為依據） ???? ???? //增加數據 ???? $data?=?['u_name'?=>?'高山流水','age'?=>?'20','sex'?=>?'1','phone'?=>?'13366662233']; ???? $save?=?Db::table('user')?->save($data); ???? //更新數據1 ???? $data?=?['u_name'?=>?'高山流水','age'?=>?'20','sex'?=>?'1','phone'?=>?'13366662233','uid'?=>?'20']; ???? $save?=?Db::table('user')?->save($data); ???? //更新數據2 ???? $data?=?['u_name'?=>?'高山流水','age'?=>?'20','sex'?=>?'1','phone'?=>?'13366662233','uid'?=>?'20']; ???? $save?=?Db::table('user')?->update($data); ???? //添加一條數據?insertGetId,添加數據成功返回添加數據的自增主鍵 ???? $data?=?['u_name'?=>?'逆流成河','age'?=>?'20','sex'?=>?'1','phone'?=>?'13366662233']; ???? $insertGetId?=?Db::table('user')?->insertGetId($data); ???? print_r($insertGetId); ???? //?添加多條數據?insertAll,insertAll?方法添加數據成功返回添加成功的條數 ???? $data?=?[ ???? ? ['u_name'?=>?'風中飄舞','age'?=>?'18','sex'?=>?'1','phone'?=>?'13366663344'], ???? ? ['u_name'?=>?'花兒亂顫','age'?=>?'16','sex'?=>?'1','phone'?=>?'13366665566'] ???? ? ]; ???? $insertAll?=?Db::table('user')?->insertAll($data); ???? print_r($insertAll); ???? //修改數據?update,可以使用where? ???? $data?=?['u_name'?=>?'枯葉蝴蝶','age'?=>?'20','sex'?=>?'1','phone'?=>?'13366662233']; ???? $update?=?Db::table('user')?->where('uid',13)?->update($data); ???? print_r($update); ~~~ **4.表達式方式** ~~~ ?? $select?=?Db::table('user')?->?where('uid','=','2')?->?select(); ???? print_r($select); ???? //<> ???? $select?=?Db::table('user')?->?where('uid','<>','2')?->?select(); ???? print_r($select); ???? //>= ???? $select?=?Db::table('user')?->?where('uid','>=','12')?->?select(); ???? print_r($select); ???? //< ???? $select?=?Db::table('user')?->?where('uid','<','9')?->?select(); ???? print_r($select); ???? //<= ???? $select?=?Db::table('user')?->?where('uid','<=','8')?->?select(); ???? print_r($select); ???? ???? //?查詢范圍如下,like,?wherelike,?not?like,?whereNotLike,?in,not?in?,null,?not?null,whereNotIn,?whereNotNull ???? ???? //like,%燕%為模糊查詢,%代表著文字,相當于占位符 ???? $select?=?Db::table('user')?->?where('u_name','like','%燕%')?->?select(); ???? print_r($select); ???? ???? //wherelike使用同上,但是()內不再寫like ???? $select?=?Db::table('user')?->?wherelike('u_name','%燕%')?->?select(); ???? print_r($select); ???? //not?like,%燕%為模糊查詢,%代表著文字,相當于占位符 ???? $select?=?Db::table('user')?->?where('u_name','not?like','%燕%')?->?select(); ???? print_r($select); ???? ???? //whereNotLike使用同上,但是()內不再寫like ???? $select?=?Db::table('user')?->?whereNotLike('u_name','%燕%')?->?select(); ???? print_r($select); ???? //between ???? $select?=?Db::table('user')?->?where('uid','between','1,2')?->?select(); ???? $select?=?Db::table('user')?->?whereBetween('uid','1,2')?->?select(); ???? print_r($select); ???? //not?between ???? $select?=?Db::table('user')?->?where('uid','not?between','1,5')?->?select(); ???? $select?=?Db::table('user')?->?whereNotbetween('uid','1,5')?->?select(); ???? print_r($select); ????????//in? ???? $select?=?Db::table('user')?->?where('uid','in','1,5')?->?select(); ???? print_r($select); ????????//not?in? ???? $select?=?Db::table('user')?->?where('uid','not?in','1,5')?->?select(); ???? print_r($select); ~~~