''){
$ext= explode('.',$_FILES[$tfile]['name']) ;
$imgext=strtolower($ext[count($ext)-1]); //取最後一筆
$pic=$wwwpath.$picpath.".".$imgext;
$mem_logo2=$imgext;
move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic);
}
$updateSQL = sprintf("UPDATE member SET mem_logo2_ck=%s, mem_search=%s, font_color=%s, mem_logo2=%s WHERE mem_auto=%s",
GetSQLValueString($_POST['mem_logo2_ck'], "text"),
GetSQLValueString($_POST['mem_search'], "text"),
GetSQLValueString($_POST['font_color'], "text"),
GetSQLValueString($mem_logo2, "text"),
GetSQLValueString($_SESSION['login_memid'], "int"));
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error());
$msg='更新完成....' ;
$updateGoTo = "editecarddemo.html";
// $updateSQL = sprintf("UPDATE member SET mem_logo2_ck=%s, ck_search=%s, font_color=%s, mem_logo2=%s, company_name=%s, company_title=%s,mem_logo=%s WHERE mem_auto=%s",
echo '';
} else if($_POST["MM_update"] == "fp2"){
$updateSQL2 = sprintf("UPDATE member SET mem_title=%s,mem_user=%s,mem_user2=%s,mem_name_en=%s ,mem_mobile2=%s,mem_line=%s,mem_google=%s,mem_mail=%s WHERE mem_auto=%s",
GetSQLValueString($_POST['mem_title'], "text"),
GetSQLValueString($_POST['mem_user'], "text"),
GetSQLValueString($_POST['mem_user2'], "text"),
GetSQLValueString($_POST['mem_name_en'], "text"),
GetSQLValueString($_POST['mem_mobile2'], "text"),
GetSQLValueString($_POST['mem_line'], "text"),
GetSQLValueString($_POST['mem_google'], "text"),
GetSQLValueString($_POST['mem_mail'], "text"),
GetSQLValueString($_SESSION['login_memid'], "int"));
/*
nameS_ckS in /www2/skybni/guest/body_editecardfile.php on line 153
Notice: Undefined index: mem_name_ck in /www2/skybni/guest/body_editecardfile.php on line 155
Notice: Undefined index: mem_name_en_ck in /www2/skybni/guest/body_editecardfile.php on line 157
*/
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($updateSQL2, $BE2) or die(mysql_error());
$msg='更新完成....' ;
$updateGoTo = "editecardfile.html";
echo '';
}
}
//update `member` set company_title=mem_name WHERE mem_auto>10 and mem_auto<26
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT * FROM mem_addemo WHERE mid = %s order by adindex", GetSQLValueString($_SESSION['login_memid'], "int"));
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
if($totalRows_Rt2==0){
mysql_free_result($Rt2);
for($c=1;$c<9;$c++){
mysql_select_db($database_BE2, $BE2);
$INS_Rt2 = sprintf("INSERT INTO mem_addemo(mid,adindex)VALUES(%s,%s)",$_SESSION['login_memid'],$c);
mysql_query($INS_Rt2, $BE2) or die(mysql_error());
}
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT * FROM mem_addemo WHERE mid = %s order by adindex", GetSQLValueString($_SESSION['login_memid'], "int"));
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
}
?>
廣告資料管理
| # |
序 |
說明 |
啟用 |
編輯 |
0){
$i=0;
do { $i++;?>
|
 |
|
|
編輯 |