### pageBySql **動態構建某一頁select sql并執行** **參數** \* 1.$sql:傳入的基本select語句 \* 2.$param:構造sql所需參數 \* 返回： Array 二維數組.第一維是所有記錄，第二維是某條記錄的字段數組 ~~~ function pageBySql($sql) { //構建group by $groupBy = $this->groupBy; $countPos=strpos ( $sql, "@" ); //拼裝搜索條件 $sql = $this->createQuery ( $sql, $this->searchArr ); if(empty($countPos)){ $countPos=strpos ( $sql, "from" ); }else{ $sql=str_replace ( "@", "", $sql ); } if (isset ( $groupBy ) && $groupBy != "" && $groupBy != "id") { $groupBy = " group By $groupBy "; $countsql = "select 0 " . substr ( $sql, $countPos ); //$countsql = $this->createQuery ( $countsql, $this->searchArr ); $countsql = "select count(0) as num from ( " . $countsql . " " . $groupBy . " ) as t"; } else { //構造獲取記錄數sql $countsql = "select count(0) as num " . substr ( $sql, $countPos ); //$countsql = $this->createQuery ( $countsql, $this->searchArr ); //TODO;待優化，無需執行兩次createQuery } //print($countsql); $this->count = $this->queryCount ( $countsql ); //拼裝聚合函數 $sql .= $groupBy; //構建排序信息 if(!empty($this->sort)){ $asc = $this->asc ? "DESC" : "ASC"; //echo $this->asc; $sql .= " order by " . $this->sort . " " . $asc; } $this->listSql=$sql; //print($sql); //構建獲取記錄數 $sql .= " limit " . $this->start . "," . $this->pageSize; //echo $sql; return $this->_db->getArray ( $sql ); } ~~~