<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>PHP分页</title> </head>
<body> <?php $conn=mysql_connect("localhost","root","123456") or die("数据库连接错误".mysql_error()); mysql_select_db("wangyantest",$conn) or die("数据库访问错误".mysql_error()); mysql_query("set names gb2312"); $page=$_GET["page"]; if($page=="") {$page=1;} if(is_numeric($page)) { $page_size=2; //每页多少条数据 $query="select count(*) as total from test order by id desc"; $result=mysql_query($query); $message_count=mysql_result($result,0,"total"); $page_count=ceil($message_count/$page_size); $offset=($page-1)*$page_size; $sql=mysql_query("select * from test order by id desc limit $offset,$page_size"); $row=mysql_fetch_object($sql); if(!$row) { echo("暂无任何数据!"); } ?> <ul> <?php do { ?> <li><?php echo "<a href=contnet.php?; } mysql_free_result($sql); mysql_close($conn); ?> </body> </html>
|
请发表评论