smarty Pager

$id   = $_GET['id'];
$page = $_GET['pos'];

$page      = '' == $page ? 0 : $page;
$totalpage = 0;
$pagesize  = 50;

$table = 'items';
$where = "id=$id";

$query = array(
	'table'  => $table,
	'where'  => $where
);
$count = sqlCount($query);
$totalpage = ceil($count / $pagesize);

$query = array(
	'table'  => $table,
	'fields' => array('id', 'name'),
	'where'  => $where,
	'order'  => 'name',
	'limit'  => $page*$pagesize.','.$pagesize
);
$items = sqlSelect($query);

$smarty->assign('items', $items);
$smarty->assign('totalpage', $totalpage);

 php

 

 

{pager rowcount=$totalpage limit=1 shift=1 no_first=true separator="|" class_numon="curpage" txt_prev="上一页" txt_next="下一页" txt_pos="side"}

{foreach from=$items item=item}
{$item.id}: {$item.name}<br />
{/foreach}

  smarty模板