- 1文件名为:mysqllink.php 用于数据库连接。
<?php
header("content-type:text/html;charset=utf-8");
$db_host = "localhost";
$db_user = "root";
$db_pwd = "chen1990";
$db_name ="php34";
function getLink($db_host,$db_user,$db_pwd,$db_name)
{
$link = mysql_connect($db_host,$db_user,$db_pwd);
if(!$link)
{
echo "<li>MySQL数据库服务器连接失败,请与管理员联系</li>";
exit();
}
if(!mysql_select_db($db_name))
{
echo "<li>MySQL数据库选择失败,请与管理员联系</li>";
exit();
}
mysql_query("set names utf8");
return $link;
}
?>
<?php
require './mysqllink.php';
$link = getLink($db_host,$db_user,$db_pwd,$db_name);
$sql = "select * from pagetest";
$result = mysql_query($sql);
$records = mysql_num_rows($result);
var_dump($records);
echo"<pre>";
$pagesize=3;
$page=empty($_GET["page"])?0:$_GET["page"];
if($page<0){
$page=0;
}
if($page>$records-$pagesize){
$page=$records-$pagesize;
}
$startrow=$page;
$sql = "select * from pagetest order by id asc limit $startrow,$pagesize";
$result = mysql_query($sql);
var_dump($result);
while($ass=mysql_fetch_assoc($result))
{
echo "<tr align=center>\n";
echo "<td>".$ass["id"]."</td>\t";
echo "<td>".$ass["title"]."</td>\t";
echo "</tr>\n";
}
echo "<a href='pagesss.php?page=".($page-1)."'>上一页</a>";
echo "<a href='pagesss.php?page=".($page+1)."'>下一页</a>\t";
for($i=$_GET["page"]-2;$i<=$_GET["page"]+2;$i++)
{
echo "<a href='pagesss.php?page=$i'>$i</a>\t";
}