ecshop后台分页示例代码

<?php /** * ECSHOP 管理中心文章处理程序文件 * ============================================================================ * 版权所有 2005-2010 上海商派网络科技有限公司，并保留所有权利。 * 网站地址: http://www.ecshop.com； * ---------------------------------------------------------------------------- * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和 * 使用；不允许对程序代码以任何形式任何目的的再发布。 * ============================================================================ * $Author: liuhui $ * $Id: article.php 17095 2010-04-12 10:26:10Z liuhui $ */ define('IN_ECS', true); require(dirname(__FILE__) . '/includes/init.php'); /*------------------------------------------------------ */ //-- 文章列表 /*------------------------------------------------------ */ if ($_REQUEST['act'] == 'list') { /* 取得过滤条件 */ $filter = array(); $smarty->assign('ur_here', $_LANG['03_article_list']); $smarty->assign('action_link', array('text' => $_LANG['article_add'], 'href' => 'article.php?act=add')); $smarty->assign('full_page', 1); $smarty->assign('filter', $filter); $order_list = get_orderlist(); $smarty->assign('order_list', $order_list['arr']); $smarty->assign('filter', $order_list['filter']); $smarty->assign('record_count', $order_list['record_count']); $smarty->assign('page_count', $order_list['page_count']); assign_query_info(); $smarty->display('article_list.htm'); } /*------------------------------------------------------ */ //-- 翻页，排序 /*------------------------------------------------------ */ elseif ($_REQUEST['act'] == 'query') { check_authz_json('article_manage'); $order_list = get_orderlist(); $smarty->assign('order_list', $order_list['arr']); $smarty->assign('filter', $order_list['filter']); $smarty->assign('record_count', $order_list['record_count']); $smarty->assign('page_count', $order_list['page_count']); make_json_result($smarty->fetch('article_list.htm'), '', array('filter' => $order_list['filter'], 'page_count' => $order_list['page_count'])); } /* 获得文章列表 */ function get_orderlist() { $result = get_filter(); if ($result === false) { $filter = array(); /* 文章总数 */ $sql = 'SELECT COUNT(*) FROM ' .$GLOBALS['ecs']->table('orders'); $filter['record_count'] = $GLOBALS['db']->getOne($sql); $filter = page_and_size($filter); /* 获取文章数据 */ $sql = 'SELECT * FROM ' .$GLOBALS['ecs']->table('orders'); set_filter($filter, $sql); } else { $sql = $result['sql']; $filter = $result['filter']; } $arr = array(); $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']); while ($rows = $GLOBALS['db']->fetchRow($res)) { $rows['date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']); $arr[] = $rows; } return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']); } ?>