本文使用jQuery+Ajax+PHP+Mysql,通过实例讲解如何实现Ajax无刷新分页效果。
PHP
ajax.php接收每次前端页面的ajax请求,根据提交的页码page,计算总记录数和总页数,读取对应页码下的数据列表,并将结果以JSON格式返回给前端页面。
include_once('connect.php'); $page = intval($_GET['page']); //当前页 $total_num = mysql_num_rows(mysql_query("select id from goods")); //总记录数 $page_size = 6; //每页数量 $page_total = ceil($total_num / $page_size); //总页数 $page_start = $page * $page_size; $arr = array("total_num" = >$total_num, "page_size" = >$page_size, "page_total_num" = >$page_total, ); $query = mysql_query("SELECT id,title,pic FROM goods ORDER BY ID ASC LIMIT $page_start,$page_size"); while ($row = mysql_fetch_array($query)) { $arr['list'][] = array('id' = >$row['id'], 'title' = >$row['title'], 'pic' = >$row['pic'], ); } echo json_encode($arr);
最后附上demo_goods表结构
CREATE TABLE IF NOT EXISTS`demo_goods` ( `id`int(11) NOT NULL AUTO_INCREMENT, `title`varchar(100) NOT NULL, `pic`varchar(255) NOT NULL, PRIMARY KEY(`id`) ) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 0;