为什么 之显示 第一页的 内容呢,下一页的 内容 显示不出来。、、、、 后面 连接的 问题 怎么改啊
<?php include("conn.php");
header("Content-Type:text/html,charset=gbk"); $pagesize = 5;
$url = $_SERVER["REQUEST_URI"];
$url = parse_url($url);
$url = $url[path]; $nump = mysql_query("select * from `bbs`");
$num = mysql_num_rows($nump);
if(isset($GET['page'])){
$page = intval($_GET['page']);
}
else
$page = 1;
$pages = ceil($num/$pagesize); $last_page = ($pages?$pages:1);
$pre_page = $page-1;
$next_page = $page+1;
$first_page = 1;
$offset = ($page-1)*$pagesize;
//$result = mysql_query("select * from `bbs`");
$result= "select * from `bbs` limit $offset,$pagesize";
$query=mysql_query($result);
while($row=mysql_fetch_array($query)){
?>
</div>
<style type="text/css">
#lay{
margin:10px auto;
width:500px;
border:1px dashed #0000ff;
background-color:#ffffff;
}
table{
border:2px dashed #008000;
margin:5px;
}
table tr{
color:#deff12;
}
</style>
<div id="lay">
<table>
<tr >
<td>标题:<?=$row['title']?></td>
</tr>
<tr>
<td>发表时间:<?=$row['lastdate']?></td>
</tr>
<tr>
<td>内容:<?=$row[content]?></td>
</tr>
</table>
</div>
<?
}
?>
<div id="lay">
<?
echo "显示第".$page."页到第".$last_page."页";
if(($page==1)&&($pages==1)){
echo "<a href=\"list.php?page=$page\">首页</a>";
}
else if(($page>=1)&&($pages==2)){
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
else if(($page>=1)&&($pages==3)){
$pagea = $page>1?$pre_page:$page;
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$pagea\">上一页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
else if(($page>=1)&&($pages>=4)){
$pagea = $page>1?$pre_page:$page;
$pageb = $page=$pages?$page:$next_page;
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$pagea\">上一页</a>$nbsp";
echo "<a href=\"list.php?page=$pageb\">下一页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
?>
<?php include("conn.php");
header("Content-Type:text/html,charset=gbk"); $pagesize = 5;
$url = $_SERVER["REQUEST_URI"];
$url = parse_url($url);
$url = $url[path]; $nump = mysql_query("select * from `bbs`");
$num = mysql_num_rows($nump);
if(isset($GET['page'])){
$page = intval($_GET['page']);
}
else
$page = 1;
$pages = ceil($num/$pagesize); $last_page = ($pages?$pages:1);
$pre_page = $page-1;
$next_page = $page+1;
$first_page = 1;
$offset = ($page-1)*$pagesize;
//$result = mysql_query("select * from `bbs`");
$result= "select * from `bbs` limit $offset,$pagesize";
$query=mysql_query($result);
while($row=mysql_fetch_array($query)){
?>
</div>
<style type="text/css">
#lay{
margin:10px auto;
width:500px;
border:1px dashed #0000ff;
background-color:#ffffff;
}
table{
border:2px dashed #008000;
margin:5px;
}
table tr{
color:#deff12;
}
</style>
<div id="lay">
<table>
<tr >
<td>标题:<?=$row['title']?></td>
</tr>
<tr>
<td>发表时间:<?=$row['lastdate']?></td>
</tr>
<tr>
<td>内容:<?=$row[content]?></td>
</tr>
</table>
</div>
<?
}
?>
<div id="lay">
<?
echo "显示第".$page."页到第".$last_page."页";
if(($page==1)&&($pages==1)){
echo "<a href=\"list.php?page=$page\">首页</a>";
}
else if(($page>=1)&&($pages==2)){
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
else if(($page>=1)&&($pages==3)){
$pagea = $page>1?$pre_page:$page;
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$pagea\">上一页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
else if(($page>=1)&&($pages>=4)){
$pagea = $page>1?$pre_page:$page;
$pageb = $page=$pages?$page:$next_page;
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$pagea\">上一页</a>$nbsp";
echo "<a href=\"list.php?page=$pageb\">下一页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
?>
header("Content-Type:text/html,charset=gbk"); $pagesize = 3;
$url = $_SERVER["REQUEST_URI"];
$url = parse_url($url);
$url = $url[path]; $nump = mysql_query("select * from `bbs`",$conn);
$num = mysql_num_rows($nump);
if(isset($_GET['page'])){ //此处应把$GET 改为$_GET,若不改的话无法获得变量$page的改动
$page = intval($_GET['page']);
}
else
$page = 1;
$pages = ceil($num/$pagesize); $last_page = ($pages?$pages:1);
$pre_page = $page-1;
$next_page = $page+1;
$first_page = 1;
$offset = ($page-1)*$pagesize;
//$result = mysql_query("select * from `bbs`");
$result= "select * from `bbs` limit $offset,$pagesize";
$query=mysql_query($result);
while($row=mysql_fetch_array($query)){
?>
</div>
<style type="text/css">
#lay{
margin:10px auto;
width:500px;
border:1px dashed #0000ff;
background-color:#ffffff;
}
table{
border:2px dashed #008000;
margin:5px;
}
table tr{
color:#deff12;
}
</style>
<div id="lay">
<table>
<tr >
<td>标题:<?=$row['title']?></td>
</tr>
<tr>
<td>发表时间:<?=$row['lastdate']?></td>
</tr>
<tr>
<td>内容:<?=$row['cont</td> //此处content加上单引号更好
</tr>
</table>
</div>
<?
}
?>
<div id="lay">
<?
echo "显示第".$page."页到第".$last_page."页";
if(($page==1)&&($pages==1)){
echo "<a href=\"list.php?page=$page\">首页</a>";
}
else if(($page>=1)&&($pages==2)){
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
else if(($page>=1)&&($pages==3)){
$pagea = $page>1?$pre_page:$page;
$pageb = $page==$pages?$page:$next_page;
echo "<a href=\"list.php?page=$page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$pagea\">上一页</a>$nbsp";
echo "<a href=\"list.php?page=$pageb\">下一页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
//这儿貌似加上下一页更好,要不然用户想翻到第二页怎么办,如果这样改了,那下面那一段也就不需要了
}
else if(($page>=1)&&($pages>=4)){
$pagea = $page>1?$pre_page:$page;
$pageb = $page==$pages?$page:$next_page;//此处第你把比较符号“==”与“=”弄混淆了
echo "<a href=\"list.php?page=$first_page\">首页</a>$nbsp";
echo "<a href=\"list.php?page=$pagea\">上一页</a>$nbsp";
echo "<a href=\"list.php?page=$pageb\">下一页</a>$nbsp";
echo "<a href=\"list.php?page=$last_page\">尾页</a>";
}
?>