连接数据库，并将结果 显示分页

<?php// 显示分页// 连接数据库 分别为mysqli 和mysql// $myslqi=mysqli_connect("localhost","root","password","db")$conn = mysql_connect ( "localhost", "root", "passrord" ) or die ( "链接失败" . mysql_error () );// 设置编码mysql_query ( "set names utf8" );// 选择数据库mysql_select_db ( "db", "$conn" );// 每页显示多少条记录$pageSize = 3;// 此值要从数据库表获取$rowCount = 0;// 默认显示第1页 用户指定显示第几页$pageNow = 1;// 根据用户点击的页码显示// 如果没点击默认显示第一页，如果点击则接收if (! empty ( $_GET ['pageNow'] )) {$pageNow = $_GET ['pageNow'];}// 显示共有多少页$pageCount = 0;$sql = "select count(id) from student";// 发送sql语句$res1 = mysql_query ( $sql );// 取出数据表中共有多少条数据if ($row = mysql_fetch_assoc ( $res1 )) {$rowCount = $row [0];}// 计算共有多少页$pageCount = ceil ( $rowCount / $pageSize );$sql = "select * form student limit " . ($pageNow - 1) * $pageSize . ",$pageSize";$res = mysql_query ( $sql, $conn );// 输出一个表格echo "<table width=500px border='1' cellspacing='0' >";echo "<tr><th>id</th><th>sex</th><th>age</th><th>email</th><th>删除用户</th><th>修改用户</th></tr>";while ( $row = mysql_fetch_assoc ( $res ) ) {echo "<tr><td align='center'>{$row['id']}</td><td align='center'>{$row['sex']}</td><td align='center'>{$row['age']}</td><td align='center'>{$row['email']}</td><td align='center'><a href='#'>删除用户</a></td><td align='center'><a href='#'>修改用户</a></td></tr>";}echo "<h1>学生信息列表</h1>";echo "</table>";// 打印页码超链接for($i = 1; $i < $pageCount; $i ++) {echo "<a href='list.php?pageNow=$i'>$i</a> ";}// 关闭资源mysql_free_result ( $res );// 关闭连接mysql_close ( $conn );?>