做的分页显示页面,第一次的链接过去就是这样的了,页面一条数据都没有,要点击首页和上一页后才会显示正常....点击后正常的显示:一下是分页代码...<table width="800px" border="0" bgcolor="#6699CC" align="center" cellpadding="0" cellspacing="0" height="25px">
<form name="form" action="show_material.php" method="get">
<tr>
<td width="64%">页次:<?php echo $_GET[page];?>/<?php echo $page_count;?> 页记录:<?php echo $message_count;?>条</td>
<td width="36%">
<?php
if ($_GET[page]!=1){
echo "<a href = show_material.php?page=1>首页</a>;";
echo "<a href = show_material.php?page=".($_GET[page]-1).">上一页</a>;";
}
if($_POST[page]<$page_count){
echo "<a href=show_material.php?page=".($_GET[page]+1).">下一页</a>;";
echo "<a href=show_material.php?page=".$page_count.">尾页</a>;";
}
?>
<input name="page" type="text" size="3" />
<input name="pages" type="hidden" value="<?php echo $page_count;?>" />
<input name="submit" type="submit" value="转到" />
</td>
</tr>
</form>
</table>
[color=#FF0000]
需要达人们解答求真相!!![/color]
<form name="form" action="show_material.php" method="get">
<tr>
<td width="64%">页次:<?php echo $_GET[page];?>/<?php echo $page_count;?> 页记录:<?php echo $message_count;?>条</td>
<td width="36%">
<?php
if ($_GET[page]!=1){
echo "<a href = show_material.php?page=1>首页</a>;";
echo "<a href = show_material.php?page=".($_GET[page]-1).">上一页</a>;";
}
if($_POST[page]<$page_count){
echo "<a href=show_material.php?page=".($_GET[page]+1).">下一页</a>;";
echo "<a href=show_material.php?page=".$page_count.">尾页</a>;";
}
?>
<input name="page" type="text" size="3" />
<input name="pages" type="hidden" value="<?php echo $page_count;?>" />
<input name="submit" type="submit" value="转到" />
</td>
</tr>
</form>
</table>
[color=#FF0000]
需要达人们解答求真相!!![/color]
include ("conn.php"); //引用函数连接数据库
$sql = mysql_query("select * from tbl_material order by id desc" , $conn);
$info = mysql_fetch_array($sql);
if ($_GET[page]){
$page_size=10; //设置每页显示多少条数据
$query = "select count(*) as total from tbl_material"; //查找数据库中一共有多少条数据
$result = mysql_query($query);
$message_count = mysql_result($result,0,"total");
$page_count = ceil($message_count/$page_size);
$offset = ($_GET[page]-1)*$page_size;
$query = mysql_query("select * from tbl_material where id limit $offset,$page_size");
while($info=mysql_fetch_array($query)){
?>
if(!isset($_GET['page']) && $_GET['page'] < 1){
$_GET['page'] = 1;
}
???
首次进入时,该表达式不成立。不会进入该分支。所以也就不会有数据
$_GET['page'] = 1;
}
放到if上面
<?php
include ("conn.php"); //引用函数连接数据库
$sql = mysql_query("select * from tbl_material order by id desc" , $conn);
$info = mysql_fetch_array($sql);
if(!isset($_GET['page']) && $_GET['page'] < 1){
$_GET['page'] = 1;
} if ($_GET[page]){
$page_size=10; //设置每页显示多少条数据
$query = "select count(*) as total from tbl_material"; //查找数据库中一共有多少条数据
$result = mysql_query($query);
$message_count = mysql_result($result,0,"total");
$page_count = ceil($message_count/$page_size);
$offset = ($_GET[page]-1)*$page_size;
$query = mysql_query("select * from tbl_material where id limit $offset,$page_size");
while($info=mysql_fetch_array($query)){
?>
$sql = mysql_query("select * from tbl_material order by id desc" , $conn);
$info = mysql_fetch_array($sql);
if(!isset($_GET['page']) || $_GET['page'] < 1){
$_GET['page'] = 1;
}
//这个原来的if此刻看来已经没用了,可以去掉
$page_size=10; //设置每页显示多少条数据
$query = "select count(*) as total from tbl_material"; //查找数据库中一共有多少条数据
$result = mysql_query($query);
$message_count = mysql_result($result,0,"total");
$page_count = ceil($message_count/$page_size);
$offset = ($_GET[page]-1)*$page_size;
$query = mysql_query("select * from tbl_material where id limit $offset,$page_size");
while($info=mysql_fetch_array($query)){