当前位置: 代码迷 >> PHP >> php分页实现的有关问题
  详细解决方案

php分页实现的有关问题

热度:34   发布时间:2016-04-29 00:46:29.0
php分页实现的问题
在虚拟主机上可以实现自动分页,但在本地却不行?
具体代码
显示页
<table width=600 border=0 align=center> <? include("pageconfig.php"); $mysql_server_name = 'localhost'; $mysql_username = 'wind'; $mysql_password = '2008'; $mysql_database = 'wind'; mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database);$counter = mysql_query ("select count(*) as counte from word"); $myrow=mysql_fetch_array($counter); $total=$myrow['counte']; $firstcount=1;$displaypg=10;pageft($total,10); $conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database);$result = mysql_query ("select * from word limit $firstcount,$displaypg ");        echo("<table border=1;> ");     while($myrow = mysql_fetch_row($result)){                      echo("<tr>");                        for ($j=0;$j<7;$j++)                            {                              echo("<td>");                             printf("%s",$myrow[$j]);//输出标题                              echo("</td>");                              }                      echo("</tr>");}          echo("</table>");?> <td colspan=5 bgcolor=#CCCCCC><?=$pagenav;?></td> </tr> </table> pageconfig.php代码:<? if(!function_exists(pageft)){ function pageft($totle,$displaypg=20,$url=''){ global $page,$firstcount,$pagenav,$_SERVER; $GLOBALS["displaypg"]=$displaypg; if(!$page) $page=1; if(!$url){ $url=$_SERVER["REQUEST_URI"];} $parse_url=parse_url($url); $url_query=$parse_url["query"]; if($url_query){ $url_query=ereg_replace("(^|&)page=$page","",$url_query); $url=str_replace($parse_url["query"],$url_query,$url); if($url_query) $url.="&page"; else $url.="page"; }else { $url.="?page"; } $lastpg=ceil($totle/$displaypg); $page=min($lastpg,$page); $prepg=$page-1; //上一页 $nextpg=($page==$lastpg ? 0 : $page+1); //下一页 $firstcount=($page-1)*$displaypg; $pagenav="显示第 <B>".($totle?($firstcount+1):0)."</B>-<B>".min($firstcount+$displaypg,$totle)."</B> 条记录,共 $totle 条记录"; if($lastpg<=1) return false; $pagenav.=" <a href='$url=1'>首页</a> "; if($prepg) $pagenav.=" <a href='$url=$prepg'>前页</a> "; else $pagenav.=" 前页 "; if($nextpg) $pagenav.=" <a href='$url=$nextpg'>后页</a> "; else $pagenav.=" 后页 "; $pagenav.=" <a href='$url=$lastpg'>尾页</a> "; $pagenav.=" 到第 <select name='topage' size='1' onchange='window.location=\"$url=\"+this.value'>\n"; for($i=1;$i<=$lastpg;$i++){ if($i==$page) $pagenav.="<option value='$i' selected>$i</option>\n"; else $pagenav.="<option value='$i'>$i</option>\n"; } $pagenav.="</select> 页,共 $lastpg 页"; } } ?> 
  相关解决方案