class page{
private $pagesize; //保存每页最多显示的记录数
private $page; //保存当前的页数
private $pagecount; //保存页数
private $total; //保存总记录数
private $conn; //保存数据库连接句柄
public function __construct($pagesize,$page){
//构造函数,实现对类体中部分属性的初始化
$this->pagesize=$pagesize;
$this->page=$page;
}
public function listInfo($code,$style){
//定义listInfo()方法显示记录内容
if($this->page=="" || !is_numeric($this->page)){
$this->page=1;
}
$this->conn=MySQL_connect("localhost", "root", "123456");
mysql_select_db("air", $this->conn);
mysql_query("set names gb2312");
switch($code)
{
case 1: //未被删除的留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code!=-1 order by message_id desc limit",$this->conn);
break;
case 2: //未回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=0 order by message_id desc limit",$this->conn);
break;
case 3: //已回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=1 order by message_id desc limit",$this->conn);
break;
}
$info=mysql_fetch_array($sql);
$this->total=$info[total];
if($this->total==0) //总留言记录数若为0,显示暂无记录!
{
echo "<table width=704 height=20 border=0 align=center cellpadding=0 cellspacing=0>"+
"<tr>"+
"<td><div align=center>暂无留言!</div></td>"+
"</tr>"+
"</table>";
}
else
{
if (($this->total % $this->pagesize)==0)
{ $this->pagecount=intval($this->total / $this->pagesize); }
else
{
if ($this->total<=$this->pagesize)
{ $this->pagecount=1; }
else
{ $this->pagecount=ceil($this->total/$this->pagesize); }
}
switch ($code)
{
case 1: //未被删除的留言记录
$sql=mysql_query("select * from message_list where message_code!=-1 order by message_id desc limit
".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);
break;
case 2: //未回复留言记录
$sql=mysql_query("select * from message_list where message_code=0 order by message_id desc limit
".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);
break;
case 3: //已回复留言记录
$sql=mysql_query("select * from message_list where message_code=1 order by message_id desc limit
".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);
break;
}
?>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1">
<?php
while ($info=mysql_fetch_array($sql)){
?>
<tr>
<td height="20" bgcolor="#c2c41f"><font color="#FFFFFF"><div align="center">用户名</div></font></td>
<td height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_user];?></div></td>
<td height="20" bgcolor="#339999"><font color="#FFFFFF"><div align="center">留言时间</div></font></td>
<td height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_time];?></div></td>
</tr>
<tr>
<td height="20" bgcolor="#339999"><font color="#FFFFFF"><div align="center">留言标题</div></font></td>
<td colspan="3" height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_title];?></div></td>
</tr>
<tr>
<td height="20" bgcolor="#c2c41f"><font color="#FFFFFF"><div align="center">留言内容</div></font></td>
<td colspan="3" height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_content];?></div></td>
</tr>
<tr>
<td height="20" bgcolor="#339999"><font color="#FFFFFF"><div align="center">回复</div></font></td>
<?php switch($style)
{case 1: //用户方留言记录显示
{
if ($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复</div></td>";}
else
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]."</div></td>";
break;
}
case 2: //用户方留言删除功能显示
{
if ($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复 <a href=mdel.php?m_id=".$info[message_id].">[删除]</a></div></td>";}
else
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]." <a href=mdel.php?m_id=".$info[message_id].">[删除]</a></div></td>";
break;
}
case 3: //局方总留言功能显示
{
if ($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复
<a href='admin_replym.php?m_id=".$info[message_id]."'>[回复]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>"; }
else
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]."
<a href='admin_editm.php?m_id=".$info[message_id]."'>[编辑]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>";
break;
}
case 4: //局方留言回复功能显示
{
if($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复
<a href='admin_replym.php?m_id=".$info[message_id]."'>[回复]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>"; }
break;
}
case 5: //局方留言回复编辑功能显示
{
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]."
<a href='admin_editm.php?m_id=".$info[message_id]."'>[编辑]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>";
break;
}
default:
echo "留言记录显示出错!";
}?>
</tr>
<?php
}
echo "</table>";
}
}
public function toPage(){
//定义toPage()方法用于显示分页链接
?>
<table width="704" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="342"> 共有留言 <?php echo $this->total;?> 条 每页显示 <?php echo $this->pagesize;?> 条 第 <?php echo $this->page?> 页/共 <?php echo $this->pagecount?> 页</td>
<td width="362"><div align="right">
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=1">首页</a>
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php
if ($this->page>1)
echo $this->page-1;
else
echo 1;
?>">上一页</a>
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php
if ($this->page<$this->pagecount-1)
echo $this->page+1;
else
echo $this->pagecount;
?>">下一页</a>
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php echo $this->pagecount;?>">尾页</a>
</div></td>
</tr>
</table>
<?php
}
public function _destruct(){
mysql_close($this->conn);
}
}
总出现mysql_fetch_array(): supplied argument is not a valid MySQL result resource
如何解决?
private $pagesize; //保存每页最多显示的记录数
private $page; //保存当前的页数
private $pagecount; //保存页数
private $total; //保存总记录数
private $conn; //保存数据库连接句柄
public function __construct($pagesize,$page){
//构造函数,实现对类体中部分属性的初始化
$this->pagesize=$pagesize;
$this->page=$page;
}
public function listInfo($code,$style){
//定义listInfo()方法显示记录内容
if($this->page=="" || !is_numeric($this->page)){
$this->page=1;
}
$this->conn=MySQL_connect("localhost", "root", "123456");
mysql_select_db("air", $this->conn);
mysql_query("set names gb2312");
switch($code)
{
case 1: //未被删除的留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code!=-1 order by message_id desc limit",$this->conn);
break;
case 2: //未回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=0 order by message_id desc limit",$this->conn);
break;
case 3: //已回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=1 order by message_id desc limit",$this->conn);
break;
}
$info=mysql_fetch_array($sql);
$this->total=$info[total];
if($this->total==0) //总留言记录数若为0,显示暂无记录!
{
echo "<table width=704 height=20 border=0 align=center cellpadding=0 cellspacing=0>"+
"<tr>"+
"<td><div align=center>暂无留言!</div></td>"+
"</tr>"+
"</table>";
}
else
{
if (($this->total % $this->pagesize)==0)
{ $this->pagecount=intval($this->total / $this->pagesize); }
else
{
if ($this->total<=$this->pagesize)
{ $this->pagecount=1; }
else
{ $this->pagecount=ceil($this->total/$this->pagesize); }
}
switch ($code)
{
case 1: //未被删除的留言记录
$sql=mysql_query("select * from message_list where message_code!=-1 order by message_id desc limit
".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);
break;
case 2: //未回复留言记录
$sql=mysql_query("select * from message_list where message_code=0 order by message_id desc limit
".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);
break;
case 3: //已回复留言记录
$sql=mysql_query("select * from message_list where message_code=1 order by message_id desc limit
".$this->pagesize*($this->page-1).",$this->pagesize",$this->conn);
break;
}
?>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1">
<?php
while ($info=mysql_fetch_array($sql)){
?>
<tr>
<td height="20" bgcolor="#c2c41f"><font color="#FFFFFF"><div align="center">用户名</div></font></td>
<td height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_user];?></div></td>
<td height="20" bgcolor="#339999"><font color="#FFFFFF"><div align="center">留言时间</div></font></td>
<td height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_time];?></div></td>
</tr>
<tr>
<td height="20" bgcolor="#339999"><font color="#FFFFFF"><div align="center">留言标题</div></font></td>
<td colspan="3" height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_title];?></div></td>
</tr>
<tr>
<td height="20" bgcolor="#c2c41f"><font color="#FFFFFF"><div align="center">留言内容</div></font></td>
<td colspan="3" height="20" bgcolor="#ffffff"><div align="center"><?php echo $info[message_content];?></div></td>
</tr>
<tr>
<td height="20" bgcolor="#339999"><font color="#FFFFFF"><div align="center">回复</div></font></td>
<?php switch($style)
{case 1: //用户方留言记录显示
{
if ($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复</div></td>";}
else
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]."</div></td>";
break;
}
case 2: //用户方留言删除功能显示
{
if ($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复 <a href=mdel.php?m_id=".$info[message_id].">[删除]</a></div></td>";}
else
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]." <a href=mdel.php?m_id=".$info[message_id].">[删除]</a></div></td>";
break;
}
case 3: //局方总留言功能显示
{
if ($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复
<a href='admin_replym.php?m_id=".$info[message_id]."'>[回复]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>"; }
else
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]."
<a href='admin_editm.php?m_id=".$info[message_id]."'>[编辑]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>";
break;
}
case 4: //局方留言回复功能显示
{
if($info[message_code]==0){
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>等待回复
<a href='admin_replym.php?m_id=".$info[message_id]."'>[回复]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>"; }
break;
}
case 5: //局方留言回复编辑功能显示
{
echo "<td colspan='3' height='20' bgcolor='#ffffff'><div align='center'>".$info[message_reply]."
<a href='admin_editm.php?m_id=".$info[message_id]."'>[编辑]</a> <a href='admin_deletem.php?m_id=".$info[message_id]."'>[删除]</a></div></td>";
break;
}
default:
echo "留言记录显示出错!";
}?>
</tr>
<?php
}
echo "</table>";
}
}
public function toPage(){
//定义toPage()方法用于显示分页链接
?>
<table width="704" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="342"> 共有留言 <?php echo $this->total;?> 条 每页显示 <?php echo $this->pagesize;?> 条 第 <?php echo $this->page?> 页/共 <?php echo $this->pagecount?> 页</td>
<td width="362"><div align="right">
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=1">首页</a>
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php
if ($this->page>1)
echo $this->page-1;
else
echo 1;
?>">上一页</a>
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php
if ($this->page<$this->pagecount-1)
echo $this->page+1;
else
echo $this->pagecount;
?>">下一页</a>
<a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php echo $this->pagecount;?>">尾页</a>
</div></td>
</tr>
</table>
<?php
}
public function _destruct(){
mysql_close($this->conn);
}
}
总出现mysql_fetch_array(): supplied argument is not a valid MySQL result resource
如何解决?
echo出sql语句,然后贴到phpMyAdmin里面执行一下就知道是什么原因了
注意:phpmyadmin打开的数据库应该是你查询的那个数据库
{
case 1: //未被删除的留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code!=-1 order by message_id desc limit",$this->conn);
break;
case 2: //未回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=0 order by message_id desc limit",$this->conn);
break;
case 3: //已回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=1 order by message_id desc limit",$this->conn);
break;
} SQL语句不对,limit 后面应该有 数值,最后应该有个分号.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\PHP\phone\edit.php on line 16
那么你就应该至少帖出 D:\PHP\phone\edit.php 第16行附近的代码!!!!
$sql=mysql_query("select * from tb_phone where id=$id");
$row=mysql_fetch_array($sql); //这是第16行。
确认表单是 get 方式的只要 $_GET['id'] 为空
则 "select * from tb_phone where id=$id"
就变成 "select * from tb_phone where id="
不出错才怪呢!?
limit : limit 10 [取出10条记录]
估计是你limit没有值指定所以取不到结果
循环外面再执行 mysql_query 然后再执行 mysql_fetch_array
而且CASE里面最好定义一个DEFAULT
这是我的个人见解
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>博客Sky</title>
</head>
<link href="CSS/style.css" rel="stylesheet">
<?php
$str=array("大","更","创","天","科","客","博","技","立","新");
$word=strlen($str);
for($i=0;$i<4;$i++){
$num=rand(0,$word);
$img=$img."<img src='images/checkcode/".$num.".gif' width='16' height='16'>"; //显示随机图片
$pic=$pic.$str[$num]; //将图片转换成数组中的文字
}
?>
<script language="javascript">
function check(form){
if(form.txt_user.value==""){
alert("请输入用户名");form.txt_user.focus();return false;
}
if(form.txt_pwd.value==""){
alert("请输入密码");form.txt_pwd.focus();return false;
}
if(form.txt_yan.value==""){
alert("请输入验证码");form.txt_yan.focus();return false;
}
if(form.txt_yan.value!=form.txt_hyan.value){
alert("对不起,您输入的验证码不正确!");form.txt_yan.focus();return false;
}
}
</script>
<body onselectstart="return false">
<table width="757" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="right" valign="top">
<td height="149" colspan="2" background="images/head.jpg">
<table width="100%" height="149" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="51" align="right">
<br>
<table width="262" border="0" cellspacing="0" cellpadding="0">
<tr align="left">
<td width="26" height="20"><a href="index.php"></a></td>
<td width="71" class="word_white"><a href="index.php"><span style="FONT-SIZE: 9pt; COLOR: #000000; TEXT-DECORATION: none">首 页</span></a></td>
<td width="87"><a href="file_more.php"><span style="FONT-SIZE: 9pt; COLOR: #000000; TEXT-DECORATION: none">博客文章</span></a><span style="FONT-SIZE: 9pt"> </span></td>
<td width="55"><a href="RegPro.php"><span style="FONT-SIZE: 9pt; COLOR: #000000; TEXT-DECORATION: none">博客注册</span></a><span style="FONT-SIZE: 9pt"> </span></td>
<td width="23"> </td>
</tr>
</table>
<br></td>
</tr>
<tr>
<td height="66" align="right"><p> </p>
<p>博客天空网站欢迎您的光临!!!今天是<?php echo date("Y-m-d");?> </p></td>
</tr>
<tr>
<form name="form" method="post" action="checkuser.php">
<td height="20" valign="baseline">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="32%" height="20" align="center" valign="baseline"> </td>
<td width="67%" align="center" valign="baseline">用户名:
<input name=txt_user size="10">
密码:
<input name=txt_pwd type=password style="FONT-SIZE: 9pt; WIDTH: 65px" size="6">
验证码:
<input name="txt_yan" style="FONT-SIZE: 9pt; WIDTH: 65px" size="8">
<input type="hidden" name="txt_hyan" id="txt_hyan" value="<?php echo $pic;?>">
<?php echo $img; ?>
<input style="FONT-SIZE: 9pt" type=submit value=登录 name=sub_dl onClick="return check(form)">
</td>
<td width="1%" align="center" valign="baseline"> </td>
</tr>
</table> </td>
</form>
</tr>
</table></td>
</tr>
<tr>
<td width="236" height="501" background="images/left.jpg"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="155" align="center" valign="top"> <?php include "cale.php"; ?></td>
</tr>
<tr>
<td height="125" align="center" valign="top"><br> <table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="201" border="0" cellspacing="0" cellpadding="0" valign="top">
<?php
$sql=mysql_query("select id,title from tb_article order by now desc limit 5");
$info=mysql_fetch_array($sql);
$i=1;
do{
?>
<tr>
<td width="201" align="left" valign="top">
<a href="article.php?file_id=<?php echo $info[id];?>"><?php echo $i."、".substr($info[title],0,20);?></a>
</td>
</tr>
<?php
$i=$i+1;
}
while($info=mysql_fetch_array($sql));
?>
<tr>
<td height="10" align="right"><a href="file_more.php"><img src="images/more.gif" width="27" height="9" border="0"> </a></td>
</tr>
</table></td>
</tr>
</table></td></tr>
<tr>
<td height="193" align="center" valign="top"> <br>
<table width="145" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="middle"><table width="160" border="0" cellspacing="0" cellpadding="0" valign="top">
<?php
$sql=mysql_query("select id,tpmc,file from tb_tpsc order by scsj desc limit 2");
$info=mysql_fetch_array($sql);
do{
?>
<tr>
<td width="9" rowspan="2" align="center"> </td>
<td width="147" align="center"><img src="f_image.php?pic_id=<?php echo $info[id];?>" width="120" height="80" border="0"> </td>
<td width="10" rowspan="2" align="center"> </td>
</tr>
<tr>
<td align="center">图片名称:<?php echo $info[tpmc];?></td>
</tr>
<?php
}while($info=mysql_fetch_array($sql));
?>
</table></td>
</tr>
</table> </td>
</tr>
</table></td>
<td width="521" height="501" align="center" background="../images/right.jpg"><table width="100%" height="98%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td height="372" align="center"><table style="WIDTH: 252px" cellspacing=0 cellpadding=0>
<tbody>
<tr>
<td style="WIDTH: 429px; HEIGHT: 280px" colspan=3 rowspan=2>
<marquee onMouseOver=this.stop()
style="WIDTH: 426px; HEIGHT: 280px" onMouseOut=this.start()
scrollamount=2 scrolldelay=7 direction=up>
<span
style="FONT-SIZE: 9pt"><br>
为了更好的管理和维护博客天空网站,请您自觉遵守以下条款: <br>
<br>
(一)不得利用本网站进行商业广告宣传; <br>
(二)不得利用本网站发送非法文章;<br>
(三)不得利用本网站进行上传非法图片; <br>
(四)互相尊重,对自己的言论和行为负责; <br>
(五)普通用户欲删除文章、评论、图片等信息,请与管理员联系;<br>
(六)本网站版权归明日科技公司,不得对本网站进行转载或作为私用; <br>
</span>
</marquee></td>
</tr>
<tr></tr>
</tbody>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr align="center">
<td height="82" colspan="2" background="images/footer.jpg"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%"> </td>
<td width="48%"><span style="FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; FONT-FAMILY: 宋体; TEXT-ALIGN: center">欢迎访问博客网
请使用IE 6.0 在1024×768分辨率下浏览本网站<br>
CopyRight@
2006 明日科技开发</span></td>
<td width="19%"> </td>
</tr>
</table> </td>
</tr>
</table>
</body>
</html>
你的是POST 怎么接收到 $_GET 啊
在数据操作错误 未明的 时候 可以使用 fopen ("text.txt","w"); 来生成错误信息。
并确定是哪个 数据操作的错误。
$id=intval($_GET['id'])或$sql=mysql_query("select * from tb_phone where id='{$id}'");
session_start();
ob_start();
?>
<?php require("conn.php"); ?>
<?php require("checksession.php"); ?><?php
$classid=$_GET[classid];
$typeid=$_GET[typeid];$action=$_GET[action]; //获取操作命令
if($action=="del") //删除新闻
{
$id=$_GET['id'];
//echo($id);
//mysql_query("SET NAMES 'utf8'",$conn);
mysql_query("delete from news where Nid=$id");
header('location:listnews.php?classid='.$classid."&typeid=".$typeid);//跳转页面,注意路径
}
/*分页代码第一段开始**************************************************************************************************/
$page=isset($_GET['page'])?intval($_GET['page']):1; //这句就是获取page=18中的page的值,假如不存在page,那么页数就是1。
$num=20; //每页显示10条数据
/*
首先咱们要获取数据库中到底有多少数据,才能判断具体要分多少页,具体的公式就是
总数据数除以每页显示的条数,有余进一。
也就是说10/3=3.3333=4 有余数就要进一。
*/
//mysql_query("SET NAMES 'utf8'",$conn);
$total=@mysql_num_rows(mysql_query("select Nid from news where Classid=$classid and Typeid=$typeid")); //查询数据的总数,id是数据库中的一个自动赋值的字段
$pagenum=ceil($total/$num); //获得总页数//假如传入的页数参数大于总页数,则显示错误信息
//If($page>$pagenum || $page == 0){
//echo "<script language=javascript>alert('该栏目没有添加任何内容!');</script>";
//Exit;
//}
/*分页代码第一段结束*************************************************************************************************/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>网站后台管理系统</title>
<meta charset="gb2312" http-equiv="Content-Type" content="text/html">
<link rel="stylesheet" type="text/css" href="css.css"/>
<style type="text/css">
<!--
.STYLE4 {
color: #000000
}
.STYLE5 {font-size: 16px}
.STYLE7 {color: #FFFFFF}
-->
</style>
</HEAD>
<body>
<table cellSpacing="0" cellPadding="4" width="100%" border="0">
<tr bgColor="#ffffff">
<td align="center">
<table cellSpacing="0" cellPadding="0" width="90%" border="0">
<tr>
<td width="13"><IMG height="1" alt="" src="images/spacer.gif" width="13" border="0"></td>
<td><IMG height="1" alt="" src="images/spacer.gif" border="0"></td>
<td width="22"><IMG height="1" alt="" src="images/spacer.gif" width="21" border="0"></td>
</tr>
<tr>
<td><IMG id="n3_r1_c1" height="32" alt="" src="images/r1_c1.gif" width="13" border="0" name="n3_r1_c1"></td>
<td background="images/t_bg.gif" class="TD_title" id="tdTitleT" ><FONT color="#FFFFFF"><b>新闻列表</b></FONT></td>
<td><IMG id="n3_r1_c3" height="32" alt="" src="images/r1_c3.gif" width="22" border="0" name="n3_r1_c3"></td>
</tr>
<tr>
<td background="images/l_bg.gif"></td>
<td><?php
/*分页代码第二段开始*************************************************************************************************/
$offset=($page-1)*$num; //获取limit的第一个参数的值,假如第一页则为(1-1)*10=0,第二页为(2-1)*10=10。
//mysql_query("SET NAMES 'utf8'",$conn);
$info=mysql_query("select * from news where Classid=$classid and Typeid=$typeid order by Nid desc limit $offset,$num"); //获取相应页数所需要显示的数据,name是数据里的一个字段
While($it=@mysql_fetch_array($info)){
?>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td width="48" bgcolor="#FF9900"><div align="center"><?php print $it[0];?></div></td>
<td width="454" height="20" bgcolor="#ECE9D8"><div align="left"><?php print $it[1];?></div></td>
<td width="68"><div align="center"><?php print $it[3];?></div></td>
<td width="66" bgcolor="#00FF00"><div align="center" class="STYLE4">
<a href="Addnews.php?action=edit&id=<?php print $it[0];?>&classid=<?php print $it[4];?>&typeid=<?php print $it[5];?>">修改 </a><a href="listnews.php?action=del&id=<?php print $it[0];?>&classid=<?php print $it[4];?>&typeid=<?php print $it[5];?>">删除</a></div></td>
</tr></table>
<div align="center">
<?php
} //显示数据
For($i=1;$i<=$pagenum;$i++){
$show=($i!=$page)?"<a href='listnews.php?classid=".$classid."&typeid=".$typeid."&page=".$i."'>[$i]</a>":"<b>[$i]</b>";
Echo $show." ";
}/*显示分页信息,假如是当页则显示粗体的数字,其余的页数则为超连接,假如当前为第三页则显示如下
1 2 3 4 5 6
*/
/*分页代码第二段结束*************************************************************************************************/
?>
</div></td>
<td background="images/r_bg.gif"></td>
</tr>
<tr>
<td><IMG id="n3_r3_c1" height="28" alt="" src="images/r3_c1.gif" width="13" border="0" name="n3_r3_c1"></td>
<td background="images/b_bg.gif"></td>
<td><IMG id="n3_r3_c3" height="28" alt="" src="images/r3_c3.gif" width="21" border="0" name="n3_r3_c3"></td>
</tr>
</table>
</td>
</tr>
</table></body>
</HTML>
{
case 1: //未被删除的留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code!=-1 order by message_id desc limit",$this->conn);
break;
case 2: //未回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=0 order by message_id desc limit",$this->conn);
break;
case 3: //已回复留言记录
$sql=mysql_query("select count(*) as total from message_list where message_code=1 order by message_id desc limit",$this->conn);
break;
}
$info=mysql_fetch_array($sql);
上面的$sql非$sql。
变量有个作用域。明白?!!!
应该是这个问题