刚学php,写了一个简单的留言本,但是一直实现不了删除功能,见了一个表 共四个字段:ID title, author,content, 下边是我写的删除功能,请各位帮忙看一下问题出在那里,运行时
提示:mysql_fetch_object(): supplied argument is not a valid MySQL result resource in ...dete.php<?php
$user_id = $_POST['id'];
$user_title = $_POST['title'];
$user_author = $_POST['author'];
$user_content = $_POST['content'];
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book';
$link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db("$dbname");
$sql="delete from gusetbook0 where id=".$_GET['id'];
mysql_query($sql);
mysql_close();
header("location:shanchu.php");
?>shanchu.php<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book';
$link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db($dbname);
$sql="select * from guestbook0";
$result=mysql_query($sql);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>ID:".$rs->id."</td></tr>";
echo "<table><tr><td>标题:".$rs->title."</td></tr>";
echo "<table><tr><td>作者:".$rs->author."</td></tr>";
echo "<tr><td>内容:".$rs->content."</td></tr></table><br/>";
echo "<a href=dete.php?id=".$rs->id." >删除</a>";
}mysql_close();
?>
提示:mysql_fetch_object(): supplied argument is not a valid MySQL result resource in ...dete.php<?php
$user_id = $_POST['id'];
$user_title = $_POST['title'];
$user_author = $_POST['author'];
$user_content = $_POST['content'];
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book';
$link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db("$dbname");
$sql="delete from gusetbook0 where id=".$_GET['id'];
mysql_query($sql);
mysql_close();
header("location:shanchu.php");
?>shanchu.php<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book';
$link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db($dbname);
$sql="select * from guestbook0";
$result=mysql_query($sql);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>ID:".$rs->id."</td></tr>";
echo "<table><tr><td>标题:".$rs->title."</td></tr>";
echo "<table><tr><td>作者:".$rs->author."</td></tr>";
echo "<tr><td>内容:".$rs->content."</td></tr></table><br/>";
echo "<a href=dete.php?id=".$rs->id." >删除</a>";
}mysql_close();
?>
$user_title = $_POST['title'];
$user_author = $_POST['author'];
$user_content = $_POST['content']; 这些是多余的~
错误信息,是mysql没有执行结果,把sql语句弄出去看看,然后放在数据库里执行一下看看
shanchu.php
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book'; $link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db($dbname);$sql="select * from guestbook0"; //设置查询语句
$result=mysql_query($sql); //发送一条select查询,并返回查询结果while($rs=mysql_fetch_object($result))
{
echo"<table><tr><td><a href=dete.php?id=".$rs->id.">删除</a></td></tr>";
echo"<tr><td>标题:".$rs->title."</td></tr>";
echo"<tr><td>作者:".$rs->author."</td></tr>";
echo"<tr><td>内容:".$rs->content."</td></tr></table><br/>";
echo"------------------------------------------<br/>";
}
mysql_close();
?>dete.php
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book'; $link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db("$dbname");$sql="delete from gusetbook0 where id=".$_GET['id'];
mysql_query($sql);mysql_close();
header("location:shanchu.php");?>
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book'; $link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db($dbname);$sql="select * from guestbook0"; //设置查询语句
$result=mysql_query($sql); //发送一条select查询,并返回查询结果while($rs=mysql_fetch_object($result))
{
echo"<table><tr><td><a href=dete.php?id=".$rs->id.">删除</a></td></tr>";
echo"<tr><td>标题:".$rs->title."</td></tr>";
echo"<tr><td>作者:".$rs->author."</td></tr>";
echo"<tr><td>内容:".$rs->content."</td></tr></table><br/>";
echo"------------------------------------------<br/>";
}
mysql_close();
?>dete.php
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw = '';
$dbname = 'guest_book'; $link=mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db("$dbname");$sql="delete from guestbook0 where id=".$_GET['id'];
mysql_query($sql);mysql_close();
header("location:shanchu.php");?>
ok了
$sql="select * from guestbook0";guestbook0
gusetbook0<>guestbook0
mysql_select_db("$dbname") or die(mysql_error());
<table width="500" border="1">
<tr>
<td>ID</td>
<td>标题</td>
<td>作者</td>
<td>内容</td>
<td>操作</td>
</tr>
<?php
@mysql_connect("localhost","root","")
or die("Could not connect to MySQL server!");
mysql_select_db("guest_book")or die("Can't select database!");$sql = "select * from guestbook0";
$result = mysql_query($sql);while(list($id,$title,$author,$content)=mysql_fetch_row($result)){
echo"
<tr>
<td>$id</td>
<td>$title</td>
<td>$author</td>
<td>$content</td>
<td><a href=\"dete.php?id=$id\">删除</a></td>
</tr>
";
}
mysql_close();
?>
</table>dete.jsp<?php
@mysql_connect("localhost","root","")
or die("Could not connect to MySQL server!");
mysql_select_db("guest_book")or die("Can't select database!");
if(isset($_GET["id"])){
$id = $_GET["id"];
$sql="delete from guestbook0 where id=$id";
mysql_query($sql);
mysql_close();
}
header("location:shanchu.php");
?> 主要问题是你建的表名问题 在shanchu.jsp里表名是guestbook0,在dete.jsp里是gusetbook0,
根本一样啊(es/se)都是小问题 仔细一点就不会出错了:)