phpajaxoracle分段加载技术.docVIP

php+ajax+oracle列表页分段加载技术 ?php+ajax+oracle无刷新分段加载技术代码示例如下1、list.php文件内容??phpheader ( Content-type: text/html; charset=utf-8 );require_once inc/conn.php;$tid = $_GET [tid];$sql = SELECT COUNT(INFOID) CNT FROM?test WHERE TID=.$tid.;// echo $sql;$stmt = oci_parse ( $conn, $sql );@oci_execute ( $stmt );$v = oci_fetch_assoc ( $stmt );$rows = $v [CNT];?!DOCTYPE htmlhtmlheadmeta charset=UTF-8title新闻列表/titlelink href=css/newslist.css rel=stylesheet type=text/cssscript type=text/javascriptvar rows=?php echo $rows-10?; //剩余未显示行数var tid=?php echo $tid?;??? //当前频道编码var limit=10;???? //步进var start=limit+1;//开始行//列表无刷新分段加载function disMore(){?//当剩余行数不大于10时隐藏更多标签?if(rows=10){??document.getElementById(morelist).style.display = none;?}?//alet(1);?xmlHttp=GetXmlHttpObject();???? if (xmlHttp==null){???????? alert (您使用的浏览器不支持HTTP Request);???????? return;???? }?var url=getList.php?start=+start+limit=+limit+tid=+tid;?xmlHttp.onreadystatechange=stateChanged; //回调函数?xmlHttp.open(GET,url,true);?xmlHttp.send(null);}//回调函数? 分段加载数据实现function stateChanged(){ ??? if (xmlHttp.readyState==4 || xmlHttp.readyState==complete){ ??? ?document.getElementById(datadiv).innerHTML=document.getElementById(datadiv).innerHTML+xmlHttp.responseText;??? ?start+=limit;??? ?rows-=limit;??????? return true;??? } }//根据不同浏览器请求对象function GetXmlHttpObject(){??? var xmlHttp=null;??? try {??????? // Firefox, Opera 8.0+, Safari??????? xmlHttp=new XMLHttpRequest();???? }catch (e){???????? // Internet Explorer???????? try{???????????? xmlHttp=new ActiveXObject(Msxml2.XMLHTTP);???????? }catch (e){???????????? xmlHttp=new ActiveXObject(Microsoft.XMLHTTP);???????? }??? }??? return xmlHttp;}/script/headbody?div id=datadiv?php$data = ;if ($rows 0) {?$sql = SELECT A.* FROM (SELECT INFOID,TITLE FROM test ?WHERE TID=.$id. ORDER BY PUBTIME DESC) A WHERE ROWNUM=10;?// echo $sql;?$stmt = oci_parse ( $conn, $sql );?oci_execute ( $stmt );?while ( $v = oci_fetch_