How to implement refresh-free paging with php+ajax, ajax paging_PHP tutorial

php+ajax method to achieve non-refresh paging, ajax paging

The example in this article describes the method of php+ajax to achieve refresh-free paging. Share it with everyone for your reference. The specific implementation method is as follows:

This is an example of a paging program based on the original php + js + ajax. We will tell you how to implement ajax paging to call data in detail from database creation to js, ​​php, and html page creation.

The specific steps are as follows:

1. Create database

The SQL statement is as follows:

Copy code The code is as follows:

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. The ajaxpage.js file code is as follows:

Copy code The code is as follows:

var http_request=false;
function send_request(url){//Initialization, specify processing function, function to send request
http_request=false;
//Start initializing the XMLHttpRequest object
If(window.XMLHttpRequest){//Mozilla browser
http_request=new XMLHttpRequest();
If(http_request.overrideMimeType){//Set MIME category
http_request.overrideMimeType("text/xml");
}
}
​ else if(window.ActiveXObject){//IE browser
Try{
http_request=new ActiveXObject("Msxml2.XMLHttp");
}catch(e){
       try{
http_request=new ActiveXobject("Microsoft.XMLHttp");
}catch(e){}
}
}
If(!http_request){//Exception, creation of object instance failed
​ ​ window.alert("Failed to create XMLHttp object!");
Return false;
}
http_request.onreadystatechange=processrequest;
//Determine the request method, URL, and whether to execute the next code synchronously
http_request.open("GET",url,true);
http_request.send(null);
}
//Function to process returned information
function processrequest(){
If(http_request.readyState==4){//Determine the object status
If(http_request.status==200){//The information has been returned successfully, start processing the information
Document.getElementById(reobj).innerHTML=http_request.responseText;
}
else{//The page is abnormal
alert("The page you requested is not normal!");
}
}
}
function dopage(obj,url){
document.getElementById(obj).innerHTML="Reading data...";
reobj = obj;
send_request(url);
}

3. The php calling code is as follows:

Copy code The code is as follows:

$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.="显示第".($total?($pageset+1):0)."-".min($pageset+5,$total)."记录 共".$total."条记录 现在是第 ".$page." 页 ";
if($page<=1)
$pagenav.="首页 ";
else
$pagenav.="首页 ";
if($prepage)
$pagenav.="上一页 ";
else
$pagenav.="上一页 ";
if($nextpage)
$pagenav.="下一页 ";
else
$pagenav.="下一页 ";
if($pagenum)
$pagenav.="尾页 ";
else
$pagenav.="尾页 ";
$pagenav.="共".$pagenum."页";
if($page>$pagenum){
    echo "error:没有此页".$page;
    exit();
}
?>

 
   
   
 
$info=mysql_query("select * from tb_user order by id desc limit $pageset,$page_size");
while($array=mysql_fetch_array($info)){
?>
 
   
   
 
}
?>

用户名	用户密码

echo "

$pagenav

";
?>

希望本文所述对大家的PHP程序设计有所帮助。

为何用PHP+ajax 实现了无刷新分页，但是全选按钮就失效了？怎解决

全选按钮的onchange事件要在通过ajax获取到列表数据后，加上onchange事件，这里是可以获取到列表里的checkbox的，在页面上直接调用js的话，已经出了作用域，js是获取不到列表里的checkbox的.
 

谁给我讲下ajax+php无刷新分页原理

ajax is a js script. Or use ajax
in jquery if you want to verify the username. You can add onchange="call function" in your input attribute
Calling the function is the ajax code.
This is how ajax completes its work.
First send a request to the page you specify such as abc.php (with the post or get you set).
After abc.php responds successfully, execute the code in it To process the parameters you passed. If this user exists. Then return a value or function. If it does not exist, it will also return a value or function. You have to set it yourself.
Then ajax processes the returned value or function, such as displaying it, or calling a function to disable the submit button.

http://www.bkjia.com/PHPjc/906121.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/906121.htmlTechArticleHow to implement refresh-free paging with php+ajax, ajax paging. This article describes how php+ajax implements refresh-free paging. method. Share it with everyone for your reference. The specific implementation method is as follows: This is...