1个回答
展开全部
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> <body> <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>
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
