帮客之家(www.bkjia.com)教程 php实例代码：ajax 分页显示数据。
调试用的文件
|
以下为引用的内容： @@##@@ 数据分页显示 |
调用的另外一个文件 Example8_7_1.php
|
以下为引用的内容： header("Content-Type:text/html;charset=GB2312"); $pagesize=10; //echo $_POST['page']; $db=mysql_connect("localhost","root",""); //创建数据库连接 mysql_query("set character set utf-8"); mysql_select_db("optics"); $result = mysql_query("Select count(DISTINCT articleid) FROM product"); $myrow = mysql_fetch_array($result); $numrows=$myrow[0]; $pages=intval($numrows/$pagesize); if ($numrows%$pagesize) $pages++; if (isset($_POST['page'])){ $page=intval($_POST['page']); } else{ //设置为第一页 $page=1; } $first=1; $prev=$page-1; $next=$page+1; $last=$pages; //计算记录偏移量 $offset=$pagesize*($page - 1); //读取指定记录数 //$result=mysql_query("select `id` , count( * ) from ".book." GROUP BY `id` order by id desc limit $offset,$pagesize"); $result=mysql_query("select * from product GROUP BY `articleid` order by articleid desc limit $offset,$pagesize"); $num = @mysql_num_rows($result); while ($row = @mysql_fetch_array($result,MYSQL_NUM)) { $hotelname[] = $row[0]; $name[]=$row[1]; $author[]=$row[2]; $publisher[]=$row[3]; $isbn[]=$row[4]; $type[]=$row[5]; $smallpic[]=$row[6]; //$countpeople[] = $row[1]; } echo "
echo " echo " | ||||||||||||||
| "; echo " | ||||||||||||||
?>
