Ajax example code to perfectly implement the paging function of two web pages_PHP tutorial

分页的首页

复制代码 代码如下:

武侠小说分页



<script><BR>var page='';<BR>  function init(page){<BR>  document.getElementById("tables").innerHTML='';<BR>   var xhr;<BR>   if(window.XMLHttpRequest){<BR> xhr = new XMLHttpRequest();<BR>}else if(window.ActiveXObject){<BR> xhr =new ActiveXObject("Microsoft.XMLHTTP")<BR>}<BR>var url="fenye.php";<BR> xhr.open("POST",url,true);<BR> xhr.onreadystatechange=callback;<BR> xhr.setRequestHeader("Content-Type","application/x-www-form-urlencoded");<BR> if(page){<BR> xhr.send("page="+page);<BR> }<BR> else {xhr.send("page=1");}<BR> var content;<BR> function callback(){<BR>   if(xhr.readyState==4){<BR>     if(xhr.status==200){<BR>      var json =eval('('+xhr.responseText+')');<BR>   //alert(xhr.responseText);<BR>  var fenye=json.str;<BR> //  alert(fenye);<BR>     document.getElementById('div').innerHTML=fenye;<BR>  content="<th>ID<th>名称<th>作者<th>出版社<th>ISBN号<th>类型<th>价格";<BR>  for(var i=0;i<json.info.length;i++){<BR>  content+="<tr><td>"+json.info[i].id+"<td>"+json.info[i].name+"<td>"+json.info[i].author+"<td>"+json.info[i].publisher+"<td>"+json.info[i].isbn+"<td>"+json.info[i].type+"<td>"+json.info[i].price+"";<BR>  document.getElementById("tables").innerHTML=content;<BR>  }<BR>    // alert(fenye);<BR>     }<BR>   }<BR>   }<BR> }<br><br></script>

 

jquery实现$.ajax的分页

ID	名称	作者	出版社	ISBN号	类型	价格

 

 

分页的php精华代码

复制代码 代码如下:

//Command the model layer to process data
$link=mysql_connect('localhost','root','') or die("failure");
mysql_select_db('books',$link) or die("Error connecting to the database!");
//Display the number of records per page
$pagesize = 2;
//Find the total number of records
$sql = "select count(*) as total_rows from books";
$result = mysql_query($sql);
$total_rows = mysql_fetch_array($result);
//Find the total Number of pages
$pages = ceil($total_rows[0]/$pagesize);
//The current page
$page = $_POST['page'];
$strtext = " Current page ".$page."."Total".$pages."Page"."Total".$total_rows[0]."Record";
//var_dump($str);
//Next, I need to find the corresponding data based on the currently clicked page number
$offset = $pagesize*($page-1);
$sql = "select * from books limit $offset,$pagesize ";
mysql_query("set names utf8");
$res=mysql_query($sql);

$rows=array();
while($row=mysql_fetch_assoc($ res)){
$rows[]=$row;
}
$pageInfo = $rows;
//echo json_encode($pageInfo);
//var_dump($pageInfo) ;
//The data link will be obtained and then returned to
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$ pages;

//Command the view layer to display data
$first_a = "";
if($page>1){
$prev_a = "";
}
if($page $next_a = "";
}
$last_a = "";
@$str = $strtext.$first_a.$prev_a.$next_a.$last_a;
//var_dump($str);
$info = array('str'=>$str,'info'=> $pageInfo);
echo json_encode($info);

http://www.bkjia.com/PHPjc/326843.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/326843.htmlTechArticle Copy the code on the homepage of the page as follows: meta http-equiv="Content-Type" content="text/html ; charset=utf8" / h1 align="center"Martial arts novel paging/h br/ script src="jquery-1.4.2.min...