1、原生查询示例:
$Model = new Model();$sql = "select a.id,a.title,b.content from think_test1 as a, think_test2 as b where a.id=b.id ".$map." order by a.id ".0." limit ".$p->firstRow.","
thinkphp复合查询AND和OR同时使用
$m=M("Role_module");
$data["module_delete"]=array("eq",1);
$data["_string"] = " (module_name like "%{$keyword}%") OR ( module_description like
1、原生查询示例:
1
$Model
= new
Model();
2
$sql
= "select a.id,a.title,b.content from think_test1 as a, think_test2 as b where a.id=b.id ".$map."
order by a.id ".$sort." limit ".$p->f
public function jifenjilu(){
$Model = new Model();
$sql = "select m.id,m.token,m.message,m.wecha_id,m.time,u.wechaname from pigcms_member_card_message as m, pigcms_userinfo as u whe