留言本的制作今天加了修改和删除功能

留言本的制作今天加了修改和删除功能
代码贴出来了

index.php 改为以下的样子
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>留言本制作</title>
</head>

<body>
<a href="post.htm">添加</a>
<?
$conn=mysql_connect ("localhost", "root", "123456"); //打开MySQL服务器连接
mysql_select_db("guest_book"); //链接数据库
mysql_query("set names utf-8"); //解决中文乱码问题
$exec="select * from contents"; //sql语句
$result=mysql_query($exec); //执行sql语句，返回结果
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";
echo "<tr><td>留言:".$rs->content."</td></tr>";
echo "<tr><td><a href=edit.php?id=".$rs->id.">修改</a>&nbsp;".$rs->id."&nbsp;<a href=del.php?id=".$rs->id.">删除</a></td></tr></table><br/>";
}?>
</body>
</html>
=====================================
下面是edit.php页面
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>edit</title>
</head>

<body>

<?php //读取该id的内容
$conn=mysql_connect ("localhost", "root", "123456"); //打开MySQL服务器连接
mysql_select_db("guest_book"); //链接数据库
mysql_query("set names utf-8"); //解决中文乱码问题
$exec="select * from contents where id=$id"; //sql语句
$result=mysql_query($exec); //执行sql语句，返回结果
$rs=mysql_fetch_object($result);
?>
<form action="edit2.php" method="post" name="name1">
    <table><input type="hidden" name="id" value="<?php echo $rs->id ?>"/>
        <tr><td>姓名:<input type="text" name="user_name" value="<?php echo $rs->name ?>"></td></tr>
        <tr><td>留言:<input type="text" name="post_contents" value="<?php echo $rs->content ?>"></td></tr>
        <tr>
          <td><input type="submit" value="修改"></td></tr>
    </table>
</form>
</body>
</html>
==============================
edit2.php用于提交修改
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php //读取该id的内容
$conn=mysql_connect ("localhost", "root", "123456"); //打开MySQL服务器连接
mysql_select_db("guest_book"); //链接数据库
mysql_query("set names utf-8"); //解决中文乱码问题
 $exec="select * from contents where id=".$_GET['id'];
 $exec="update contents set name='".$_POST['user_name']."',content='".$_POST['post_contents']."' where id=".$_POST['id'];
 
  // $exec="update contents (name,content) values ('".$_POST['user_name']."','".$_POST['post_contents']."') where id=".$_POST['id'];
   $result=mysql_query($exec);
echo $exec;
//header("location:index.php");
?>
<script language="javascript">
alert("操作成功！")
location.href="index.php"
</script> 
</body>
</html>

===================================
del.php 用于删除了
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>删除</title>
</head>

<body>
<?php //读取该id的内容
$conn=mysql_connect ("localhost", "root", "123456"); //打开MySQL服务器连接
mysql_select_db("guest_book"); //链接数据库
 $exec="delete from contents where id=".$_GET['id'];
   $result=mysql_query($exec);
?>
<script language="javascript">
alert("操作成功！")
location.href="index.php"
</script> 
</body>
</html>
===================================

今天遇到一个问题不知道怎么回事 别人返回都是用的header("location:index.php");
可我用不了 不知道怎么回事， 只好用JAVASCRIPT来做了 呵，明天再好好看一看

转自：http://www.phpxuexi.com/PHPrumen/liuyanbenzhizuo/200905/1126.html //很简结，明了。

posted @ 2012-11-06 11:23  stma  阅读(161)  评论(0)    收藏  举报