作者ta24 (皮)
看板PHP
标题[请益] 新手发问...
时间Thu Mar 15 12:02:44 2007
<!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>
<form id="form1" name="form1" method="post" action="tt.php">
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="214"><input name="date" type="text" id="date" /></td>
<td width="550"><select name="class" id="class">
<option value="测试一">测试一</option>
<option value="测试二">测试二</option>
</select>
</td>
</tr>
<tr>
<td><input name="id" type="text" id="id" /></td>
<td> </td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="送出"/></td>
<td> </td>
</tr>
</table>
</form>
<font size=3> <b> 结果显示 </b> </font> <hr>
<?php
$ydate=$_POST["date"];
$yid=$_POST["id"];
$yclass=$_POST["class"];
$host="localhost";
$user="root";
$pass="password";
$database="student";
$link=mysql_connect($host,$user,$pass);
$db=mysql_select_db($database,$link);
if($yid == "100001")
{
$select_str="UPDATE class_01 Set 100001='$yclass' where date='$ydate'";
}else if($yid == "100002")
{
$select_str="UPDATE class_01 Set 100002='$yclass' where date='$ydate'";
}else if($yid == "100003")
{
$select_str="UPDATE class_01 Set 100003='$yclass' where date='$ydate'";
}else{
echo "无法新增<br>";
}
?>
</body>
</html>
--------------抱歉写的很长------------
我试了好久, 都不知道为什麽不能update资料库中的资料.....
请问我哪里写错了吗?
资料库中有date, 100001, 100002, 100003三个栏位.
目标是在输入date和号码(100001, 100002 or 100003)及class之後
能修改某个date之下, 某个栏位的值.
谢谢~~
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.112.32.231
1F：→ readper:只能说完全没有POST的概念 也对PHP变数应用不了解 03/15 12:21
2F：→ readper:少了个query动作吧 03/15 12:22