PHP + AJAX 实现无刷新分页不刷新页面实现分页 PHP AJAX

最新推荐文章于 2021-03-10 13:02:55 发布

张广森

最新推荐文章于 2021-03-10 13:02:55 发布

阅读量7.1k

点赞数

分类专栏： php 文章标签： php ajax insert xmlhttprequest javascript mysql

php 专栏收录该内容

49 篇文章 0 订阅

订阅专栏

实现不刷新页面完成分页 PHP AJAX 不刷新页面分页
INDEX.PHP文件
<?php

header("Content-Type:text/html;charset=utf-8");
?>
<html>
<head>
<title>AJAX-无刷新分页      by:siyuantlw</title>
<style>
A{text-decoration:none;}
A:link {COLOR:#33CCFF;}
A:active {COLOR:#FF6666;}
A:visited {COLOR:#33CCFF;}
A:hover {COLOR:#FF6699; TEXT-DECORATION: underline;position:relative;left:1px;top:1px}
</style>
</head>
<body>
   <div id="test"></div>
</body>
<script language="javascript">
   function ajaxfunction(page){
       if(page.length==0){
           return;
       }
       var xmlHttp;
       try{
           //FF Opear 8.0+ Safair
           xmlHttp=new XMLHttpRequest();
       }
       catch(e){
           try{
               xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
           }
           catch(e){
               alert("您的浏览器不支持AJAX");
               return false;
           }
       }
       xmlHttp.onreadystatechange=function(){
           if(xmlHttp.readyState==4){
               document.getElementById("test").innerHTML=xmlHttp.responseText;
           }
       }
       var url="sql.php";
       url+="?page="+page+"&sid="+Math.random();
       xmlHttp.open("GET",url,true);
       xmlHttp.send(null);

   }
   ajaxfunction(1);
</script>
</html>

SQL.PHP

<?php
mysql_connect("","root","");
mysql_select_db("test");
mysql_query("set names utf8");
//by siyuantlw
if(isset($_GET["page"])){
   @$page = max(1, intval($_GET["page"]));
   $pagesize=10;
   $startindex=($page-1)*$pagesize;
   $sql="SELECT * FROM test ORDER BY id LIMIT $startindex,$pagesize";
   $rec=mysql_query($sql);
   while($row=mysql_fetch_array($rec)){
       $str.="<li>".$row["uname"]."</li>";
   }
   $num=mysql_num_rows(mysql_query("select * from test"));
   $pagenum=@ceil($num/$pagesize);
   for($i=1;$i<=$pagenum;$i++){
       if($page==$i){
           $str.="<a href='javascript:void(0)' οnclick=ajaxfunction(".$i.")>[".$i."]</a>   ";
       }else{
           $str.="<a href='javascript:void(0)' οnclick=ajaxfunction(".$i.")>".$i."</a>   ";
       }
   }
   echo $str;
}else{
   die();
}
?>

数据库test表test

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(10) NOT NULL auto_increment,
`uname` char(50) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_bin;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `test` VALUES ('1', 'aaaaaaaaaaa');
INSERT INTO `test` VALUES ('2', 'bbbbbbbbbbbb');
INSERT INTO `test` VALUES ('3', 'cccccccccccc');
INSERT INTO `test` VALUES ('4', 'dddddddddddddddd');
INSERT INTO `test` VALUES ('5', 'eeeeeeeeeee');
INSERT INTO `test` VALUES ('6', 'ffffffffff');
INSERT INTO `test` VALUES ('7', 'ggggggggggggggg');
INSERT INTO `test` VALUES ('8', 'hhhhhhhhhhhh');
INSERT INTO `test` VALUES ('9', 'jjjjjjjjjjjjjjjj');
INSERT INTO `test` VALUES ('10', 'kkkkkkkkkkk');
INSERT INTO `test` VALUES ('11', 'mmmmmmmmmmm');
INSERT INTO `test` VALUES ('12', 'cccccccccccccccccc');
INSERT INTO `test` VALUES ('13', 'bbbbbbbbbbbb');
INSERT INTO `test` VALUES ('14', 'ooooooooooooooooo');
INSERT INTO `test` VALUES ('15', 'pppppppppppp');
INSERT INTO `test` VALUES ('16', 'aaaaaaaaaaaaaaa');
INSERT INTO `test` VALUES ('17', 'ggggggggggggggggg');
INSERT INTO `test` VALUES ('18', 'dddddddddddddddd');
INSERT INTO `test` VALUES ('19', 'cccccccccccccc');
INSERT INTO `test` VALUES ('20', 'xxxxxxxxxx');
INSERT INTO `test` VALUES ('21', 'zzzzzzzzzzzzzzz');
INSERT INTO `test` VALUES ('22', 'oooooooooooooooooooo');
INSERT INTO `test` VALUES ('23', 'iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii');
INSERT INTO `test` VALUES ('24', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuu');
INSERT INTO `test` VALUES ('25', 'yyyyyyyyyyyyyyyyyy');
INSERT INTO `test` VALUES ('26', 'ttttttttttttttttttttttttttt');
INSERT INTO `test` VALUES ('27', 'rrrrrrrrrrrrrrrrrrrrrrrr');
INSERT INTO `test` VALUES ('28', 'eeeeeeeeeeeeeeeeeeeee');
INSERT INTO `test` VALUES ('29', 'wwwwwwwwwwwwwwwwwwwww');
INSERT INTO `test` VALUES ('30', 'qqqqqqqqqqqqq');
INSERT INTO `test` VALUES ('31', 'aaaaaaaaaaa');
INSERT INTO `test` VALUES ('32', 'zzzzzzzzzzzzz');
INSERT INTO `test` VALUES ('33', 'ssssssssssd');
INSERT INTO `test` VALUES ('34', 'dddddddddddddddddddddddd');
INSERT INTO `test` VALUES ('35', 'fffffffffffffffffffff');
INSERT INTO `test` VALUES ('36', 'vvvvvvvvvvvvvvvvvvvv');
INSERT INTO `test` VALUES ('37', 'bbbbbbbbbbbbbbbbbnb');
INSERT INTO `test` VALUES ('38', 'nnnnnnnnnnnnnn');
INSERT INTO `test` VALUES ('39', '2222222222222');
INSERT INTO `test` VALUES ('40', '1111111111111');
INSERT INTO `test` VALUES ('41', '3333333333333');
INSERT INTO `test` VALUES ('42', '44444444444');
INSERT INTO `test` VALUES ('43', '5555555555555');
INSERT INTO `test` VALUES ('44', '6666666666666');
INSERT INTO `test` VALUES ('45', '7777777777777');
INSERT INTO `test` VALUES ('46', '8888888888888');
INSERT INTO `test` VALUES ('47', '999999999999999');
INSERT INTO `test` VALUES ('48', '000000000000');