bluesky000
注册会员
UID 117119
精华
0
积分 51
帖子 27
金钱 51 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2008-3-31
状态 离线
|
[广告]: Enom域名自助付费 自助注册 自助PUSH 主流域名COM等一律57.99元年
紧急求助！！editpage传值问题
小弟写了一段代码，del语句简单可以成功，但是update的时候值死活传不进数据库。
edit page:
<?php
extract($_GET, EXTR_SKIP);
extract($_POST, EXTR_SKIP);
$sql = "SELECT * FROM `Handler_Lot`.`testtime` WHERE T_ID = '$id' ";
$conn = mysql_connect("localhost","root","asd!@#") or die('Database connection Error!');
mysql_query("set names 'utf8'");
mysql_select_db("Handler_Lot",$conn) or die('Database Select Error!');
$result = mysql_query($sql) or die('Database Query Error!');
$row = mysql_fetch_row($result);
?>
<form action="edited.php" method="post">
<p><font size=3>VARIETY:</font>:
<input name="variety" id="variety" type="text" value="<?php echo $row[1]; ?>"></p>
<p><font size=3>STAGE:</font>:
<input name="stage" id="stage" type="text" value="<?php echo $row[2]; ?>"></p>
<p><font size=3>TESTER:</font>:
<input name="tester" id="tester" type="text" value="<?php echo $row[3]; ?>"></p>
<p><font size=3>PT1:</font>
<input name="pt1" id="pt1" type="text" value="<?php echo $row[4]; ?>"></p>
<p><font size=3>TDBI:</font>
<input name="tdbi" id="tdbi" type="text" value="<?php echo $row[5]; ?>"></p>
<p><font size=3>FT1:</font>
<input name="ft1" id="ft1" type="text" value="<?php echo $row[6]; ?>"></p>
<p><font size=3>FT2:</font>
<input name="ft2" id="ft2" type="text" value="<?php echo $row[7]; ?>"></p>
<p><font size=3>FT-OUT:</font>
<input name="ft_out" id="ft_out" type="text" value="<?php echo $row[8]; ?>"></p>
<p><font size=3>TEST PROGRAM:</font>
<input name="test_program" id="test_program" type="text" value="<?php echo $row[9]; ?>"></p>
<p><font size=3>VERSION:</font>
<input name="version" id="version" type="text" value="<?php echo $row[10]; ?>"></p>
<p><font size=3>PREVIOUS VERSION:</font>
<input name="previous_version" id="previous_version" type="text" value="<?php echo $row[11]; ?>"></p>
<p><font size=3>PREVIOUS CYCLE TIME:</font>
<input name="previous_cycle_time" id="previous_cycle_time" type="text" value="<?php echo $row[12]; ?>"></p>
<p><font size=3>PREVIOUS CALCULATED UPH:</font>
<input name="previous_calculated_uph" id="previous_calculated_uph" type="text" value="<?php echo $row[13]; ?>"></p>
<p><font size=3>RELEASE DATE:</font>
<input name="release_date" id="release_date" type="text" value="<?php echo $row[14]; ?>"></p>
<p><input name="submit1" type="submit" value="Insert"><input name="submit2" type="reset" value="Reset"></p>
</form>
edited.php:
<?php
extract($_GET, EXTR_SKIP);
extract($_POST, EXTR_SKIP);
$sql = "UPDATE `Handler_Lot`.`testtime` SET `Variety` = '$Variety',`Stage` = '$Stage',`Tester` = '$Tester',
`PT1` = '$Pt1',`TDBI` = '$Tdbi',
`FT1` = '$Ft1',`FT2` = '$Ft2',`FT-OUT` = '$Ftout',`Test Program` = '$Testprogram',`Version` = '$Version',
`previous Version` = '$PreviousVersion',`previous Cycle Time (Sec)` = '$PreviousCycleTime',
`previous Calculated UPH` = '$PreviousCalculatedUph',`Release Date` = '$ReleaseDate' WHERE `testtime`.`T_ID` ='$id';";
$conn = mysql_connect("localhost","root","asd!@#") or die('Database connection Error!');
mysql_query("set names 'utf8'");
mysql_select_db("Handler_Lot",$conn) or die('Database Select Error!');
$result = mysql_query($sql) or die('Database Query Error!');
if($result)
{
echo "hi，Successed！<p>";
}
mysql_close($conn);
?>
[<a href="home.php">SHOW</a>]
[ 本帖最后由 bluesky000 于 2008-4-15 01:26 PM 编辑 ]
|
|
