Question

php分页怎么写？

Answer 1

参考下：
<?php
header("Content-type:text/html;charset=utf-8");
require_once '../common/MySQL.class.php';
include_once '../config.php';
$db = new MySQL();
$sql = "SELECT id,i_time,i_title,i_content,i_state FROM tb_iss ";
//echo $sql;return ;
$db->db_query($sql);
$total = $db->db_num();

//每页最多显示记录数
$each_page = PAGE_SIZE;
//记录偏移量
$offset = intval($_GET['offset']);
?>

<link href="../css/style.css" rel="stylesheet" />
<script src="../js/client_js.js"></script>
<table width="765" border="1" cellpadding="0" cellspacing="0" class="big_td">
<tr>
<td height="33" background="../images/list.jpg" id="list">发布审核</td>
</tr>
</table>
<table align="center" width="765" border="0" cellpadding="0" cellspacing="0" bgcolor="#DEEBEF" class="big_td">
<tr>
<td height="30" colspan="5" align="center" valign="middle"><a href="add_issuance.php">发布申请</a></td>
</tr>
<tr>
<td width="100" height="25" align="center" valign="middle">日期</td>
<td width="100" height="25" align="center" valign="middle">标题</td>
<td width="100" height="25" align="center" valign="middle">内容</td>
<td width="100" height="25" align="center" valign="middle">是否批示</td>
<td width="100" height="25" align="center" valign="middle">操作</td>
</tr>
<?php
$sql = "SELECT id,i_time,i_title,i_content,i_state FROM tb_iss LIMIT $offset,$each_page";
$db->db_query($sql);
while ($row = $db->db_fetch_array()){
?>

<tr>
<td height="30"><?php echo $row['i_time']?></td>
<td height="30"><?php echo $row['i_title']?></td>
<td height="30"><?php echo $row['i_content']?></td>
<td height="30">
<?php
if ($row['i_state']==0){
echo "未审核";
}elseif ($row['i_state']==1){
echo "通过";
}else {
echo "未通过";
}

?>
</td>
<td height="30"><a href="modify_issuance.php?id=<?php echo $row['id'];?>">修改</a>||<a href="../control/del_issuance_chk.php?id=<?php echo $row['id'];?>" onclick="return del_mess();">删除</a></td>
</tr>
<?php
}//求出总页数算法
$totalPage = intval(($total-1)/$each_page+1);

//当前页$currentPage=$offset/$each_page+1;
//为分页准备
$last_offset = $offset - $each_page;
$next_offset = $offset + $each_page;
?>
<tr>
<td valign="top">
<hr width="1" size="1" noshade>
</td>
</tr>
<table width="420" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="430">
<div align="left"> 共有 <?php echo $total;?> 条 每页显示 <?php echo $each_page;?> 条 第 <?php echo $currentPage;?> 页/共 <?php echo $totalPage;?> 页</div>
</td>
<td width="269">
<div align="right">
<?php
if($last_offset < 0)
{
?>
首页 上一页
<a href="?offset=<?php echo $currentPage*$each_page?>" class="a1">下一页</a>
<a href="?offset=<?php echo ($totalPage-1)*$each_page?>"class="a1">尾页</a>
<?php
}
else{
?>
<a href="?offset=0" class="a1">首页</a>
<a href="?offset=<?php echo ($currentPage - 1)*$each_page-$each_page?>" class="a1">上一页</a>
<?php
if($next_offset>=$total)
{
?>
下一页 尾页
<?php
}
else
{
?>
<a href="?offset=<?php echo $currentPage*$each_page?>" class="a1">下一页</a>
<a href="?offset=<?php echo ($totalPage-1)*$each_page?>"class="a1">尾页</a>
<?php
}
}
?>
</div>
</td>
</tr>
</table>
</table>

Answer 2

强烈推荐用面向对象来写分页

Answer 3

上网找个php分页类吧