php访问数据库分页显示

浏览数：33 / 时间：2015年06月12日

1、前言

对于mysql数据库，为便于学习等，新安装的mysql中含有一个叫做world的数据库，该数据库含有一些信息，本文以此为实验素材。本文参考了php经典编程265例。

2、上代码

<?php
	class mysql{
		var $host;
		var $user;
		var $pwd;
		var $db;
		var $con;
		
		function __construct($host, $user, $pwd, $db){
			$this->host=$host;
			$this->user=$user;
			$this->pwd=$pwd;
			$this->db=$db;
			$this->connect();
		}
		function connect(){
			$this->con=mysql_connect($this->host,$this->user,$this->pwd);
			mysql_select_db($this->db,$this->con);
			mysql_query("SET NAMES UTF-8");
		}
	};
?>

<html>
<head>
<style>
td{
	text-align:center;
}
</style>
</head>
<body>
<table width="500px" border="1px" cellpadding="1px" cellspacing="1px" align="center">
	<caption>CountryLauguage</caption>
	<tr>
		<td width="100px">CountryCode</td><td width="200px">Language</td><td width="100px">Isofficial</td><td width="100px">Percentage</td>
	</tr>
<?php
	include("in.php");
	new mysql("localhost","root","08246298","world");
	$res=mysql_query("select * from countrylanguage");
	$sum=mysql_num_rows($res);
	$perpage=50;
	$pagesum=ceil($sum/$perpage);

	if(empty($_GET['page']))
	{
		$page=1;
	}
	else
	{
		$page=$_GET['page'];
	}
	$start=($page-1)*$perpage+1;
	
	$res=mysql_query("select * from countrylanguage limit ".$start.",".$perpage);
	while($r=mysql_fetch_row($res))
	{
		echo "<tr>";
			echo "<td width='100px'>$r[0]</td><td width='200px'>$r[1]</td><td width='100px'>$r[2]</td><td width='100px'>$r[3]</td>";
		echo "</tr>";
	}
?>
</table>
<br/>
<p align="center">
<?php
echo "<a href='index.php?page=1'>Head</a>    ";
if($page>2)
{
	echo "<a href='index.php?page=".($page-1)."'>Pre</a>    ";
}
if($page<$pagesum-1)
{
	echo "<a href='index.php?page=".($page+1)."'>Next</a>    ";
}
echo "<a href='index.php?page=".$pagesum."'>End</a>    ";
?>
</p>
</body>
</html>