PHP中的update 没有错 但修改不成功

来源:百度知道 编辑:UC知道 时间:2024/06/04 02:10:17
if($action=="replay"){//________进行修改
$ID=$_GET["ID"];

$name=$_POST["name"];
$sex=$_POST["sex"];
$age=$_POST["age"];
$tel=$_POST["tel"];
$email=$_POST["email"];
$text=$_POST["text"];

//mysql_query("update student set name='$name',sex='$sex',age='$age',tel='$tel',email='$email',text='$text' where id=$ID");
$sql="update student set name='$name',sex='$sex',age='$age',tel='$tel',email='$email',text='$text' where id='$ID'";
$query = mysql_query($sql);

header("location: ".$HTTP_REFERER);
}

$sql="update student set name='$name',sex='$sex',age='$age',tel='$tel',email='$email',text='$text' where id='$ID'";
------------------------------------------------------------------
改成:
$sql="update student set name='" .$name. "',sex='" .$sex. "',age='" .$age. "',tel='" .$tel. "',email='" .$email. "',text='" .$text. "' where id=" . $ID;