本文整理汇总了PHP中paging::setDisplayRows方法的典型用法代码示例。如果您正苦于以下问题:PHP paging::setDisplayRows方法的具体用法?PHP paging::setDisplayRows怎么用?PHP paging::setDisplayRows使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类paging
的用法示例。
在下文中一共展示了paging::setDisplayRows方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: paging
<?php
include "includes/configuration.php";
include "includes/paging.class_sub.php";
$title_text = "Caricature Styles and Samples:";
include DIR_INCLUDES . 'header.php';
$pagination_object = new paging();
$pagenum = $pagination_object->setPageNumber($_GET['page']);
$maxrows = $pagination_object->setDisplayRows(15);
$pagination_object->setURL($_SERVER['PHP_SELF'], base64_encode(serialize($_GET)));
$appquery .= "SELECT U . *,PT.user_id,SUM(product_price) as totalprice,SUM(product_turnaroundtime) as totalturntime FROM `toon_users` U, `toon_user_types` UT ,`toon_products` PT WHERE U.`utype_id` = UT.`utype_id` AND U.`user_id` = PT.`user_id` AND U.`user_status` = 'Active' AND U.`user_delete` = '0' AND UT.`utype_name` = 'Artist' AND PT.`product_delete`=0 GROUP BY PT.user_id";
if ($_REQUEST['srtby']) {
$sort = $_REQUEST['srtby'];
if ($sort == 1) {
$appquery .= " ORDER BY totalprice DESC";
} elseif ($sort == 2) {
$appquery .= " ORDER BY totalprice ASC";
} elseif ($sort == 3) {
$appquery .= " ORDER BY totalturntime ASC";
}
}
if (!$_REQUEST['srtby']) {
$appquery .= " ORDER BY U.`user_artist_priority` ASC";
}
$rs_artists = mysql_query($appquery);
$num = mysql_num_rows($rs_artists);
$sku_count = $pagination_object->setTotalPages($num);
if ($sku_count <= $pagenum) {
$pagenum = $pagination_object->setPageNumber($totalpages - 1);
}
$startrow = $pagination_object->setStartRow();