config.php
<?php
require_once("../libs/Smarty.class.php");
$smarty= new smarty();
$smarty->template_dir="../templates";
$smarty->config_dir="../configs";
$smarty->compile_dir="../templates_c";
//$smarty->caching=1;
//$smarty->cache_dir="../cache";
$mysqli=new mysqli("localhost","root","123456","hb");
$mysqli->query("set names utf8");
?>
php页面
<?php
require_once("config.php");
$sql="select * from admin";
$rs=$mysqli->query($sql);
$count=$rs->num_rows;
$num=4;
$pagecount=ceil($count/$num);
if($_GET['page']==""||$_GET['page']<1){
$page=1;
}
else{
$page=$_GET['page'];
if($page>$pagecount){
$page=$pagecount;
}
}
$start=($page-1)*$num;
$sql=$sql." limit $start,$num";
$rs1=$mysqli->query($sql);
while($a=$rs1->fetch_array()){
$aaa[]=$a;
}
$smarty->assign('aaa',$aaa);
$smarty->assign('page',$page);
$smarty->assign('pagecount',$pagecount);
$smarty->display("fy.html");
?>
html页面
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<table border="1">
<tr>
<td>用户名</td>
<td>密码</td>
<td>操作</td>
</tr>
{section name="bb" loop="$aaa"}
<tr>
<td>{$aaa[bb].admin_Name}</td>
<td>{$aaa[bb].admin_Pwd}</td>
<td><a href="../webroot/xg.php?id={$aaa[bb].admin_ID}">修改</a>/<a href="../webroot/sc.php?id={$aaa[bb].admin_ID}">删除</a></td>
</tr>
{/section}
</table>
<a href="../webroot/fy.php">首页</a>
<a href="../webroot/fy.php?page={$page-1}">上一页</a>
<a href="../webroot/fy.php?page={$page+1}">下一页</a>
<a href="../webroot/fy.php?page={$pagecount}">末页</a>
</body>
</html>