作者: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);