先贴张图看看效果
在贴一下代码吧
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;
echo "";
$sql = "select * from page order by id limit {$offset},{$pagesize}";
$result = MysqL_query($sql);
echo "
echo "
