smarty的分页

来源：互联网发布：李小璐开的淘宝店名字编辑：程序博客网时间：2024/06/05 20:08

<?php include "config.php";$sql="select * from com_leader";$result=mysql_query($sql);$count=mysql_num_rows($result);$pageSize=2;$totalPage=ceil($count/$pageSize);if (@$_GET['page']) {$page=$_GET['page'];if ($page>$totalPage) {$page=$totalPage;}}else{$page=1;}$start=($page-1)*$pageSize;$sql_1="select * from com_leader limit {$start},$pageSize";//****$result_1=mysql_query($sql_1);$rows=array();while ($rs=mysql_fetch_assoc($result_1)) {$rows[]=$rs;}//注意:+1如果不加（）.会被解析成小数点而不是链接符号$html="<a href='leaderList.php?page=1'>首页</a>";$html.="|";$html.="<a href='leaderList.php?page=".($page-1)."'>上一页</a>";$html.="|";if ($page<=5) {for ($i=1; $i <= 10; $i++) { if ($i==$totalPage) {$html.="<a href='leaderList.php?page={$i}'>[".$i."]</a>";break;}$html.="<a href='leaderList.php?page={$i}'>[".$i."]</a>";}}else{for ($i=$page-4; $i <=$page+5 ; $i++) { if ($i==$totalPage) {$html.="<a href='leaderList.php?page={$i}'>[".$i."]</a>";break;}$html.="<a href='leaderList.php?page={$i}'>[".$i."]</a>";}}$html.="<a href='leaderList.php?page=".($page+1)."'>下一页</a>";$html.="|";$html.="<a href='leaderList.php?page=".$totalPage."'>尾页</a>";$st->assign('html',$html);/*为分页效果添加100条数据：for ($j=1; $j <=100 ; $j++) { $clName="aaa_".$j;$sql="insert into com_leader(clName) values('{$clName}')";mysql_query($sql);} */$st->assign('rows',$rows);$st->display('leaderList.html');?>

<pre name="code" class="html"><!DOCTYPE html><html lang="en"><head><meta charset="UTF-8"><title>Document</title><style type="text/css">*{font-size:14px;line-height: 30px;}</style></head><body><table align="center" border="1" cellpadding="0" cellspacing="0" width="800"><tr align="center"><td>负责人姓名</td><td>负责人邮箱</td><td>负责人电话</td><td>操作</td></tr><{section name=key loop=$rows}><tr align="center"><td><{$rows[key].clName}></td><td><{$rows[key].clEmail}></td><td><{$rows[key].clTel}></td><td>删除|修改</td></tr><{/section}><tr align="center"><td colspan="4"><{$html}></td></tr></table></body></html>

0 0