Transcript 下載/瀏覽Download

•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
更新紀錄
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if($_POST["new_passwd"]!="")
{
$passwd=md5($_POST["new_passwd"]);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE memberdata SET m_name=%s, m_nick=%s,
m_passwd=%s, m_sex=%s, m_birthday=%s, m_email=%s, m_url=%s, m_phone=%s,
m_cellphone=%s, m_address=%s WHERE m_id=%s",
GetSQLValueString($_POST['m_name'], "text"),
GetSQLValueString($_POST['m_nick'], "text"),
GetSQLValueString($passwd, "text"),
GetSQLValueString($_POST['m_sex'], "text"),
GetSQLValueString($_POST['m_birthday'], "date"),
GetSQLValueString($_POST['m_email'], "text"),
GetSQLValueString($_POST['m_url'], "text"),
GetSQLValueString($_POST['m_phone'], "text"),
GetSQLValueString($_POST['m_cellphone'], "text"),
GetSQLValueString($_POST['m_address'], "text"),
GetSQLValueString($_POST['m_id'], "int"));
mysql_select_db($database_stephanie, $stephanie);
$Result1 = mysql_query($updateSQL, $stephanie) or die(mysql_error());
$updateGoTo = "memberzone.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
資料查詢
$colname_Recordset1 = "-1";
if (isset($_SESSION['MM_Username'])) {
$colname_Recordset1 = $_SESSION['MM_Username'];
}
mysql_select_db($database_stephanie, $stephanie);
$query_Recordset1 = sprintf("SELECT * FROM memberdata WHERE m_username =
%s", GetSQLValueString($colname_Recordset1, "text"));
$Recordset1 = mysql_query($query_Recordset1, $stephanie) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>