<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                ### 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 ); } ~~~
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看