ecshop后台新建一个模块添加分页的实现方法

<?php
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
require_once(ROOT_PATH . "includes/fckeditor/fckeditor.php");
require_once(ROOT_PATH . 'includes/cls_image.php');
$exc = new exchange($ecs->table("xj"), $db, 'id', 'title'); //这块 table里 存的是表名，改成你的表名，然后 id改成你的表里的主键的字段名，其余2处不用管
if(empty($_REQUEST['act'])){
$_REQUEST['act'] = 'list';
}
if($_REQUEST['act'] == 'list'){
//获取信息列表
$pzd_list = get_pzd_list();
$smarty->assign('pzd_list', $pzd_list['pzd_list']);
$smarty->assign('filter', $pzd_list['filter']);
$smarty->assign('record_count', $pzd_list['record_count']);
$smarty->assign('page_count', $pzd_list['page_count']);
//后台页面样式
$smarty->assign('full_page', 1);
//跳转页面
assign_query_info();
$smarty->display('yj_list.htm');//这里显示的是对应的html页面
}elseif ($_REQUEST['act'] == 'query'){//分页代码
//获取信息列表
$pzd_list = get_pzd_list();
$smarty->assign('pzd_list', $pzd_list['pzd_list']);
$smarty->assign('filter', $pzd_list['filter']);
$smarty->assign('record_count', $pzd_list['record_count']);
$smarty->assign('page_count', $pzd_list['page_count']);
//跳转页面
make_json_result($smarty->fetch('yj_list.htm'), '',
array('filter' => $pzd_list['filter'], 'page_count' => $pzd_list['page_count']));
}
//这里输出跳转的界面
//查询数据方法
function get_pzd_list()
{
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('xj');
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
//sql里的表名 改成自己的表名
$filter = page_and_size($filter);
/* 获活动数据 */
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('xj')." LIMIT ". $filter['start'] .", " . $filter['page_size'];
//表名改成自己的表名
$filter['keywords'] = stripslashes($filter['keywords']);
set_filter($filter, $sql);
$row = $GLOBALS['db']->getAll($sql);
$arr = array('pzd_list' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
?>

<!-导入js->
{insert_scripts files=”../js/utils.js,listtable.js”}

{foreach from=$pzd_list item=topic}
<tr>
<td>{$topic.id}</td>
<td>{$topic.add_time}</td>
<td>{$topic.name}</td>
<td>{$topic.iphone}</td>
<td><a href="goods.php?act=edit&goods_id={$topic.goods_id}">{$topic.goods_name}</a></td>
<td align="left" style="text-align:center;">
<a href="javascript:;" onclick="listTable.remove({$topic.id}, '{$lang.drop_confirm}')" title="{$lang.remove}" class="btn btn-primary btn-xs"><i class="icon-trash"></i>{$lang.remove}</a></td>
</tr>
{foreachelse}
<tr>
<td><div class="analysis_info fl">
<div class="analysis_text"><i></i>
<p>{$lang.no_records}</p>
</div>
</div></td>
</tr>
{/foreach}

{literal}
listTable.recordCount = {$record_count};
listTable.pageCount = {$page_count};
{foreach from=$filter item=item key=key}
listTable.filter.{$key} = '{$item}';
{/foreach}
{literal}
</script>