<html>
<head>
<title>查詢</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body>
<h2 align="center">查詢資料</h2>
<font color="red">請輸入欲查詢資料</font>
<form action="update.php" method="POST">
E_code:<input type="text" name="E_code">
<input type="submit" value="查詢">
</form>
<?php
$link=mysql_connect("localhost","root","");
mysql_select_db("Hospital");
mysql_query("set character set big5");
$str="select * from Employee where E_code='$E_code';";
$result=mysql_query($str);
$num=mysql_num_rows($result);
$E_code=$_POST['E_code'];
if(isset($E_code))
{
if($num==0)
{
echo "查詢不到你要修改的資料";
exit;
}else{
echo "你要修改的資料";
echo "
<hr>";
$link=mysql_connect("localhost","root","");
mysql_select_db("Hospital");
mysql_query("set character set big5");
$E_no=$_POST["E_no"];
$E_code=$_POST["E_code"];
$E_name=$_POST["E_name"];
$E_sex=$_POST["E_sex"];
$E_age=$_POST["E_age"];
$E_birthday=$_POST["E_birthday"];
$E_address=$_POST["E_address"];
$E_business=$_POST["E_business"];
$qrr="update Employee set E_no='$E_no',E_name='$E_name',E_sex='$E_sex',E_age='$E_age',E_birthday='$E_birthday',E_address='$E_address',E_business='$E_business' where E_code='$E_code');";
mysql_query($qrr);
$result=mysql_query("select * from Employee where E_code='$E_code'");
while(list($E_no,$E_code,$E_name,$E_sex,$E_age,$E_birthday,$E_address,$E_business)=mysql_fetch_row($result))
{
echo "<form action=update.php method=POST>";
echo "修改基本資料<p>";
echo "E_no:<input type=text name=E_no value=$E_no>
";
echo "E_name:<input type=text name=E_name value=$E_name>
";
echo "E_sex:<input type=text name=E_sex value=$E_sex>
";
echo "E_age:<input type=text name=E_age value=$E_age>
";
echo "E_birthday:<input type=text name=E_birthday value=$E_birthday>
";
echo "E_address:<input type=text name=E_address value=$E_address>
";
echo "E_business:<input type=text name=E_business value=$E_business>
";
echo "<p><input type=submit name=B1 value=更新>";
echo "<input type=reset name=B2 value=重新輸入></p>";
echo "</form>";
exit;
}
};
mysql_colse($link);
};
?>
</head>
</html>
我的程式碼是這樣~~但是遇到一個問題~~現在瀏覽的時候呀~~我只要一點查詢的地方~~就會自動把資料新增到資料庫~~但是我還沒有把資料新增也沒有按新增的按鈕@@|||~怎麼會這樣呀？?有誰可以幫我看看嗎？
作者
已記錄
