PHP实例代码：AJAX 分页显示数据

2014-01-15 为码而活 PHP教程 关注597次 已收录
当前位置：波比源码 > PHP实例代码：AJAX 分页显示数据
正文概述

　　网(LieHuo.Net)教程 PHP实例代码：AJAX 分页显示数据。

调试用的文件

以下为引用的内容：
<html>
<head>
<title>网提供教程LIEHUO.NET　关注站长，建设互联网！</title>
<script>
function viewpage(p){
if(window.XMLHttpRequest){
var xmlReq = new XMLHttpRequest();
} else if(window.ActiveXObject) {
var xmlReq = new ActiveXObject(‘Microsoft.XMLHTTP’);
}
var formData = "page="+p;
xmlReq.onreadystatechange = function(){
if(xmlReq.readyState == 4){
document.getElementById(‘content2’).innerHTML = xmlReq.responseText;
}
}
xmlReq.open("post", "Example8_7_1.php", true);
xmlReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xmlReq.send(formData);
return false;
}
</script>
<head>
<body onLoad="viewpage(1)">
<img src=top.gif width="100%">
<h3 align="center">数据分页显示</h3>
<div id="content2"></div>
</body>
</html>

　　调用的另外一个文件 Example8_7_1.php

以下为引用的内容：
<?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 "<TABLE style="MARGIN-BOTTOM: 20px" cellSpacing=0 cellPadding=0 width=90% border=1 align=center>";
echo "<TBODY>";
echo "<th>ID编号</th><th>名称</th><th>作者</th><th>出版社</th><th>ISBN号</th><th>类型</th><th>价格</th>";
for($a=0;$a<$num;$a++)
{
echo "<TR>";
echo "<TD style="PADDING-TOP: 5px" align=left>".$hotelname[$a]."</TD>";
echo "<TD style="PADDING-TOP: 5px" align=left>".$name[$a]."</TD>";
echo "<TD style="PADDING-TOP: 5px" align=left>".$author[$a]."</TD>";
echo "<TD style="PADDING-TOP: 5px" align=left>".$publisher[$a]."</TD>";
echo "<TD style="PADDING-TOP: 5px" align=left>".$isbn[$a]."</TD>";
echo "<TD style="PADDING-TOP: 5px" align=left>".$type[$a]."</TD>";
echo "<TD style="PADDING-TOP: 5px" align=left><img src=".$smallpic[$a]."></a></TD>";
echo "</TR>";
}
echo "</TR></TBODY></TABLE>";
echo "<TABLE style="MARGIN-TOP: 30px" cellSpacing=0 cellPadding=0 width="100%"";
echo "border=0>";
echo "<TBODY><TR><TD colSpan=3 height=20>";
echo "<DIV align=center>";
echo "<P align=left><FONT color=red>第".$page."页/总".$pages."页 | 总".$numrows."条</FONT> | ";
if ($page>1) echo "<a onclick="viewpage(".$first.")" href=’#’>首页</a> | ";
if ($page>1) echo "<a onclick="viewpage(".$prev.")" href=’#’>上页</a> | ";
if ($page<$pages) echo "<a onclick="viewpage(".$next.")" href=’#’>下页</a> | ";
if ($page<$pages) echo "<a onclick="viewpage(".$last.")" href=’#’>尾页</a>";
echo " 转到第 <INPUT maxLength=3 size=3 value=1 name=goto_page> 页 <INPUT hideFocus onclick="viewpage(document.all.goto_page.value)" type=button value=Go name=cmd_goto>";
echo "</P></DIV></TD></TR></TBODY></TABLE>";

?>
波比源码 – 精品源码模版分享 | www.bobi11.com
1. 本站所有资源来源于用户上传和网络，如有侵权请邮件联系站长！
2. 分享目的仅供大家学习和交流，您必须在下载后24小时内删除！
3. 不得使用于非法商业用途，不得违反国家法律。否则后果自负！
4. 本站提供的源码、模板、插件等等其他资源，都不包含技术服务请大家谅解！
5. 如有链接无法下载、失效或广告，请联系管理员处理！
6. 本站资源售价只是赞助，收取费用仅维持本站的日常运营所需！
7. 本站源码并不保证全部能正常使用，仅供有技术基础的人学习研究，请谨慎下载
8. 如遇到加密压缩包，请使用WINRAR解压,如遇到无法解压的请联系管理员！

波比源码 » PHP实例代码：AJAX 分页显示数据
分享到：

相关推荐

104 评论

  4. order ampicillin 500mg without prescription ampicillin usa order erythromycin 250mg pills

  5. order fildena 50mg without prescription methocarbamol uk order methocarbamol generic

  12. acheter gГ©nГ©rique tadalafil en france viagra 25mg pour homme viagra 50mg sans ordonnance en pharmacie

  14. tadalafil kaufen generika cialis kaufen sildenafil 200mg kaufen ohne rezept

  16. order ramipril 10mg without prescription clobetasol buy online azelastine 10 ml canada

  26. salbutamol 100 mcg uk sildenafil 100mg overnight delivery viagra

  27. buy naltrexone 50mg sale abilify usa aripiprazole drug

  44. cozaar order brand losartan order topiramate 100mg generic

  50. good academic writing essays writing ivermectin 3 mg otc

  51. purchase sildalis online estradiol us lamotrigine cheap

  53. oral tretinoin cream order retin sale purchase avanafil generic

  54. naproxen 500mg us prevacid price order lansoprazole 30mg generic

  62. coreg 6.25mg over the counter elavil 50mg oral amitriptyline 50mg brand

  63. nortriptyline 25mg tablet pamelor price buy paxil 10mg generic

  69. order fildena online buy lyrica buy propecia 1mg

  72. buy generic imuran 50mg naproxen tablet naprosyn 500mg pills

  73. order avlosulfon 100mg online cheap tenormin generic buy atenolol cheap

  77. order generic lipitor 10mg lipitor cost buy sildenafil tablets

  81. cheap glycomet 500mg order norvasc amlodipine 10mg canada

  85. purchase crestor without prescription order zetia sale buy motilium generic

  87. buy zantac no prescription zantac ca buy celecoxib 100mg generic

  88. nateglinide tablet cost candesartan order atacand 16mg online cheap

  96. buy generic azipro neurontin cost order gabapentin 600mg for sale

  102. asacol 400mg pill avapro 300mg pill irbesartan 300mg without prescription

发表评论

Hi, 如果你对这款模板有疑问，可以跟我联系哦！

联系站长
赞助VIP 享更多特权，建议使用 QQ 登录
QQ登录
喜欢我嘛？喜欢就按“ctrl+D”收藏我吧！♡