Question

thinkphp 分页 带入查询条件例子不成功

public function search() {
$site = D('Vod');
import("@.ORG.Page"); //导入分页类
$map = Array('video_id' => $_REQUEST ['search']); //重点！'SC_ID'为提交页面的post变量，一定要用$_REQUEST
$count = $site->where($map)->count();
$Page = new Page($count, 2);
$list = $site->where($map)->limit($Page->firstRow . ',' . $Page->listRows)->select();
foreach ($map as $key => $val) {
$Page->parameter .= "$key=" . urlencode ( $val ) . "&";
}
$page = $Page->show();
$this->assign('page', $page); // 赋值分页输出
$this->assign('list', $list);
$this->display(); // 输出模板
}
一共有5条记录按照要求查询出来的第一页显示了两条记录 ，然后点第二页的时候就是空白 浏览器上路径显示http://www.myapp.com/index.php/Index/search?video_id=488&p=2

Answer 1

$list = $member->limit(($page->nowPage-1)*2 . ',' . $page->listRows)->select();