本文整理匯總了PHP中paging::pagerQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP paging::pagerQuery方法的具體用法？PHP paging::pagerQuery怎麽用？PHP paging::pagerQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類paging的用法示例。
在下文中一共展示了paging::pagerQuery方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: category
function category($id, $menuId, $fp = null)
{
//validation page type
$categoryName = $categoryDesc = null;
$label = app_param('label');
if ($id > 0) {
$flag = FQuery("pustaka_category", "id={$id}", '', 1);
} else {
if (!empty($label)) {
$label = app_param('label');
$label = str_replace("-", " ", $label);
$label = "AND tags LIKE '%" . $label . "%' ";
}
$flag = true;
}
//if page type is valid
if ($flag) {
$db = new FQuery();
$db->connect();
/************** Parameter Page ***************/
$per_page = 10;
$categoryId = $id;
if (empty($param)) {
$show_panel = 1;
$per_page = 10;
}
if (url_param('feed') == 'rss') {
$per_page = 10;
$pages = url_param('page');
if ($pages != null) {
$link = str_replace("?page={$pages}", "", getUrl());
redirect("{$link}?feed=rss");
}
}
if (isset($label)) {
$per_page = 10;
}
if (empty($per_page)) {
$per_page = 10;
}
//$fp is default page
if (!isset($fp) and !isset($label)) {
$categoryName = oneQuery('pustaka_category', 'id', $categoryId, 'name');
$categoryDesc = oneQuery('pustaka_category', 'id', $categoryId, 'description');
}
$level_access = Level_Access;
//$if category id is not found
if (!$categoryId and !isset($fp) and !isset($label)) {
echo pustaka_Page_Notfound;
} else {
if (isset($categoryName)) {
$whereCat = "AND category = {$categoryId}";
} else {
$whereCat = null;
}
//call paging class
loadPaging();
$paging = new paging();
$rowsPerPage = $per_page;
//paging results
$result = $paging->pagerQuery(FDBPrefix . 'pustaka_file', "*", "status=1 {$whereCat} {$label}", 'id DESC', $rowsPerPage);
$no = 0;
//count rows
$jml = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
/********** File Author ***********/
$author = $qr['author'];
/********** File Category ***********/
$catlink = categoryLink($qr['category']);
$category = oneQuery('pustaka_category', 'id', $qr['category'], 'name');
$category = "<a href='{$catlink}' title='See more {$category}'>{$category}</a>";
/********** pdf Link ***********/
$flink = "?app=pdf&view=item&id={$qr['id']}";
$link = make_permalink($flink, Page_ID);
$title = "<a href='{$link}'>{$qr['title']}</a>";
/********** File Labels ***********/
$labels = labelToLink($qr['tags']);
/********** File Compability ***********/
$this->perrows = $jml;
$this->show_panel = $show_panel;
$this->category[$no] = $category;
$this->catlink[$no] = $catlink;
$this->author[$no] = $author;
$this->title[$no] = $title;
$this->link[$no] = $link;
$this->labels[$no] = $labels;
$this->date[$no] = $qr['year'];
$this->hits[$no] = $qr['hits'];
$this->desc[$no] = $qr['description'];
if (url_param('feed') == 'rss' and url_param('feed') == 'rss' or app_param('label')) {
$this->description[$no] = $qr['description'];
}
if (defined('SEF_URL')) {
$link = link_paging('?');
} else {
if (checkhomepage()) {
$link = "?";
} else {
$link = "?app=pdf&view=category&id={$categoryId}";
$link = make_permalink($link, Page_ID);
//.........這裏部分代碼省略.........
示例2: item
function item($q, $menuId)
{
/* Call new FQuery */
$db = new FQuery();
$db->connect();
/* Set Access_Level */
$accessLevel = Level_Access;
$q = str_replace("'", "", $q);
$q = str_replace("/", "", $q);
$q = str_replace("\\", "", $q);
$q = str_replace('"', "", $q);
$q = str_replace(' ', " ", $q);
if (empty($q)) {
$q = $_SESSION['search'];
}
/* Call new paging */
loadPaging();
$paging = new paging();
$rowsPerPage = 10;
$keyword = trim($q);
//remove space before and after
$article = explode_query($q, 'article');
$title = explode_query($q, 'title');
$author = explode_query($q, 'author');
$tag = explode_query($q, 'tags');
$condition = "{$article} {$title} {$author} {$tag}";
$user = FQuery('user', "`name` LIKE '%{$q}%'", 'id');
/* Check total article by query */
FQuery('article', "status=1 AND (`author_id` ='{$user}' {$condition}) {$accessLevel}");
$total = mysql_affected_rows();
/* paging query */
$result = $paging->pagerQuery(FDBPrefix . 'article', "*,DATE_FORMAT(date,'%d %M %Y') as date,DATE_FORMAT(date,'%Y-%m-%d %H:%i:%s') as order_date", "status=1 AND (`author_id` ='{$user}' {$condition}) \n\t\t{$accessLevel}", 'order_date DESC', $rowsPerPage);
$no = 0;
$jml = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
//category
$category = oneQuery('article_category', 'id', $qr['category'], 'name');
$catlink = make_permalink("?app=article&view=category&id={$qr['category']}");
//autho
if (!empty($qr['author_id'])) {
if (!empty($qr['author'])) {
$author = $qr['author'];
} else {
$author = oneQuery('user', 'id', $qr['author_id'], 'name');
}
} else {
$author = "Administrator";
}
$strpos = 0;
$article = stripTags($qr['article']);
$article2 = strtolower($article);
$strpos = strpos("{$article2}", "{$q}");
$query = str_replace(", ", ",", $q);
$query = str_replace(" ,", ",", $q);
$query = trim($query);
if (strpos($query, ",")) {
$query = explode(",", $query);
} else {
$query = explode(" ", $q);
}
$i = 0;
$z = '';
$y = '';
foreach ($query as $v) {
$y[$i] = $v;
$i++;
}
for ($n = $i * $i - 1; $n >= 0; $n--) {
}
if ($strpos >= 40) {
$strpos = $strpos - 40;
$article2 = substr("{$article2}", $strpos);
$strpos2 = strpos("{$article2}", " ");
$article = substr("{$article}", $strpos + $strpos2);
$article = "..." . $article;
}
$article = cutWords($article, 35);
$article .= "...";
$link = "?app=article&view=item&id={$qr['id']}";
$link = make_permalink($link, Page_ID);
$qr['title'] = search_match($qr['title'], $q);
$article = search_match($article, $q);
$author = search_match($author, $q);
$category = search_match($category, $q);
$title = "<a href=\"{$link}\">{$qr['title']}</a>";
$readmore = null;
$this->category[$no] = $category;
$this->catlink[$no] = $catlink;
$this->readmore[$no] = $readmore;
$this->author[$no] = $author;
$this->title[$no] = $title;
$this->date[$no] = $qr['date'];
$this->article[$no] = $article;
$this->perrows = $jml;
$this->total = $total;
if (defined('SEF_URL')) {
$link = link_paging('?');
} else {
$link = "?app=article&view=category&id={$categoryId}";
$link = make_permalink($link, Page_ID);
//.........這裏部分代碼省略.........
示例3: category
function category($id, $fp = null)
{
$db = new FQuery();
$db->connect();
$param = oneQuery('menu', 'id', Page_ID, 'parameter');
$show_panel = mod_param('show_name', $param);
$read_more = mod_param('read_more', $param);
$per_page = mod_param('per_page', $param);
$this->sname = mod_param('show_name', $param);
$this->sgroup = mod_param('show_group', $param);
$this->sgender = mod_param('show_gender', $param);
$this->saddress = mod_param('show_address', $param);
$this->semail = mod_param('show_email', $param);
$this->sjob = mod_param('show_job', $param);
$this->slinks = mod_param('show_links', $param);
$this->sphone = mod_param('show_phone', $param);
$this->sphoto = $sphoto = mod_param('show_photo', $param);
$groupId = app_param('id');
$whereCat = "AND group_id = {$id}";
$sql = $db->select(FDBPrefix . 'contact', '*', 'status = 1 AND group_id=' . $id);
$qr = @mysql_fetch_array($sql);
if (empty($qr['id'])) {
echo "<h3>Opps, Contact group is empty!";
} else {
loadPaging();
$paging = new paging();
$rowsPerPage = $per_page;
$result = $paging->pagerQuery(FDBPrefix . 'contact', "*", "status=1 {$whereCat}", 'id ASC', $rowsPerPage);
$no = 0;
$sum = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
$group = oneQuery('contact_group', 'id', $qr['group_id'], 'name');
$vlink = "?app=contact&view=person&id={$qr['id']}";
$link = make_permalink($vlink, Page_ID);
$title = "<a href=\"{$link}\">{$qr['name']}</a>";
if (empty($read_more)) {
$read_more = "read more...";
}
$readmore = "<a href=\"{$link}\"class='readmore'>{$read_more}</a>";
$comment = FQuery('comment', "link='{$vlink}'AND status=1");
$name = "<a href='{$link}'>{$qr['name']}</a>";
if ($sphoto == 1 and !empty($qr['photo'])) {
$photo = "<img src=\"{$qr['photo']}\" width=\"150px\">";
}
if (!empty($qr['email'])) {
$email = "<a href='mailto:{$qr['email']}' title=\"send mail to {$qr['name']}\">{$qr['email']}</a>";
} else {
$email = "";
}
if (!empty($qr['photo'])) {
$photo = "<img src='{$qr['photo']}' title=\"{$qr['name']}'s contact photo\" />";
}
if (!empty($qr['tw'])) {
$tw = " <a href='http://twitter.com/{$qr['tw']}' title=\"follow {$qr['name']} on twitter\" target='_blank'><img src='" . FUrl . "apps/app_contact/theme/images/tw.png'></a>";
}
if (!empty($qr['fb'])) {
$fb = " <a href='http://facebook.com/{$qr['fb']}' title=\"find {$qr['name']} on facebook\" target='_blank'><img src='" . FUrl . "apps/app_contact/theme/images/fb.png'></a>";
}
if (!empty($qr['web'])) {
$web = " <a href='http://{$qr['web']}' title=\"visit {$qr['name']}'s website\" target='_blank'><img src='" . FUrl . "apps/app_contact/theme/images/web.png'></a>";
}
if (!empty($qr['ym'])) {
$ym = " <a href='ymsgr:sendIM?{$qr['ym']}' title=\"chat with {$qr['name']} via YahooMasangger\"><img src='" . FUrl . "apps/app_contact/theme/images/ym.png'></a>";
}
if (isset($ym) or isset($fb) or isset($tw) or isset($web)) {
$links = $ym . $fb . $tw . $web;
} else {
$links = '';
}
$this->perrows = $sum;
$this->name[$no] = $name;
$this->photo[$no] = $photo;
$this->group[$no] = $group;
$this->gender[$no] = $qr['gender'];
$this->address[$no] = $qr['city'] . ", " . $qr['country'];
$this->email[$no] = @$qr['email'];
$this->job[$no] = $qr['job'];
$this->links[$no] = $links;
$this->phone[$no] = $qr['phone'];
$this->fax[$no] = $qr['fax'];
$this->per_page = $per_page;
$ym = $fb = $tw = $web = null;
//reset $link variable;
if (defined('SEF_URL')) {
$link = link_paging('?');
} else {
$link = "?app=contact&view=group&id={$groupId}";
$link = make_permalink($link, Page_ID);
$link = $link . "&";
}
$no++;
}
$db->select(FDBPrefix . 'contact', '*', "status=1 {$whereCat}");
$jml = mysql_affected_rows();
if ($jml > $rowsPerPage) {
$pagelink = $paging->createPaging($link);
} else {
$pagelink = null;
}
$this->pagelink = $pagelink;
//.........這裏部分代碼省略.........
示例4: category
function category($type, $id = null, $format = null)
{
$link = null;
/* Set global parameter */
$show_panel = menu_param('show_panel', Page_ID);
$show_rss = menu_param('show_rss', Page_ID);
$read_more = menu_param('read_more', Page_ID);
$per_page = menu_param('per_page', Page_ID);
$intro = menu_param('intro', Page_ID);
if (empty($intro)) {
$intro = $per_page;
}
/* Set Access_Level */
$accessLevel = Level_Access;
if ($type == 'archives') {
$where = "status=1";
} else {
if ($type == 'category') {
$catName = categoryInfo('name', $id);
$catDesc = categoryInfo('description', $id);
$catLink = categoryLink($id);
$where = "status=1 AND category = {$id}";
} else {
if ($type == 'featured') {
$where = "status=1 AND featured = 1";
} else {
if ($type == 'tag') {
if (empty($per_page)) {
$per_page = 10;
}
$tag = app_param('tag');
$tag = str_replace("-", " ", $tag);
$where = "status=1 AND tags LIKE '%" . $tag . "%'";
}
}
}
}
if (_FEED_ == 'rss') {
$per_page = 20;
$pages = url_param('page');
if ($pages != null) {
$link = str_replace("?page={$pages}", "", getUrl());
redirect("{$link}?feed=rss");
}
}
loadPaging();
$paging = new paging();
$result = $paging->pagerQuery(FDBPrefix . 'article', "*,\n\t\tDATE_FORMAT(date,'%d %M %Y') as date,\n\t\tDATE_FORMAT(date,'%Y-%m-%d %H:%i:%s') as order_date,\n\t\tDATE_FORMAT(date,'%a, %m %d %Y %H:%i:%s') as time,\n\t\tDATE_FORMAT(date,'%d') as f,\n\t\tDATE_FORMAT(date,'%D') as d,\n\t\tDATE_FORMAT(date,'%b') as b,\n\t\tDATE_FORMAT(date,'%a') as a,\n\t\tDATE_FORMAT(date,'%W') as D,\n\t\tDATE_FORMAT(date,'%m') as n,\n\t\tDATE_FORMAT(date,'%M') as m,\n\t\tDATE_FORMAT(date,'%y') as y,\n\t\tDATE_FORMAT(date,'%Y') as Y,\n\t\tDATE_FORMAT(date,'%h') as h,\n\t\tDATE_FORMAT(date,'%H') as H,\n\t\tDATE_FORMAT(date,'%p') as p,\n\t\tDATE_FORMAT(date,'%i') as i,\n\t\tDATE_FORMAT(date,'%s') as s", "{$where} {$accessLevel}", 'order_date DESC', $per_page);
$no = 0;
$perrows = mysql_affected_rows();
while ($qr = mysql_fetch_array($result)) {
/* Category Details */
$catLinks = categoryLink($qr['category']);
$category = categoryInfo('name', $qr['category']);
$catHref = "<a href='{$catLinks}'>{$category}</a>";
/* Author */
if (empty($qr['author'])) {
$author = userInfo('name', 1);
} else {
$author = $qr['author'];
}
/* Article Links */
$link = "?app=article&view=item&id={$qr['id']}";
$vlink = str_replace("&", "&", $link);
$vlink = make_permalink($vlink);
/* Article Title */
$title = "<a href='{$vlink}'>{$qr['title']}</a>";
$link = make_permalink($link);
/* Article Tags */
$tags = tagToLink($qr['tags']);
/* Article Content */
$article = $qr['article'];
if (checkLocalhost()) {
$article = str_replace(FLocal . "media/", "media/", $article);
$article = str_replace("/media/", FUrl . "media/", $article);
}
$comment = null;
/* Article Comments */
$comm = FQuery('comment', "link='{$link}'AND status=1");
if (FQuery('apps', "folder='app_comment'")) {
$comment = "<a class='send-comment' href='{$link}#comment'>";
if ($comm > 1) {
$comment .= "<span>{$comm}</span> " . Comments;
}
if ($comm == 1) {
$comment .= "<span>{$comm}</span> " . Comment;
}
if ($comm < 1) {
$comment .= Send_Comment;
}
$comment .= "</a>";
}
$scomment = mod_param('show_comment', articleInfo('parameter', $qr['id']));
if (!$scomment) {
$comment = '';
}
/* Read More */
if (empty($read_more)) {
$read_more = Readmore;
}
//.........這裏部分代碼省略.........