Home > Article > Backend Development > php ajax pagination four_PHP tutorial
ajax paging php ajax paging java ajax paging asp.net ajax paging jquery ajax paging jsp ajax no refresh paging asp ajax paging ajax paging problem ajax implementation paging ajax jsp paging
The most important thing is the result.php file of php,:
//A series of queries from the database will not be described here... You can know it by referring to the following
//PHP server
/*
PHP paging function
function Ajaxpage($sql,$num){
global $db;
$pageno=$_GET['pageno '];
$pageno=(int)$pageno;
if(empty($pageno)||$pageno<1) $pageno=1;
$result=$db->query( $sql);
$number=$db->num_rows($result);
$totalpage=(int)ceil($number/$num);
if($pageno>=$totalpage ){$pageno=$totalpage;}
$start_rowno=($pageno-1)*$num;
$query=$sql." LIMIT ".$start_rowno.",".$num;
$result=$db->query($query);
return array('result'=>$result,'page'=>array('pageno'=>$pageno,'totalpage' =>$totalpage,'number'=>$number));
}
$sql="select * from guest";//Query SQL statement
$num=2; //Paging control, display 2 records per page
$return=Ajaxpage($sql,$num);
while($row=$db->fetch_assoc($return['result'])) {
$result[]=$row; //You can use PHP to process the data here, but I won’t give an example here
}
$result=array('result'=>$result,'page '=>$return['page']);
include('json.class.php');//Include JSON class file
$json=& new Json();
$result =$json->encode($result);//JSON
echo $result;
*/
//If the pageno parameter is sent through AJAX and the resource obtained from the database is $str after JSON Like this, output directly and let JS process it.
//If you don’t understand anything, you can ask me
if(ob_get_length()) ob_clean();
header('cache-control:no-cache ,must-revalidate');
header('pragma:no-cache');
if($_GET['pageno']==1)
$str='{"result":[ {"id":"99","name":"technology","qq":"","tel":"","email":"","content":"[emot:0]", "time":"1198522490","ip":"127.0.0.1",
"rcontent":null,"rtime":"0","url":"0 ","img":"app/index/image/show/1.gif"},{"id":"100","name":"Test","qq":"","tel":" ","email":"","content":"[emot:9]","time":1198548687","ip":"127.0.0.1","
rcontent":null,"rtime":"0","url":"0","img":"app/index/image/show/4.gif"}],"page":{"pageno" :1,"totalpage":2,"number":2}}';
else
$str='{"result":[{"id":"101","name":"Ah ","qq":"","tel":"","email":"","content":"[emot:8][emot:1]","time":"1198548716","ip ":"127.0.0.1","rcontent":null,"rtime":"0","url":"0","img":
"app/index /image/show/9.gif"}],"page":{"pageno":2,"totalpage":2,"number":3}}';
echo iconv('gb2312' ,'utf-8',$str);
?>