留言本代码 - 简单分页 (PHP)

by dzjzmj, Thursday, May 22, 2008, 15:50
edited by dzjzmj, Thursday, May 22, 2008, 20:33

<!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=utf-8" />
<title>所有留言</title>
<link rel="stylesheet" type="text/css" href="style.css" media="all" />
</head>

<body>
<a href="add.php">发表留言</a>
<?php
require('common.php');
$countRow = mysql_fetch_array(mysql_query("SELECT count(*) FROM gb_content"), MYSQL_BOTH);
$count = $countRow[0]; //总行数
$_GET['page'] = intval($_GET['page']);
if ($_GET['page']<=0) {
	$_GET['page'] = 1;
}

$lines = 10; // 每页行数
$page = $_GET['page'];// 当前页
$limit = ($page - 1) * $lines;//起启行
$total = ceil($count/$lines); // 总页数
$result = mysql_query("SELECT * FROM gb_content order by id desc limit " .$limit. ','.$lines.'');//查询数据

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {// 取一条数据
?>
<table width="700" border="0" cellspacing="0" cellpadding="0" class="tb">
  <tr>
    <td class="bg"><b>[<?php echo htmlentities($row['username'],ENT_COMPAT,'utf-8') ?>]</b> 发表于：<?php echo htmlentities($row['insert_time'],ENT_COMPAT,'utf-8') ?></td>
  </tr>
  <tr>
    <td><?php echo htmlentities($row['content'],ENT_COMPAT,'utf-8') ?></td>
  </tr>
  <tr>
    <td align="right"><a href="edit.php?id=<?php echo $row['id'] ?>">修改</a> <a href="delete.php?id=<?php echo $row['id'] ?>">删除</a></td>
  </tr>
</table>
<?php
}
mysql_free_result($result);
if ($page>1) {
	echo '<a href="?page=1">首页</a> <a href="?page='. ($page-1) .'">上一页</a>';
}
if ($page<$total) {
	echo ' <a href="?page=' . ($page+1) .'">下一页</a> <a href="?page='.$total.'">末页</a>';
}
?>
</body>
</html>

查看代码执行结果

简单分页实现，下面我们将使用分页类实现

Tags: PHP 我来评分：高手一般菜鸟

Complete thread:

RSS Feed of thread

留言本代码 - 简单分页 - dzjzmj, 2008-05-22, 15:50 (PHP)

代码之家

留言本代码 - 简单分页 (PHP)