PHP+Ajax implements paging technology_PHP tutorial

PHP+Ajax implementation of paging technology:

Paging technology code based on php and ajax. There are two php files below, one is sn_inq.php and the other is sn_show.php. The former php file calls the next php file to implement ajax paging. Just run sn_inq. To achieve the effect, you have to modify the database. The specific code is as follows: Pay special attention to modifications in the areas marked in red!

My database name is inv, the table name is sn, and the fields are: sn_id, sn_plant, sn_sales, sn_act, sn_type, sn_sts....

1.sn_inq.php

//getFormValue is used to get the values ​​of all input controls in the form, and combine the input values ​​into a string and send it to the server.

//showcomment(page) is used to display paging data and is called by the query button onclick event. The url is the file url for background processing data and outputting XML format data.

function showcomment(page) {
var x = new Ajax('statusid', 'XML');
url = 'sn_show.php?page='+page+'&'+getFormValue(document.form1);

x.get(url, function(s) {
if(s.lastChild){
getbyid("show").innerHTML = "Loading...";
getbyid("show").innerHTML = s.lastChild.firstChild.nodeValue;
removeLoading(document.getElementById("show"));
}
else{
document.form1.submit();
}
});
}

//displayLoading is used to display Loading and prompt the user to wait

function displayLoading(element) {
var image = document.createElement("img");
image.setAttribute("src","progressbar.gif");
image.setAttribute("title","loading...");
var text = document.createTextNode("loading...");
element.appendChild(image);
element.appendChild(text);
}

//removeLoading is used to remove Loading

removefunctionLoading(element){
var image = element.getElementsByTagName("img");
for(var i=0;i element.removeChild(image[i]);
}
}

//ajax

function Ajax(statusId, recvType) {
var aj = new Object();
displayLoading(document.getElementById("show"));
var clientHeight = scrollTop = 0;
if(navigator.userAgent.toLowerCase().indexOf('opera') > -1) {
clientHeight = document.body.clientHeight;
scrollTop = document.body.scrollTop;
} else {
clientHeight = document.documentElement.clientHeight;
scrollTop = document.documentElement.scrollTop;
}
if(document.getElementById(statusId)) {
aj.statusId = document.getElementById(statusId);
document.getElementById(statusId).style.top = 10+"px";
} else {
var divElement = document.createElement("DIV");
divElement.id = "xspace-tipDiv";
divElement.className = "xspace-ajaxdiv";
divElement.style.cssText = "width:200px; height:40px; line-height: 40px; text-align: center;";
divElement.style.left = 10+"px";
divElement.style.top = 10+"px";//(clientHeight +scrollTop - 60)
divElement.id = statusId;
document.body.appendChild(divElement);
aj.statusId = divElement;
}
aj.targetUrl = '';
aj.sendString = '';
aj.recvType = recvType ? recvType : 'HTML';//HTML XML
aj.resultHandle = null;
aj.createXMLHttpRequest = function() {
var request = false;
if(window.XMLHttpRequest) {
request = new XMLHttpRequest();
if(request.overrideMimeType) {
request.overrideMimeType('text/xml');
}
} else if(window.ActiveXObject) {
var versions = ['Microsoft.XMLHTTP', 'MSXML.XMLHTTP', 'Microsoft.XMLHTTP', 'Msxml2.XMLHTTP.7.0', 'Msxml2.XMLHTTP.6.0', 'Msxml2.XMLHTTP.5.0', 'Msxml2.XMLHTTP.4.0', 'MSXML2.XMLHTTP.3.0', 'MSXML2.XMLHTTP'];
for(var i=0; i try {
request = new ActiveXObject(versions[i]);
if(request) {
return request;
}
} catch(e) {
//alert(e.message);
}
}
}
return request;
}
aj.XMLHttpRequest = aj.createXMLHttpRequest();
aj.processHandle = function() {
aj.statusId.style.display = '';
if(aj.XMLHttpRequest.readyState == 4) {
if(aj.XMLHttpRequest.status == 200) {
if(aj.recvType == 'HTML') {
aj.resultHandle(aj.XMLHttpRequest.responseText);
} else if(aj.recvType == 'XML') {
aj.resultHandle(aj.XMLHttpRequest.responseXML);
}
aj.statusId.style.display = 'none';
} else {
aj.statusId.innerHTML = xml_http_load_failed;
}
}
}

aj.get = function(targetUrl, resultHandle) {
aj.targetUrl = targetUrl;
aj.XMLHttpRequest.onreadystatechange = aj.processHandle;
aj.resultHandle = resultHandle;
if(window.XMLHttpRequest) {
aj.XMLHttpRequest.open('GET', aj.targetUrl);
aj.XMLHttpRequest.send(null);
} else {
aj.XMLHttpRequest.open("GET", targetUrl, true);
aj.XMLHttpRequest.send();
}
}

aj.post = function(targetUrl, sendString, resultHandle) {
aj.targetUrl = targetUrl;
aj.sendString = sendString;
aj.XMLHttpRequest.onreadystatechange = aj.processHandle;
aj.resultHandle = resultHandle;
aj.XMLHttpRequest.open('POST', targetUrl);
aj.XMLHttpRequest.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
aj.XMLHttpRequest.send(aj.sendString);
}
return aj;
}

