1. [文件] sql.sql
CREATE TABLE `tb_user` ( `id` int(10) NOT NULL auto_increment, `username` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; INSERT INTO `tb_user` VALUES (1, 'aaa'); INSERT INTO `tb_user` VALUES (2, 'bbb'); INSERT INTO `tb_user` VALUES (3, 'ccc'); INSERT INTO `tb_user` VALUES (4, 'ddd'); INSERT INTO `tb_user` VALUES (5, 'eee'); INSERT INTO `tb_user` VALUES (6, 'fff'); INSERT INTO `tb_user` VALUES (7, 'ggg'); INSERT INTO `tb_user` VALUES (8, 'hhh'); INSERT INTO `tb_user` VALUES (9, 'жпнд');
2. [文件] ajaxpage.js
var http_request=false;
function send_request(url){//初始化,指定处理函数,发送请求的函数
http_request=false;
//开始初始化XMLHttpRequest对象
if(window.XMLHttpRequest){//Mozilla浏览器
http_request=new XMLHttpRequest();
if(http_request.overrideMimeType){//设置MIME类别
http_request.overrideMimeType("text/xml");
}
}
else if(window.ActiveXObject){//IE浏览器
try{
http_request=new ActiveXObject("Msxml2.XMLHttp");
}catch(e){
try{
http_request=new ActiveXobject("Microsoft.XMLHttp");
}catch(e){}
}
}
if(!http_request){//异常,创建对象实例失败
window.alert("创建XMLHttp对象失败!");
return false;
}
http_request.onreadystatechange=processrequest;
//确定发送请求方式,URL,及是否同步执行下段代码
http_request.open("GET",url,true);
http_request.send(null);
}
//处理返回信息的函数
function processrequest(){
if(http_request.readyState==4){//判断对象状态
if(http_request.status==200){//信息已成功返回,开始处理信息
document.getElementById(reobj).innerHTML=http_request.responseText;
}
else{//页面不正常
alert("您所请求的页面不正常!");
}
}
}
function dopage(obj,url){
document.getElementById(obj).innerHTML="正在读取数据...";
reobj = obj;
send_request(url);
}
3. [代码][PHP]代码
<title>PHP+ajax分页演示</title><meta><script></script><p>
<?php $terry=mysql_connect("localhost","root","")or die("连接数据库失败:".mysql_error());
mysql_select_db("ajaxtest",$terry);
mysql_query("set NAMES 'utf8'");
$result=mysql_query("select * from tb_user");
$total=mysql_num_rows($result) or die(mysql_error());
$page=isset($_GET['page'])?intval($_GET['page']):1;
$page_size=3;
$url='index.php';
$pagenum=ceil($total/$page_size);
$page=min($pagenum,$page);
$prepage=$page-1;
$nextpage=($page==$pagenum?0:$page+1);
$pageset=($page-1)*$page_size;
$pagenav='';
$pagenav.="显示第<font color='red'>".($total?($pageset+1):0)."-".min($pageset+5,$total)."记录 共<b><font>".$total."</font></b>条记录 现在是第 <b><font>".$page."</font></b> 页 ";
if($page首页 ";
else
$pagenav.="<a>首页</a> ";
if($prepage)
$pagenav.="<a>上一页</a> ";
else
$pagenav.="<a>上一页</a> ";
if($nextpage)
$pagenav.="<a>下一页</a> ";
else
$pagenav.="<a>下一页</a> ";
if($pagenum)
$pagenav.="<a>尾页</a> ";
else
$pagenav.="<a>尾页</a> ";
$pagenav.="共".$pagenum."页";
if($page>$pagenum){
echo "error:没有此页".$page;
exit();
}
?>
</p>
| 用户名 | 用户密码 |
php免费学习视频:立即使用
踏上前端学习之旅,开启通往精通之路!从前端基础到项目实战,循序渐进,一步一个脚印,迈向巅峰!










