PHP core::pagination方法代码示例

 public static function mainPage()
 {
     $allCount = self::$db->query("SELECT COUNT(*) as cnt, c.`contentID`, cc.`contentID` FROM `content` as c, " . "`content_category` as cc WHERE cc.`contentID`=c.`contentID` AND c.`showOnSite`='Y'")->fetch();
     $sqlData = blog::getPosts(core::pagination($allCount["cnt"]))->fetchAll();
     //if ($sqlData)
     //{
     //blog::highlightCode ($sqlData, "short");
     //}
     return $sqlData;
 }

 function date()
 {
     system::setParam("page", "blogByDate");
     $offset = 1;
     if (isset($this->get["offset"])) {
         $offset = intval($this->get["offset"]);
     }
     $cacheID = "DTSELECT|ARTICLE|dateoffset_{$offset}";
     if (isset($this->args[1])) {
         $date = preg_replace("/[^0-9.]/uims", '', $this->args[1]);
         $cacheID = $date . "|" . $cacheID;
     }
     $this->smarty->setCacheID($cacheID);
     if (!$this->smarty->isCached()) {
         $allCount = $this->db->query("SELECT COUNT(*) as cnt FROM `content` as c, `content_category` as cc, `categories` as cts WHERE \n            cc.`contentID`=c.`contentID` AND c.`type`='article' AND cts.`categoryID`=cc.`catID` AND c.`showOnSite`='Y' AND c.`dt` >= \n            STR_TO_DATE ('?', '%d.%m.%Y')", $date)->fetch();
         $posts = news::getPostsByDate($date, core::pagination($allCount["cnt"], $offset), "article")->fetchAll();
         $this->smarty->assign("posts", $posts);
         $this->smarty->assign("date", $date);
     }
 }

 public static function buildList($target, $type = "", array $clause = array())
 {
     if ($type) {
         if ($target == "categories") {
             // временный костыль
             $clause[] = "`catType`='{$type}'";
         } else {
             $clause[] = "`type`='{$type}'";
         }
     }
     $clauseSTR = "";
     if ($clause) {
         $clauseSTR = implode(" AND ", $clause);
     }
     if ($clauseSTR) {
         $clauseSTR = "WHERE {$clauseSTR}";
     }
     $columns = self::$db->query("SHOW COLUMNS FROM `{$target}`")->fetchAll();
     if (isset($_GET["action"])) {
         switch ($_GET["action"]) {
             case "delete":
                 $id = array_keys($_GET);
                 $keyName = $id[count($_GET) - 1];
                 $id = intval($_GET[$keyName]);
                 self::$db->query("DELETE FROM `{$target}` WHERE `?`=?", $keyName, $id);
                 if ($target == "content") {
                     self::$db->query("DELETE FROM `content_category` WHERE `id`=?", $id);
                     self::$smarty->clearCache(null, "MAINPAGE|SEARCH_RES|BLOG|CATSELECT|RSS");
                 }
                 break;
         }
     }
     if (isset($_POST["groupDelete"]) && !empty($_POST["rows"])) {
         self::$db->query("DELETE FROM `{$target}` WHERE `" . $columns[0]["Field"] . "` IN (" . implode(",", $_POST["rows"]) . ")");
     }
     $mysqlLimits = array();
     $offset = 0;
     $allCount = self::$db->query("SELECT COUNT(*) as cnt FROM `{$target}` {$clauseSTR}")->fetch();
     $mysqlLimits = core::pagination($allCount["cnt"]);
     $sort = $columns[0]["Field"];
     $direction = "DESC";
     if (isset($_GET["direction"]) && $_GET["direction"]) {
         if ($_GET["direction"] == "DESC") {
             $direction = "ASC";
         } else {
             if ($_GET["direction"] == "ASC") {
                 $direction = "DESC";
             }
         }
     }
     if (isset($_GET["sort"]) && $_GET["sort"]) {
         $sort = $_GET["sort"];
     }
     self::$smarty->assign("direction", $direction);
     self::$smarty->assign("sort", $sort);
     $res = self::$db->query("SELECT * FROM `{$target}` {$clauseSTR} ORDER BY `{$sort}` {$direction} LIMIT \n\t\t\t{$mysqlLimits["start"]},{$mysqlLimits["end"]}");
     if ($target != "categories") {
         $res->runAfterFetchAll[] = array("blog", "makeSlug");
     }
     $data = $res->fetchAll();
     self::$smarty->assign("list", $data);
     return $data;
 }

 public static function mailOutbox($offset = 1)
 {
     $userID = intval($_SESSION["user"]["userID"]);
     $_SESSION["user"]["mail"]["box"] = "outbox";
     $cntOut = self::$db->query("SELECT COUNT(*) as cnt FROM `messages`,`users` WHERE `userID`=`senderID` AND `userID`=?", $userID)->fetch();
     $cntIn = self::$db->query("SELECT COUNT(*) as cnt FROM `messages` WHERE `receiverID`=?", $userID)->fetch();
     self::$smarty->assign("cntOut", $cntOut["cnt"]);
     self::$smarty->assign("cntIn", $cntIn["cnt"]);
     $limits = core::pagination($cntIn["cnt"], $offset);
     return self::$db->query("SELECT * FROM `messages` as m LEFT JOIN " . "`users` as u ON u.`userID`=m.`receiverID` WHERE m.`senderID`=? ORDER BY m.`dt` DESC LIMIT " . implode(",", $limits), $userID);
 }