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
thinkphp复合查询AND和OR同时使用
$m=M("Role_module");
$data["module_delete"]=array("eq",1);
$data["_string"] = " (module_name like "%{$keyword}%") OR ( module_description like
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.","