论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2005-11-03 09:18 |只看该作者 |倒序浏览

文件夹中共有三个php文件，一个image文件夹；
执行add.php和guestbook.php均报错，报错的一行都是：
$message_count=mysql_result($result,0,"title");
查找：$result=mysql_query($sqldo);
查找：$sqldo="select count(*) as title from $mytable where sub_id<1";@将其改为select web from ...也不行@
$mytable在config.php中定义如下：$mytable="guestbook";
在mysql客户端中show databases;出现有web数据项
show tables;出现空值 empty
不知道自己那里出错了，是否我应该手动填写table项呢？
请高手指点，下面是源代码！

[ 本帖最后由 kronos911 于 2005-11-3 12:43 编辑 ]

文库|博客

kronos911

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2005-11-03 09:19 |只看该作者

add.php

add.php
<?
require("config.php");
$sqldo="select count(*) as title from $mytable where sub_id<1";
$result=mysql_query($sqldo);
$message_count=mysql_result($result,0,"title");
?>
<table border="0" width="75%" cellspacing="0" cellpadding="0" align="center">
  <tr bgcolor="FFEAA2">
<td width="100%" height="18" valign="bottom" align="right">ÁôÑÔ×ÜÊý£º<font color=red><?echo $message_count?></font> | <a href="guestbook.php">¿´ÁôÑÔ</a>    </td>
  </tr>
</table>
<?
if ($doadd)
{
      $name=htmlspecialchars($name);
      $email=htmlspecialchars($email);
      $comefrom=htmlspecialchars($comefrom);
      $homepage=htmlspecialchars($homepage);
      $icq=htmlspecialchars($icq);
      $oicq=htmlspecialchars($oicq);
      $image=htmlspecialchars($image);
      $comment=htmlspecialchars($comment);
if ($name&&$comment) {
$add_time=date("Y")."-".date("m")."-".date("d")." ".date("H").":".date("i").":".date("s");
$result=mysql_query("insert into $mytable (sub_id,name,email,comefrom,homepage,icq,oicq,image,comment,password,add_time) values ('$sub_id','$name','$email','$comefrom','$homepage','$icq','$oicq','$image','$comment','$password','$add_time')");
if ($notify) {
$message="$comment\n\n$name $email\n\n$add_time";
mail($admin_email, "ÓÐÐÂµÄÁôÑÔ: ".$name, $message, "From: ".$email."\nReply-To: ".$email."\nX-Mailer: PHP/" . phpversion());
}
echo "<p align=\"center\">ÄúµÄÁôÑÔ·¢ËÍ³É¹¦£¬Ð»Ð»£¡<a href=\"guestbook.php\">²é¿´ÁôÑÔÇë·µ»Ø</a></p>\n";
}
else {
echo "<p align=\"center\">ÐÕÃûºÍÄÚÈÝ±ØÐëÌîÐ´£¡<a href=\"JavaScript:history.back()\">·µ»Ø</a></p>\n";
}
}
else {
if ($reply&&$recid) {
echo "<p align=\"center\">»Ø¸´ÁôÑÔ</p>";
$sub_id="<input type=\"hidden\" name=\"sub_id\" value=\"$recid\">";
}
else {
echo "<p align=\"center\">ÌîÐ´ÁôÑÔ</p>";
}
echo "<form method=\"POST\" action=\"add.php\">
<table border=\"0\" width=\"75%\" align=\"center\">
   <tr>
      <td>
      <div align=\"center\">
         <table border=\"0\" width=\"80%\" cellpadding=\"20\" cellspacing=\"0\">
            <tr>
            <td width=\"100%\" bgcolor=\"FFFBEC\">ÐÕÃû: <input type=\"text\" name=\"name\" size=\"25\">$sub_id
               µç×ÓÓÊ¼þ: <input type=\"text\" name=\"email\" size=\"25\"><br>
               À´×Ô: <input type=\"text\" name=\"comefrom\" size=\"25\"> Ö÷Ò³µØÖ·: <input type=\"text\" name=\"homepage\" size=\"25\"><br>
               OICQ: <input type=\"text\" name=\"oicq\" size=\"25\">
               <p>±íÇé: ";
$con=1;
while ( list( $key, $val ) = each( $images ) ) {
$checked="";
if ($con==1) {
$checked=" checked";
$con=0;
}
echo "<input type=\"radio\" value=\"$key\" name=\"image\"$checked><img border=\"0\" src=\"$imgdir/$key\" alt=\"$val\"> ";
}
echo "</p>\n                <p><b>ÁôÑÔ:</b><br>
               <textarea rows=\"4\" name=\"comment\" cols=\"72\"></textarea></p>
               <p><input type=\"submit\" value=\"·¢ËÍÁôÑÔ\" name=\"doadd\"> <input type=\"reset\" value=\"²ÁµôÖØÐ´\" name=\"B2\"></td>
            </tr>
         </table>
      </div>
      </td>
   </tr>
</table>
</center>
  </div>
</form>
";
}
?>

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

