PHP Ajax 实现分页技术-PHP编程教程.doc

基于php和ajax的分页技术代码，下面有两个php文件，一个是sn_inq.php，另一个是sn_show.php，前一个php文件调用后一个php文件，实现ajax分页，运行sn_inq即可实现效果，不过得修改数据库哦。具体代码如下：红色标注的地方要特别注意修改哦！我的数据库名是inv，表名是sn，字段有：sn_id,sn_plant,sn_sales,sn_act,sn_type,sn_sts.1.sn_inq.php/getFormValue 用于获取表单中所有输入控件的值，并将输入值组成一个字符串传到服务器。 function getFormValue(form)var str=;var ft,fv;for (var i=0; iform.elements.length; i+)fv = form.elementsi;ft = fv.type.toLowerCase();switch(ft)case select-one:str+=+=+escape(fv.value)+&;break;case radio:if (fv.checked)str+=+=+escape(fv.value)+&;break;case checkbox:if (fv.checked)str+=+=+escape(fv.value)+&;break;case text:str+=+=+escape(fv.value)+&;break;case password:str+=+=+escape(fv.value)+&;break;case hidden:str+=+=+escape(fv.value)+&;break;case textarea:str+=+=+escape(fv.value)+&;break;default:break;return str.split(/s/).join() /showcomment(page) 用于显示分页数据，被查询按钮onclick 事件调用， url为后台处理数据并输出XML格式数据的文件url。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);elsedocument.form1.submit(););/displayLoading用于显示Loading，提示用户等待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用于去掉Loadingfunction removeLoading(element)var image = element.getElementsByTagName(img);for(var i=0;i -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 XMLaj.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; iversions.length; i+) try request = new ActiveXObject(versionsi);if(request) return request; catch(e) /alert(e.message);return request;aj.XMLHttpRequest = aj.createXMLHttpRequest();cessHandle = 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 = cessHandle;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 = cessHandle;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.allid; else if (document.layers) return document.layersid; else return null; ?php/注意：此处如果有filesedset的话，form表单一定要放在fieldset里面，否则出错。echo SN to ;?2.sn_show.php:?php/page functionfunction showpage(total)global page,pagenav,middle,num,pagenum,offset,prepg,nextpg;/获取page=18中的page的值，假如不存在page，那么页数就是1。page=isset(_REQUESTpage)?intval(_REQUESTpage):1; /每层分页条显示4个分页连接middle = 4; /每页显示10条数据num=10; /获得总页数,也是最后一页 pagenum=ceil(total/num); /获得首页 page=min(pagenum,page);/上一页prepg=page-1;/下一页nextpg=(page=pagenum ? 0 : page+1);offset=(page-1)*num;if(pagenum=1) return false;if(prepg)pagenav.= .iconv(gb2312,gb2312,首页). ;pagenav.= .iconv(gb2312,gb2312,上一页). ;elsepagenav.=.iconv(gb2312,gb2312,首页). pagenav.=.iconv(gb2312,gb2312,上一页).;if(nextpg)pagenav.= .iconv(gb2312,gb2312,下一页). ; pagenav.= .iconv(gb2312,gb2312,尾页). ;elsepagenav.=.iconv(gb2312,gb2312,下一页). pagenav.=.iconv(gb2312,gb2312,尾页). pagenav.=.iconv(gb2312,gb2312,共 ) . pagenum . .iconv(gb2312,gb2312,页); for(h=(page-middle1?1:page-middle);hpagenum?pagenum:page+middle);h+)if(h=page)pagenav.= h ;elsepagenav.=  .iconv(gb2312,gb2312,h).  pagenav.=    pagenav.=iconv(gb2312,gb2312,转到 );pagenav.=;for (i = 1; i = pagenum;i+)if(page = i)pagenav.= .i.;elsepagenav.= .i.;pagenav.=;pagenav.=页;return pagenav;/connect to databasefunction 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 = _REQUESTsn_id_1;sn_id_2 = _REQUESTsn_id_2;/inquiry total pagessn_sql