$db=Db::name('s_admin');
==========================《正文开始》============================
buildSql();//返回当前的sql语句
$res=$db->where([ 'id'=>1, ])->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` = 1 ) $res=$db->where('id=1')->buildSql(); //( SELECT * FROM `s_admin` WHERE ( id=1 ) ) $res=$db->where("id",1)->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` = 1 ) $res=$db->where("id","<>",1)->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` <> 1 )//传入三个参数,这是我们常用的方法
#备注表达式 #EQ = #NEQ <> #LT < #ELT <= #GT > #EGT >= #BETWEEN BETWEEN * AND * #NOTBETWEEN NOTBETWEEN * AND * #IN IN(*,*) #NOTIN NOT IN(*,*)
#where常规用法
$res=$db->where("id","NEQ",1)->buildSql(); $res=$db->where("id","EGT",1)->buildSql(); //第二个操作可以是大写、小写、符号 $res=$db->where("id","BETWEEN","1,5")->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` BETWEEN 1 AND 5 )第三个参数为字符串 $res=$db->where("id","NOTBETWEEN",[1,10])->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` NOT BETWEEN 1 AND 10 )第三个参数为数组 $res=$db->where("id","in",[1,10,50])->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` IN (1,10,50) ) $res=$db->where("id","in","1,10,50")->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` IN (1,10,50) )
#where里面加数组
$res=$db->where([ 'id' =>['in',[1,2,3,4]] ])->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` IN (1,2,3,4) ) $res=$db->where([ 'id' =>['in',[1,2,3,4]], 'a_name'=>'花花' ])->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` IN (1,2,3,4) AND `a_name` = '花花' )
#where里面加条件表达式
$res=$db->where("id","EXP","NOT IN (1,2,3)")->buildSql(); //( SELECT * FROM `s_admin` WHERE ( `id` NOT IN (1,2,3) ) $res=$db->where("id","in","IN (1,2,3)")->whereOr("a_name",'eq','张三')->buildSql(); //( SELECT * FROM `s_admin` WHERE `id` IN (0,2,3) OR `a_name` = '张三' )
==========================《正文结束》============================
dump($res);
tp5查询构造器
最新推荐文章于 2022-07-10 14:31:39 发布