PHPYanxi-Book
/
edit.php

<html>
<head>
<meta charset="utf-8">
<title>留言本</title>

<style>
table {font-size:12px;color:#333333;border-width: 1px;border-color: #729ea5;border-collapse: collapse;margin:20px auto;}
th {font-size:12px;background-color:#acc8cc;border-width: 1px;padding: 8px;border-style: solid;border-color: #729ea5;text-align:left;}
td {font-size:12px;border-width: 1px;padding: 8px;border-style: solid;border-color: #729ea5;}
</style>

</head>


<body>


<?php

$id = $_GET['id'];

$conn = mysql_connect("127.0.0.1","book","book_123");
if (!$conn){
    die("连接数据库失败：" . mysql_error());
}
mysql_select_db("book", $conn);
mysql_query("set names 'utf8'");


if($_REQUEST['a'] == 'editok'){

	//执行更新操作

	$name = $_POST['name'];
	$words = $_POST['words'];
	$id = $_POST['id'];

	$sql = "UPDATE word SET name = '$name' , words = '$words'  WHERE id = $id";

	//echo $sql;
	//exit();

	if(mysql_query($sql,$conn)){
    echo '编辑成功！<meta http-equiv="Refresh" content="1; url=index.php" />';
	} else {
		echo "更新数据失败：".mysql_error();
	}


}

else

	{

	//显示编辑内容

	$result = mysql_query("SELECT * FROM word WHERE id=".$id);

	$row = mysql_fetch_row($result);

	//print_r($row);

	}


?>


<br><br><br>

<center><h1>编辑留言</h1></center>


<center>

<form name="input" action="edit.php?a=editok" method="post">

<input type="hidden" name="id" value="<?php echo $id; ?>"/>

<input type="hidden" name="a" value="editok"/>

姓名：<input type="text" name="name" value="<?php echo $row['1']; ?>"/><br><br><br>

留言：<textarea rows="5" cols="22" name="words"><?php echo $row['2']; ?></textarea>

<br><br>

<input type="submit" value="提交" />


</form>


</center>


</body>

</html>