本文整理匯總了PHP中Paging::bySQL方法的典型用法代碼示例。如果您正苦於以下問題：PHP Paging::bySQL方法的具體用法？PHP Paging::bySQL怎麽用？PHP Paging::bySQL使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Paging的用法示例。
在下文中一共展示了Paging::bySQL方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getLists
public static function getLists($user_id, $page, $page_size)
{
$user_id = (int) $user_id;
if (!$user_id) {
return array();
}
$table = self::table();
$sku_table = ProductsSku::table();
$item_table = ProductsItem::table();
$sql = " SELECT a.id, b.id AS skuid, c.title, b.sku, b.sku_name, b.current_price FROM {$table} AS a, {$sku_table} AS b, {$item_table} AS c WHERE b.item=c.item AND a.sku_id=b.id AND a.user_id='{$user_id}' ORDER BY a.id DESC";
$lists = Paging::bySQL($sql, $page, $page_size, 'a');
ProductsSku::getProductsPic($lists['data']);
return $lists;
}示例2: RIGHT
if (!$keyword) {
//DB::Debug();
$order = Orders::paging($page, $page_size, $where, "id DESC", "*");
} else {
if ('bh' == $keyword) {
//DB::Debug();
$ordertable = Orders::table();
$orderproducttable = OrdersProducts::table();
$sql = " SELECT a.* FROM {$ordertable} AS a, {$orderproducttable} AS b WHERE RIGHT(a.order_code,2)='BH' AND a.order_code=b.order_code AND a.user_code='{$user_code}' ORDER BY a.id DESC";
$order = Paging::bySQL($sql, $page, $page_size, 'a');
} else {
//DB::Debug();
$ordertable = Orders::table();
$orderproducttable = OrdersProducts::table();
$sql = " SELECT a.* FROM {$ordertable} AS a, {$orderproducttable} AS b WHERE (RIGHT(a.order_code,2)='SK' OR LEFT(a.order_code,4)='FXAD') AND a.order_code=b.order_code AND a.user_code='{$user_code}' AND (a.order_code LIKE '%{$keyword}%' OR b.product_sku LIKE '%{$keyword}%') GROUP BY a.order_code ORDER BY a.id DESC";
$order = Paging::bySQL($sql, $page, $page_size, 'a');
}
}
}
$orders = $order['data'];
$paged = $order['page'];
foreach ($orders as $k => $order) {
$order_code = $order['order_code'];
$products = OrdersProducts::getUserProducts($order_code);
$tmp = array();
//獲取各個PRODCUT STOCK
$len = count($products);
for ($i = 0; $i < $len; $i++) {
if (!isset($products[$i])) {
continue;
}