<?php
// 连接,选择数据库
$link = mysql_connect('localhost', 'root', '');
echo 'Connected successfully'."<br>";
mysql_select_db("school",$link);
$page_num=2;
if(!$page_no);
{
$page_no=1;
}
$start_num=$page_num*($_GET["page_no"]-1);//页号$page_no
// 执行 SQL 查询
$query = "SELECT * FROM articles limit $start_num,$page_num";
$result = mysql_query($query);
$num=@mysql_num_rows($result);
echo "行数=$num\n"."<br>";
for($i=0;$i<$num;$i++)
{
@mysql_data_seek($result,$i);
$data=@mysql_fetch_array($result);
echo "<pre>";
echo "id:$data[id],title:$data[title],body:$data[body]";
echo "</pre>";
}
echo "<a href='connect.php?page_no=".($_GET["page_no"]-1)."'>上一页</a> <a href='connect.php?page_no=".($_GET["page_no"]+1)."'>下一页</a>";
//关闭连接
mysql_close($link);
?>
浙公网安备 33010602011771号