kronos911

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2005-11-03 09:20 |只看该作者

guestbook.php

guestbook.php
<?
require("config.php"

;
if (!$page)
{
$page=1;
}
$sqldo="select count(*) as title from $mytable where sub_id<1";
$result=mysql_query($sqldo);
$message_count=mysql_result($result,0,"title"

;
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$sqldo="select * from $mytable where sub_id<1 order by id desc limit $offset, $page_size";
$result=mysql_query($sqldo);
?>
<table border="0" width="70%" cellspacing="0" cellpadding="0" align="center">
  <tr bgcolor="FFEAA2">
<td width="100%" height="18" valign="bottom" align="right">ÁôÑÔ×ÜÊý£º<font color=red><?echo $message_count?></font> | <a href="add.php">Ð´ÁôÑÔ</a>    </td>
  </tr>
</table>
<br>
<table border="0" width="70%" cellspacing="0" cellpadding="0" align="center">
<?
if($result)
{
while($myrow=mysql_fetch_array($result))
{
listtopic($myrow,"70%",1);
$sqldo2="select * from $mytable where sub_id=$myrow[id] order by add_time";
$result2=mysql_query($sqldo2);
if($result2)
{
$rows2=mysql_num_rows($result2);
if($rows2)
{
?>

  <tr>
<td width="100%">
   <table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
      <tr>
      <td width="5%" bgcolor="FFFECC" align="center">»Ø<br>¸´</td>
      <td width="95%">
<?
while($myrow2=mysql_fetch_array($result2))
{
listtopic($myrow2,"100%",0);
echo "  </table>";
}
?>
   </td>
      </tr>
   </table>
</td>
  </tr>
<?
}
}

echo "  </table>
<br>
";
}
$prev_page=$page-1;
$next_page=$page+1;
echo "          <p align=\"center\">| ";
if ($page<=1){
echo "µÚÒ»Ò³ | ";
}
else{
echo "<a href='$PATH_INFO?page=1'>µÚÒ»Ò³</a> | ";
}
if ($prev_page<1){
echo "ÉÏÒ»Ò³ | ";
}
else{
echo "<a href='$PATH_INFO?page=$prev_page'>ÉÏÒ»Ò³</a> | ";
}
if ($next_page>$page_count){
echo "ÏÂÒ»Ò³ | ";
}
else{
echo "<a href='$PATH_INFO?page=$next_page'>ÏÂÒ»Ò³</a> | ";
}
if ($page>=$page_count){
echo "×îºóÒ»Ò³ |</p>\n";
}
else{
echo "<a href='$PATH_INFO?page=$page_count'>×îºóÒ»Ò³</a> |</p>\n";
}
}

function listtopic($myrow,$this_table_width,$is_reply)
{
global $imgdir;
$comment=nl2br($myrow[comment]);
if ($myrow[email]) {
$line1_left="<img border=\"0\" src=\"$imgdir\\$myrow[image]\"> <a href=\"mailto

myrow[email]\">$myrow[name]</a>";
}
else {
$line1_left="<img border=\"0\" src=\"$imgdir\\$myrow[image]\"> $myrow[name]";
}
if ($myrow[comefrom]) {
$line1_left .= "  À´×Ô: $myrow[comefrom]";
}
else {
$line1_right="";
}
if ($myrow[oicq]) {
$line1_right .= " <img border=\"0\" src=\"$imgdir\\oicq.gif\" alt=\"OICQ

myrow[oicq]\">";
}
if ($myrow[homepage]) {
$line1_right .= " <a href=\"$myrow[homepage]\" target=\"_blank\"><img border=\"0\" src=\"$imgdir\\homepage.gif\" alt=\"Ö÷Ò³

myrow[homepage]\"></a>";
}
if ($is_reply) {
$toolsbar="<a href=\"add.php?reply=1&recid=$myrow[id]\" $table_head_bodystyle>»Ø¸´</a> ";
}
$toolsbar .= "ÐÞ¸Ä É¾³ý ";
?>
  <table border="0" width="<?echo $this_table_width?>" align="center">
<tr>
   <td width="100%" bgcolor="fff8d9">
      <table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
         <td width="50%"><?echo $line1_left?></td>
         <td width="50%" align="right"><?echo $line1_right?> </td>
      </tr>
      </table>
   </td>
</tr>
<tr>
   <td width="100%" bgcolor="FFFBEC"><?echo $comment?></td>
</tr>
<tr>
   <td width="100%" bgcolor="FFFBEC">
      <table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
         <td width="50%">ÁôÑÔÊ±¼ä£º<?echo $myrow[add_time]?></td>
         <td width="50%" align="right"><?echo $toolsbar?></td>
      </tr>
      </table>
   </td>
</tr>
<?
}
?>

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

kronos911

白手起家

论坛徽章:: 0

4楼 [报告]

发表于 2005-11-03 09:21 |只看该作者

config.php

config.php
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>PHP4.0 +MYSQL ÁôÑÔ±¾</title>
<style type="text/css">

</style>
</head>
<body alink="#FF0000" link="#000099" vlink="#CC6600" topmargin="8" leftmargin="0" bgColor="#FFFFFF">
<center><font color=red size=6>PHP4.0+MYSQL ÁôÑÔ±¾</font></center><br>
<?
$dbuser=mysql_connect('localhost','root','mysql');
$mydb=mysql_select_db('web',$dbuser);
$mytable="guestbook"; // ±íÃû
$page_size=8;
$notify=1;
$imgdir="images";

$images=array( "say.gif" => "Ëæ±ãËµËµ",
"happy.gif" => "¸ßÐË",
"sad.gif" => "±¯ÉË",
"toohappy.gif" => "´óÐ¦",
"wilk.gif" => "Õ£ÑÛ",
"warning.gif" => "¾¯¸æ",
"question.gif" => "ÎÊÌâ",
"reply.gif" => "»Ø´ð",
"attention.gif" => "×¢Òâ",
"agree.gif" => "Í¬Òâ",
"other.gif" => "ºÅÍâ" );
?>

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

HonestQiao

版主

论坛徽章:: 1

5楼 [报告]

发表于 2005-11-03 09:26 |只看该作者

原帖由 kronos911 于 2005-11-3 09:18 发表
文件夹中共有三个php文件，一个image文件夹；
执行add.php和guestbook.php均报错，报错的一行都是：
$message_count=mysql_result($result,0,"title");
查找：$result=mysql_query($sqldo);
查找： ...

报错？
报什么错？
然后，为什么报这个错？

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

kronos911

白手起家

论坛徽章:: 0

6楼 [报告]

发表于 2005-11-03 09:52 |只看该作者

我在freebsd 5.4+apache2+php4中访问页面guestbook.php出现:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/server/apache2/htdocs/test/89/guestbook.php on line 9

访问add.php
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/server/apache2/htdocs/test/89/add.php on line 5