Ajax PHP paging demonstration_PHP tutorial

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
?>




< /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

?>

http://www.bkjia.com/PHPjc/317703.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/317703.htmlTechArticleToday I was watching Momo’s explanation of pagination. I thought that no one had posted in the original area for a long time, so I expanded Momo’s one by the way. Come on, let’s have a PHP+AJAX paging demonstration. Okay, let’s do it. First, let’s...