当前位置: 首页>>代码示例>>PHP>>正文


PHP Paging::bySQL方法代码示例

本文整理汇总了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;
 }
开发者ID:isonz,项目名称:fxptpcn,代码行数:14,代码来源:Favorite.class.php

示例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;
        }
开发者ID:isonz,项目名称:fxptpcn,代码行数:31,代码来源:home.php


注:本文中的Paging::bySQL方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。