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

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

WBOY

Release： 2016-07-13 10:15:05

Original

709 people have browsed it

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:

3. The php calling code is as follows:

Copy code The code is as follows:

PHP+ajax分页演示

$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.