Implement paging with php and ajax_PHP tutorial

I have summarized some fart experiences
1. After using ajax to post data to the background page, you need to reconnect to the database. Don’t think that it is enough to connect with the previous session
2. In order to deal with the problem of returning garbled characters, I After adding header("Content-Type:text/html;charset=GB2312");, it can be displayed normally. Later, when I checked it in firefox, I was prompted to download this webpage. After searching a lot of information on the Internet, I got a vague understanding. There is a grammatical error in the web page code. For security reasons, Firefox will not display it directly but prompts for download. I rechecked the statement just now and found that I wrote an extra "". After removing it, the problem was solved, haha, so If you encounter such a problem, check the html tag carefully. After all, Firefox is not as smart as IE
3. Finally, as a web site developer, you must be responsible. Don’t think that everything will be fine if you pass the test in IE. After all, not everyone uses IE, and you have to do more tests in other browsers to show your professionalism

ajax script:

Copy the code The code is as follows:

<script> <BR>function viewpage(p){ <BR>if(window.XMLHttpRequest){ <BR>var xmlReq = new XMLHttpRequest(); <BR>} else if(window.ActiveXObject) { <BR>var xmlReq = new ActiveXObject('Microsoft.XMLHTTP'); <BR>} <BR>var formData = "page="+p; <BR>xmlReq.onreadystatechange = function(){ <BR>if(xmlReq.readyState == 4){ <BR>document.getElementById('content2').innerHTML = xmlReq.responseText; <BR>} <BR>} <BR>xmlReq.open("post", "hotel_list.php", true); <BR>xmlReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); <BR>xmlReq. send(formData); <BR>return false; ><BR>The code is as follows:<BR><div class="codebody" id="code62607"><br><br>header("Content-Type:text/html;charset=GB2312");  <BR>$pagesize=10;  <BR>//echo $_POST['page'];  <BR>$result = mysql_query("Select count(DISTINCT hotelname) FROM ".TBL_HOTELS);  <BR>$myrow = mysql_fetch_array($result);  <BR>$numrows=$myrow[0];  <br><br>$pages=intval($numrows/$pagesize);  <BR>if ($numrows%$pagesize)  <BR>$pages++;  <BR>if (isset($_POST['page'])){  <BR>$page=intval($_POST['page']);  <BR>}  <BR>else{  <BR>//设置为第一页  <BR>$page=1;  <BR>}  <BR>$first=1;  <BR>$prev=$page-1;  <BR>$next=$page+1;  <BR>$last=$pages;  <BR>//计算记录偏移量  <BR>$offset=$pagesize*($page - 1);  <BR>//读取指定记录数  <BR>$result=mysql_query("select `hotelname` , count( * ) from ".TBL_HOTELS." GROUP BY `hotelname` order by id desc limit $offset,$pagesize");  <BR>$num = mysql_num_rows($result);  <BR>while ($row = mysql_fetch_array($result,MYSQL_NUM)) {  <BR>$hotelname[] = $row[0];  <BR>$countpeople[] = $row[1];  <BR>}  <BR>for($a=0;$a<$num;$a++)  <BR>{  <BR>//$result=mysql_query("select count(title) from " . TBL_Comments ." where `title`="".$title[$a].""");  <BR>//$row = mysql_fetch_row($result);  <BR>echo "<TABLE style="MARGIN-BOTTOM: 20px" cellSpacing=0 cellPadding=0 width=100% border=0>n";  <BR>echo "<TBODY>n";  <BR>echo "<TR>n";  <BR>echo "<TD style="PADDING-TOP: 5px" vAlign=top align=left width=80>n";  <BR>//rating_bar($title[$a],5);  <BR>echo "n";  <BR>echo "<TD style="PADDING-TOP: 5px" align=left width=100%><A title=$hotelname[$a] style="FONT-SIZE: 14px" href=#>$hotelname[$a]n";  <BR>echo "n";  <BR>echo " <TR>n";  <BR>echo "<TD>n";  <BR>echo "<TD style="PADDING-LEFT: 0px">n";  <BR>echo "<img src="/static/imghwm/default1.png" data-src="images/comment.gif" class="lazy"   border=0 alt="Implement paging with php and ajax_PHP tutorial" >  推荐人数:($countpeople[$a]) |n";  <BR>echo "<SPAN>平均分：<STRONG> (".$count."票) | 评论数:()n";  <BR>echo "n";  <BR>}  <BR>echo "<TABLE  style="max-width:90%" cellSpacing=0 cellPadding=0 width="100%"";  <BR>echo "border=0>";  <BR>echo "<TBODY><TR><TD colSpan=3 height=20>";  <BR>echo "<DIV align=center>";  <BR>echo "<P align=left><FONT color=red>第".$page."页/总".$pages."页 | 总".$numrows."条 | ";  <BR>if ($page>1) echo "<a onclick="viewpage(".$first.")" href='#'>首页 | ";  <BR>if ($page>1) echo "<a onclick="viewpage(".$prev.")" href='#'>上页 | ";  <BR>if ($page<$pages) echo "<a onclick="viewpage(".$next.")" href='#'>下页 | ";  <BR>if ($page<$pages) echo "<a onclick="viewpage(".$last.")" href='#'>尾页";  <BR>echo "转到第 <INPUT maxLength=3 size=3 value=1 name=goto_page> 页 <INPUT hideFocus onclick="viewpage(document.all.goto_page.value)" type=button value=Go name=cmd_goto>";  <BR>echo "</script>

";

http://www.bkjia.com/PHPjc/318828.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/318828.htmlTechArticleI have summarized some fart experiences 1. After using ajaxpost data to the background page, you need to reconnect to the database. Don’t think Just connect with the previous session. 2. In order to deal with the problem of returning garbled characters...