<?phpsession_start ();?>StatusEmailFaxStatus
Fax
Tele.num
require_once('config.php');
$conn=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$conn) {
die('Failed to connect to server: ' . mysql_error());
}
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}
$id=$_SESSION['SESS_ID'];
if($_POST['bthModify']){
$status=trim($_POST['status']);
$em=trim($_POST['email']);
$faxx=$_POST['fax'] as int;
$telenum=$_POST['telenum'] as int;
$sql1="UPDATE user SET status='$status', email='$em',fax='$faxx',tele.num='$telenum' where iduser='$id'";
$result=mysql_query($sql1);
if($result){
echo "modify success";}
else{ echo "Modify fail, Please make sure your information are right.";
}
}
?>
各种存不进 已经更新失败问题出在fax='$faxx',tele.num='$telenum' 因为数据库里这两列是整数型 可后来我把数据库里这两列改成var型仍然失败 只有把这两个值写到其他列才能成功 求解
展开