Ajax PHP paging demonstration_PHP tutorial-PHP Tutorial-php.cn

Ajax PHP paging demonstration_PHP tutorial

WBOY

Release： 2016-07-21 15:58:05

Original

1060 people have browsed it

Today I was watching Momo’s explanation of paging. It seemed like no one had posted in the original area for a long time, so I just expanded Momo’s one and gave a PHP+AJAX paging demonstration. Okay, that’s it. First of all, we are still basic. AJAX development framework:

Copy code The code is as follows:

var http_request=false; 
 function send_request(url){//Initialization , specify the processing function, the function to send the request 
 http_request=false; 
 //Start initializing the XMLHttpRequest object 
 if(window.XMLHttpRequest){//Mozilla browser 
 http_request=new XMLHttpRequest(); 
 if(http_request.overrideMimeType){//Set MIME category 
 http_request.overrideMimeType("text/xml"); 
 } 
 else if(window.ActiveXObject){// Internet Explorer 
 try{ 
 http_request=new ActiveXObject("Msxml2.XMLHttp"); 
 }catch(e){ 
 try{ 
 http_request=new ActiveXobject("Microsoft.XML Http" ; "); 
 return false; 
 } 
 http_request.onreadystatechange=processrequest; 
 //Determine the request method, URL, and whether to execute the next code synchronously 
 http_request.open("GET" ,url,true); 
 http_request.send(null); 
 } 
 //Function to process the returned information 
 function processrequest(){ 
 if(http_request.readyState==4) {//Determine the object status 
 if(http_request.status==200){//The information has been returned successfully, start processing the information 
 document.getElementById(reobj).innerHTML=http_request.responseText; 
 } 
 else{//The page is not normal 
 alert("The page you requested is not normal! "); 
 } } 
 } 
 } 
 function dopage(obj,url){ 
 document.getElementById(obj).innerHTML="Reading data..."; 
 send_request(url); 
 reobj=obj; 
 } 

 I display the content in a div. When the page turning action occurs, I use AJAX to update the DIV to achieve the page turning effect. This is the content Display page code: 



Copy code

The code is as follows:

header("Content-type: text/html;charset=GBK");//Output encoding to avoid Chinese garbled characters
?>

ajax paging demonstration

< /head>

$page=isset($_GET['page'])?intval($ _GET['page']):1; //This sentence is to get the value of page in page=18. If page does not exist, then the page number is 1.
$ num = 10; // Show 10 data per page

$ db = mysql_connect ("LocalHost", "ROOT", "7529639"); // Create a database connection
MySQL_SELECT_DB ( "cr_download"); //Select the database to operate

/* Divide the database by the number of items displayed on each page, and the remainder is one.
That is to say, 10/3=3.3333=4 If there is a remainder, we must round it up by one.
*/

$result=mysql_query("select * from cr_userinfo");
$total=mysql_num_rows($result); //Query all data

$url ='test.php';//Get the URL of this page

//Calculate the page number
$pagenum=ceil($total/$num); 🎜>$page=min($pagenum,$page);//Get the home page
$prepg=$page-1;//Previous page
$nextpg=($page==$pagenum ? 0 : $page+1);//Next page
$offset=($page-1)*$num; *10=0, the second page is (2-1)*10=10.

//Start paging navigation bar code:
$pagenav="Display page ".($total?($offset+1):0)."- ".min($offset+10,$total)." records, total $total records ";

//If there is only one page, the function will jump out:
if($pagenum<=1) return false;

$pagenav.=" Homepage< /a> ";
if($prepg) $pagenav.=" Previous page " ; else $pagenav.=" Previous page ";
if($nextpg) $pagenav.=" Next page "; else $pagenav.=" Next page ";
$pagenav.=" End Page ";
$pagenav.=" pages, total $pagenum pages";

//If the page number parameter passed in is greater than the total number of pages, then Display error message
If($page>$pagenum){
Echo "Error: Can Not Found The page ".$page;
Exit;
}

$info= mysql_query("select * from cr_userinfo limit $offset,$num"); //Get the data that needs to be displayed for the corresponding page number
While($it=mysql_fetch_array($info)){
Echo $it[' username'];
echo "
";
} echo "
";
echo $pagenav;//Output page navigation

?>

The key to turning pages is to call the dopage() function when turning pages, and then use the callback information to update the content in the div. Server-side core code:

Copy code The code is as follows:

header("Content-type: text/html;charset=GBK");//Output encoding to avoid Chinese garbled characters
$page=isset($_GET['page'] )?intval($_GET['page']):1; //This sentence is to get the value of page in page=18. If page does not exist, then the page number is 1.
$ num = 10; // Show 10 data per page

$ db = mysql_connect ("LocalHost", "ROOT", "7529639"); // Create a database connection
MySQL_SELECT_DB ( "cr_download"); //Select the database to operate

/* Divide the database by the number of items displayed on each page, and the remainder is one.
That is to say, 10/3=3.3333=4 If there is a remainder, we must round it up by one.
*/

$result=mysql_query("select * from cr_userinfo");
$total=mysql_num_rows($result); //Query all data

$url ='test.php';//Get the URL of this page

//Calculate the page number
$pagenum=ceil($total/$num); 🎜>$page=min($pagenum,$page);//Get the home page
$prepg=$page-1;//Previous page
$nextpg=($page==$pagenum ? 0 : $page+1);//Next page
$offset=($page-1)*$num; *10=0, the second page is (2-1)*10=10.

//Start paging navigation bar code:
$pagenav="Display page ".($total?($offset+1):0)."- ".min($offset+10,$total)." records, total $total records ";

//If there is only one page, the function will jump out:
if($pagenum<=1) return false;

$pagenav.=" Homepage< /a> ";
if($prepg) $pagenav.=" Previous page " ; else $pagenav.=" Previous page ";
if($nextpg) $pagenav.=" Next page "; else $pagenav.=" Next page ";
$pagenav.=" End Page ";
$pagenav.=" pages, total $pagenum pages";

//If the page number parameter passed in is greater than the total number of pages, then Display error message
If($page>$pagenum){
Echo "Error: Can Not Found The page ".$page;
Exit;
}

$info= mysql_query("select * from cr_userinfo limit $offset,$num"); //Get the data that needs to be displayed for the corresponding page number
While($it=mysql_fetch_array($info)){
Echo $it[' username'];
echo "
";
} echo "
";
echo $pagenav;//Output page navigation

?>