require("lib.php"); if(!(isset($ss_userid) && ($ss_userid > 0))){ header("Location: /login.php"); } $info = ""; $done = false; if($confirm){ $email = trim($email); $realname = trim($realname); $address = ereg_replace("\"",""",trim($address)); $city = trim($city); $province = trim($province); $country = trim($country); $zipcode = trim($zipcode); $company = trim($company); $telephone = trim($telephone); $telephone1 = trim($telephone1); $gender = trim($gender); $directoryid = trim($directoryid); $qry_string = "UPDATE user SET email='$email' WHERE userid=$ss_userid"; $result = $db_query($qry_string, $mySQL_ID) or mysql_die(); $qry_string = "UPDATE directory SET email='$email',realname='$realname',gender='$gender',telephone='$telephone',telephone1='$telephone1',country='$country',province='$province',city='$city',company='$company',address='$address',zipcode='$zipcode' WHERE userid=$ss_userid AND directoryid=$directoryid"; // echo $qry_string."\n"; $result = $db_query($qry_string, $mySQL_ID) or mysql_die(); $info = "您已成功修改注册信息!"; $done = true; }else{ $qry_string = "SELECT user.username,user.email,user.directoryid,directory.realname,directory.gender,directory.telephone,directory.telephone1,directory.country,directory.province,directory.city,directory.company,directory.address,directory.zipcode FROM user,directory WHERE user.userid=directory.userid AND user.directoryid=directory.directoryid AND user.userid=$ss_userid"; $result = $db_query($qry_string, $mySQL_ID) or mysql_die(); $row = $db_fetch_array($result); $username = $row["username"]; $email = $row["email"]; $realname = $row["realname"]; $address = ereg_replace("\"",""",$row["address"]); $city = $row["city"]; $province = $row["province"]; $country = $row["country"]; $zipcode = $row["zipcode"]; $company = $row["company"]; $telephone = $row["telephone"]; $telephone1 = $row["telephone1"]; $gender = $row["gender"]; $directoryid = $row["directoryid"]; } ?>
|
|
if(!$done){ ?> } else{ ?> } ?>
|