代码如下:
<?php
$conn=mysql_connect("localhost","root","")or die("数据库服务器连接错误".mysql_error());
mysql_select_db("mazhiwei",$conn)or die("数据库访问错误".mysql_error());
mysql_query("set names gb2312");
if($page==""){
$page=1;
}
if(is_numeric($page)){
$page_size=4;
$query="select count(*) as total from tb_affiche order by id desc";
$result=mysql_query($query);
$message_count=mysql_result($result,0,"total");
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$sql=mysql_query("select * from tb_affiche order by id desc limit $offset,$page_size");
$row=mysql_fetch_object($sql);
if(!$row){
echo "<font color='red'>暂无公告信息</font>";
}
do{
?>
<tr bgcolor="#ffffff">
<td><?php echo $row->title;?></td>
<td><?php echo $row->content;?></td>
</tr>
<?php
}while($row=mysql_fetch_object($sql));
}
?>使用如下代码实现翻页功能:
<?php
if($page!=1){
echo "<a href=page_affiche.php?page=1>首页</a> ";
echo "<a href=page_affiche.php?page=".($page-1).">上一页</a> ";
}
if($page<$page_count){
echo "<a href=page_affiche.php?page=".($page+1).">下一页</a> ";
echo "<a href=page_affiche.php?page=".$page_count.">尾页</a> ";
}
mysql_free_result($sql);
mysql_close($conn);
?>请高手过目,明察问题所在,为在下解答,不胜感激
<?php
$conn=mysql_connect("localhost","root","")or die("数据库服务器连接错误".mysql_error());
mysql_select_db("mazhiwei",$conn)or die("数据库访问错误".mysql_error());
mysql_query("set names gb2312");
if($page==""){
$page=1;
}
if(is_numeric($page)){
$page_size=4;
$query="select count(*) as total from tb_affiche order by id desc";
$result=mysql_query($query);
$message_count=mysql_result($result,0,"total");
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$sql=mysql_query("select * from tb_affiche order by id desc limit $offset,$page_size");
$row=mysql_fetch_object($sql);
if(!$row){
echo "<font color='red'>暂无公告信息</font>";
}
do{
?>
<tr bgcolor="#ffffff">
<td><?php echo $row->title;?></td>
<td><?php echo $row->content;?></td>
</tr>
<?php
}while($row=mysql_fetch_object($sql));
}
?>使用如下代码实现翻页功能:
<?php
if($page!=1){
echo "<a href=page_affiche.php?page=1>首页</a> ";
echo "<a href=page_affiche.php?page=".($page-1).">上一页</a> ";
}
if($page<$page_count){
echo "<a href=page_affiche.php?page=".($page+1).">下一页</a> ";
echo "<a href=page_affiche.php?page=".$page_count.">尾页</a> ";
}
mysql_free_result($sql);
mysql_close($conn);
?>请高手过目,明察问题所在,为在下解答,不胜感激
判断变数是否已设定。
若$_GET['page']已存在则$page=$_GET['page'],否则等于1 。