tp搜索 分页如何保留连表查询的条件

浏览:3138 发布日期:2014/06/27 分类:求助交流 关键字: 求助
原写法:
import("ORG.Util.Page");
$p = new Page($count, $limitRows);
$map['idNum'] = $this->_get('idNum');
$map['act_title'] = $this->_get('act_title');
$map['apply_time'] = $this->_get('apply_time');
$map['verified'] = $this->_get('verified');
foreach($map as $key=>$val) {

$p->parameter .= "$key=".urlencode($val)."&";

}
$page = $p->show();
$list = $credit->where($condition)->order('apply_time desc')->limit($p->firstRow.','.$p->listRows)->select();

如果是连表查询, uid = uid $map如何写 uid = uid
import("ORG.Util.Page");
$p = new Page($count, $limitRows);
$map['dateline'] = array('like',"%{$dateline}%");
$map['verified'] = 2; //审核成功
$map['is_recommend'] = 0;//还未被推荐过的活动
foreach($map as $key=>$val) {

$p->parameter .= "$key=".urlencode($val)."&";

}
$page = $p->show();
$sql = "SELECT a.act_title, a.dateline, a.applynumber, b.username FROM activity AS a INNER JOIN members AS b ON a.uid=b.uid WHERE a.verified=2 AND a.is_recommend=0 AND a.dateline LIKE"." '%{$dateline}%'"." ORDER BY dateline DESC LIMIT ".$p->firstRow.','.$p->listRows;
$list = $credit->query($sql);
最佳答案
评论( 相关
后面还有条评论,点击查看>>