UC知道php与mysql留言板问题 能提交但不能修改删除 不知哪错了
来源：百度知道 编辑：UC知道 时间：2024/06/05 09:30:35
<?php
@mysql_connect("localhost", "root") @mysql_select_db("mydb") ");
mysql_query("SET NAMES 'GBK'");
$query = mysql_query("select * from mytable ");
$row = mysql_fetch_array($query); ?>
<form method="post" name="form1" action="update_do.php?serial_no=<?php echo $serial_no?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">员工号:</td>
<td><input type="text" name="serial_no" value="<?php echo $row['serial_no']?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">姓名:</td>
<td><input type="text" name="name" value="<?php
@mysql_connect("localhost", "root") @mysql_select_db("mydb") ");
mysql_query("SET NAMES 'GBK'");
$query = mysql_query("select * from mytable ");
$row = mysql_fetch_array($query); ?>
<form method="post" name="form1" action="update_do.php?serial_no=<?php echo $serial_no?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">员工号:</td>
<td><input type="text" name="serial_no" value="<?php echo $row['serial_no']?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">姓名:</td>
<td><input type="text" name="name" value="<?php
$query = mysql_query("update mytable set serial_no = $serial_no, "
."name = '$name', age = $age, birthday = '$birthday', "
."salary = $salary, bonus = $bonus ");
$sql = "DELETE FROM mytable ";
均未指明要修改或删除的ID，建议你在数据表中设置一字段为ID，为自增，删除或修改的条件就是where id=$id
delete
语句应该给个条件吧
如
where `id`='$id'之类的
$sql = "DELETE FROM mytable ";
错..