# thinkphp 自由查詢語句分頁 ``` $search = I('get.k'); $sql="select a.title casetitle,a.default_pic,a.id caseid,b.title classtitle from `case` a,case_class b where a.case_class=b.id"; if (!empty($search)) { $sql=$sql." and a.title like '%$search%'"; } $q = M(); $pagesize = I('get.pagesize', 2, 'intval'); $count = count($q->query($sql));//總計條數 echo $count.$pagesize; $Page = new HelpBasePage($count, $pagesize, array(), false); // 實例化分頁類 傳入總記錄數和每頁顯示的記錄數(5) $list=$q->query($sql." limit $Page->firstRow,$Page->listRows"); $show = $Page->show(); $this->assign('pagination', $show); $this->assign('list', $list); $this->assign('search', $search); $this->display(); ```