作者：ErnastoChen | 来源：互联网 | 2023-10-11 11:30
篇首语：本文由编程笔记#小编为大家整理，主要介绍了ajax分页查询相关的知识，希望对你有一定的参考价值。
用ajax实现对数据库的查询以及对查询数据进行分页
主页面代码
js代码
处理页面1
php
include("DBDA.class.php");
$db = new DBDA();
$key = $_POST["key"];
$num = 20;
$sql = "select count(*) from chinastates where areaname like ‘%{$key}%‘";
$zts = $db->StrQuery($sql);
echo ceil($zts/$num);
处理页面2
php
include("DBDA.class.php");
$db = new DBDA();
$page = $_POST["page"];
$key = $_POST["key"];
$num = 20;
$tiao = ($page-1)*$num;
$sql = "select * from chinastates where areaname like ‘%{$key}%‘ limit {$tiao},{$num}";
echo $db->JSONQuery($sql);
京公网安备 11010802041100号