function getbyid(id) {
if (document.getElementById) {
return document.getElementById(id);
} else if (document.all) {
return document.all[id];
} else if (document.layers) {
return document.layers[id];
} else {
return null;
}
} 

//注意：此处如果有filesedset的话，form表单一定要放在fieldset里面，否则出错。
echo '

SN	to  onClick="showcomment(1)"/>

';

?>

2.sn_show.php:

//page function
function showpage(total){
global page,pagenav,middle,num,pagenum,offset,prepg,nextpg;
//Get the value of page in page=18. If page does not exist, then the page number is 1.
page=isset(_REQUEST['page'])?intval(_REQUEST['page']):1;
//Each layer of paging bars displays 4 paging connections
middle = '4';
//Display 10 pieces of data per page
num=10;
//Get the total number of pages, which is also the last page
pagenum=ceil(total/num);
//Get homepage
page=min(pagenum,page);
//Previous page
prepg=page-1;
//Next page
nextpg=(page==pagenum ? 0 : page+1);
offset=(page-1)*num;

if(pagenum

if(prepg){
pagenav.=' onclick="javascript：showcomment(1);">'.iconv('gb2312','gb2312','Homepage'). ' ';
pagenav.=' onclick="javascript：showcomment('.prepg.');">'.iconv('gb2312','gb2312',' Previous page').' ';
}else{
pagenav.="".iconv('gb2312','gb2312','Homepage').""." ";
pagenav.="".iconv('gb2312','gb2312','Previous page')."";
}

if(nextpg){
pagenav.=' onclick="javascript：showcomment('.nextpg.');">'.iconv('gb2312','gb2312',' Next page').' ';
pagenav.=' onclick="javascript：showcomment('.pagenum.');">'.iconv('gb2312','gb2312',' Last page').' ';
}else{
pagenav.="".iconv('gb2312','gb2312','next page').""." ";
pagenav.="".iconv('gb2312','gb2312','Last page').""." ";
}

pagenav.=''.iconv('gb2312','gb2312','total') . pagenum .' '.iconv('gb2312','gb2312','page');
for(h=(page-middlepagenum?pagenum:page+middle);h++){
if(h==page){
pagenav.=" h ";
}else{
pagenav.="  ".iconv('gb2312','gb2312',h)."  ; ";
}
}

pagenav.="    ";
pagenav.=iconv('gb2312','gb2312','Go to ');

pagenav.="";
for (i = 1; i if(page == i){
pagenav.= "".i."";
}else{
pagenav.= "".i."";
}
}
pagenav.="";
pagenav.="page";
return pagenav;
}

//connect to database
function db_link()
{
access_id = "root";
db_name = "inv";
@ db = mysql_connect('localhost', access_id, '831025') or 
die("Could not connect to database. Please contact with IT supporting team ASAP.");
mysql_query("SET NAMES 'GBK'");
mysql_select_db(db_name);
return db;
}
link = db_link();

//get inquiry criteria,用 POST取得数据也行
sn_id_1 = _REQUEST['sn_id_1'];
sn_id_2 = _REQUEST['sn_id_2'];

//inquiry total pages
sn_sql = "SELECT * FROM sn WHERE 1 ";
if (sn_id_1 != ''){
sn_sql .= "AND sn_id >= '".sn_id_1."' ";
}
if (sn_id_2 != ''){
sn_sql .= "AND sn_id }
sn_sql .= "ORDER BY sn_id DESC ";

sn_res = mysql_query(sn_sql);
total = mysql_num_rows(sn_res); 

//show page
pageshow = showpage(total);

//inquiry current page
sn_sql .= " limit offset,num";
sn_res = mysql_query(sn_sql);
sn_num = mysql_num_rows(sn_res);

//output inquiry result as XML 
header("Content-Type: text/xml");
if(total > 0){
echo '';
echo '';
echo ' echo '

LIST

';
num = offset;
for (i = 0; i sn_row = mysql_fetch_array(sn_res);
if (i % 2 == 0) {
echo '';
}else{
echo '';
}
echo'











';
num++;
}
echo '

No	SN	Plant	Sales	Act	Type	Status	Release Date	Approve Date	Reject Date	Cancel Date	Close Date
'.(num+1).'	'.sn_row['sn_id'].'	'.sn_row['sn_plant'].'	'.sn_row['sn_sales'].'	'.sn_row['sn_act'].'	'.sn_row['sn_type'].'	'.sn_row['sn_sts'].'	'.substr(sn_row['sn_rel_date'],0,10).'	'.substr(sn_row['sn_apv_date'],0,10).'	'.substr(sn_row['sn_rej_date'],0,10).'	'.substr(sn_row['sn_can_date'],0,10).'	'.substr(sn_row['sn_cls_date'],0,10).'

';
echo '

'.pageshow.'

';
echo '

';
echo ']]>';
echo '';
}else{
echo 'find nothing';
}

?>

http://www.bkjia.com/PHPjc/815027.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/815027.htmlTechArticlePHP+Ajax to implement paging technology: Paging technology code based on php and ajax. There are two php files below, one It is sn_inq.php, and the other one is sn_show.php. The previous php file calls the next ph...