帮客之家(www.Bkjia.com)教程 PHP实例代码：AJAX 分页显示数据。
调试用的文件
|
以下为引用的内容： <script> <br>function viewpage(p){ <br>if(window.XMLHttpRequest){ <br>var xmlReq = new XMLHttpRequest(); <br>} else if(window.ActiveXObject) { <br>var xmlReq = new ActiveXObject('Microsoft.XMLHTTP'); <br>} <br>var formData = "page="+p; <br>xmlReq.onreadystatechange = function(){ <br>if(xmlReq.readyState == 4){ <br>document.getElementById('content2').innerHTML = xmlReq.responseText; <br>} <br>} <br>xmlReq.open("post", "Example8_7_1.php", true); <br>xmlReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); <br>xmlReq.send(formData); <br>return false; <br>} <br></script> @@##@@ 数据分页显示 |
调用的另外一个文件 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 "
?> |
|||||||||||||||||
