<?php function _PAGEFT($total,$displaypg = 20,$url = ''){
global $page,$firstcount,$pagenav,$_SERVER;
$GLOBALS["displaypg"] = $displaypg;
if(!$page)
$page = 1;
if(!$url){
$url = $_SERVER['REQUEST_URI'];
}
//url分析;
$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 = "this is <b>" .($totle ?($firstcount + 1) : 0)."</b>-<b>" .min($firstcount + $displaypg,$totle)."</b>tiao record,have $totle tiao record";
$pagenav = "now <B>" . ($totle ? ($firstcount +1) : 0) . "</B>-<B>" . min($firstcount + $displaypg, $totle) . "</B> record,total $totle records";
if($lastpg <= 1)
return false;
$pagenav .= "<a href='$url=1'>firstpage</a>";
if($prepg)
$pagenav .= "<a href='$url=$prepg'>pagepre</a>";
else
$pagenav .= "pagepre";
if($nextpg)
$pagenav .= "<a href='$url=$nextpg'>nextpage</a>";
else
$pagenav .= "nextpage";
$pagenav .= " <a href='$url=$lastpg'>lastpage</a>";
$pagenav .= "to<select name='topage' size='1' onChange='window.location=\"$url=\"+this.value'>\n";
//$pagenav .= "到第 <select name='topage' size='1' onchange='window.location=\"$url=\"+this.value'>\n";
//for ($i = 1; $i <= $lastpg; $i++)
for($i=1;$i<=$lastpg;$i++){
if($i == $page)
//$pagenav .= "<option value="$i" selected>$i</option>\n";
$pagenav .= "<option value='$i' selected>$i</option>\n";
else
$pagenav .= "<option value='$i'>$i</option>\n";
}
$pagenav .= "</select>page,total $lastpg page";
}
include("conn_02.php");
$result = mysql_query("select * from message");
$total = mysql_num_rows($result);
_PAGEFT($total,5);
echo $pagenav;
$result=mysql_query("SELECT * FROM message limit $firstcount,$displaypg ");
while($row=mysql_fetch_array($result)){ echo "<hr><b>".$row[user]." | ".$row[title];
}
?>
///////////////////////////////////////
conn_02.php文件是:
<?php
$conn = @mysql_connect("localhost","root","admin") or die("linked error!");
mysql_select_db("bbs",$conn);
mysql_query("set names 'GBK'");
?>
///////////////////////////////////////////////
输出的结果是:
now 0-0 record,total records
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\SoftWare\Study\PHP\mess_02\page_02.php on line 67mysqlquery
global $page,$firstcount,$pagenav,$_SERVER;
$GLOBALS["displaypg"] = $displaypg;
if(!$page)
$page = 1;
if(!$url){
$url = $_SERVER['REQUEST_URI'];
}
//url分析;
$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 = "this is <b>" .($totle ?($firstcount + 1) : 0)."</b>-<b>" .min($firstcount + $displaypg,$totle)."</b>tiao record,have $totle tiao record";
$pagenav = "now <B>" . ($totle ? ($firstcount +1) : 0) . "</B>-<B>" . min($firstcount + $displaypg, $totle) . "</B> record,total $totle records";
if($lastpg <= 1)
return false;
$pagenav .= "<a href='$url=1'>firstpage</a>";
if($prepg)
$pagenav .= "<a href='$url=$prepg'>pagepre</a>";
else
$pagenav .= "pagepre";
if($nextpg)
$pagenav .= "<a href='$url=$nextpg'>nextpage</a>";
else
$pagenav .= "nextpage";
$pagenav .= " <a href='$url=$lastpg'>lastpage</a>";
$pagenav .= "to<select name='topage' size='1' onChange='window.location=\"$url=\"+this.value'>\n";
//$pagenav .= "到第 <select name='topage' size='1' onchange='window.location=\"$url=\"+this.value'>\n";
//for ($i = 1; $i <= $lastpg; $i++)
for($i=1;$i<=$lastpg;$i++){
if($i == $page)
//$pagenav .= "<option value="$i" selected>$i</option>\n";
$pagenav .= "<option value='$i' selected>$i</option>\n";
else
$pagenav .= "<option value='$i'>$i</option>\n";
}
$pagenav .= "</select>page,total $lastpg page";
}
include("conn_02.php");
$result = mysql_query("select * from message");
$total = mysql_num_rows($result);
_PAGEFT($total,5);
echo $pagenav;
$result=mysql_query("SELECT * FROM message limit $firstcount,$displaypg ");
while($row=mysql_fetch_array($result)){ echo "<hr><b>".$row[user]." | ".$row[title];
}
?>
///////////////////////////////////////
conn_02.php文件是:
<?php
$conn = @mysql_connect("localhost","root","admin") or die("linked error!");
mysql_select_db("bbs",$conn);
mysql_query("set names 'GBK'");
?>
///////////////////////////////////////////////
输出的结果是:
now 0-0 record,total records
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\SoftWare\Study\PHP\mess_02\page_02.php on line 67mysqlquery
while($row=mysql_fetch_array($result)){ //出错 supplied argument is not a valid MySQL result resource
表示前面的查询失败
就是SQL指令
SELECT * FROM message limit $firstcount,$displaypg
是错误的极有可能是 $displaypg 变量不存在