PHP;"> PHP $localhost = "localhost"; $username = "root"; $password = "root"; $db = "test"; //信息 $pagesize = 5; $conn = MysqL_connect($localhost,$username,$password); //链接数据库 if(!$conn){ echo "数据库链接失败".MysqL_error(); } MysqL_query("SET NAMES 'UTF8'"); //编码转化 $db_select = MysqL_select_db($db); //选择表 //查询记录总数 $total_sql = "select COUNT(*) from page"; $total_result = MysqL_query($total_sql); $total_row_arr = MysqL_fetch_row($total_result); $total_row = $total_row_arr[0]; //总条数 //总页数 $total = ceil($total_row / $pagesize); //当前页数 $page = @$_GET['p'] ? $_GET['p'] : 1; //limit 下限 $offset = ($page - 1)*$pagesize;

$sql = "select * from page order by id limit {$offset},{$pagesize}";
$result = MysqL_query($sql);
echo "

PHP分页代码的小模块

";
echo "@H_403_10@";
echo "<tr><td>ID</td><td>NAME</td></tr>";
while($row = MysqL_fetch_assoc($result)){
$id = $row['id'];
$name = $row['name'];
echo "<tr><td>".$id."</td><td>".$name."</td></tr>";
}
echo "</table>";
//上一页 、下一页
$pageprev = $page -1 ;
if($page > $total){
$pagenext = $total;
} else{
$pagenext = $page +1;
}
// 做链接 跳转；
echo "

上一页 丨下一页

";

MysqL_free_result($result);
MysqL_close($conn);
?>

sql;"> $sql = "select * from page order by id limit {$offset},{$pagesize}";