求PHP多件查詢完整代碼和結果分頁？MYSQL數據表class 搜索字段：學號、姓名、班級、入學時間、省份、地區

//分頁處理:

$Previous_page=$page-1;

$next_page=$page+1;

if ($Previous_page<0){

echo "上頁";

echo "<a href=?page=$next_page>下頁</a>";

}

else if ($page<=$i/$max){

echo "<a href=?page=$Previous_page>上頁</a>";

echo "<a href=?page=$next_page>下頁</a>";}

else{

echo " <a href=?page=$Previous_page>上頁</a>";

echo "下頁";

}

查詢就是要：

$con = mysql_connect("localhost","root","123456");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

else

{

echo "連接成功";

}

//

mysql_select_db("student", $con);

//查詢方法

$result = mysql_query("SELECT * FROM parker");

//得到結果集

echo'<br />';

echo "<table border='1'>

<tr>

<th >id</th>

<th>name</th>

</tr>";

while($row = mysql_fetch_array($result))

{

echo "<tr>";

echo "<td>" . $row['id'] . "</td>";

echo "<td>" . $row['name'] . "</td>";

echo "</tr>";

}

echo "</table>";mysql_close($con);