''){
$ext= explode('.',$_FILES[$tfile1]['name']) ;
$imgext=strtolower($ext[count($ext)-1]); //取最後一筆
if($imgext=='jpg'){
$m_pic1="1".rand(100,999);
$pic=$wwwpath.$picpath.'_'.$m_pic1.'.jpg';
//$m_pic1=$imgext;
move_uploaded_file($_FILES[$tfile1]["tmp_name"],$pic);
}
}
$tfile2="fileToUpload2";
if($_FILES[$tfile2]["name"]<>''){
$ext= explode('.',$_FILES[$tfile2]['name']) ;
$imgext=strtolower($ext[count($ext)-1]); //取最後一筆'
if($imgext=='jpg'){
$m_pic2="2".rand(100,999);
$pic=$wwwpath.$picpath.'_'.$m_pic2.'.jpg';
move_uploaded_file($_FILES[$tfile2]["tmp_name"],$pic);
}
}
$tfile4="fileToUpload4";
if($_FILES[$tfile4]["name"]<>''){
$ext= explode('.',$_FILES[$tfile4]['name']) ;
$imgext=strtolower($ext[count($ext)-1]); //取最後一筆
if($imgext=='jpg'){
$m_pic4="4".rand(100,999);
$pic=$wwwpath.$picpath.'_'.$m_pic4.'.jpg';
//$m_pic4=$imgext;
move_uploaded_file($_FILES[$tfile4]["tmp_name"],$pic);
}
}
/*
$tfile="fileToUpload1";
$mem_logo=$_POST['mem_logo'];
if($_FILES[$tfile]["name"]<>''){
$ext= explode('.',$_FILES[$tfile]['name']) ;
$imgext=strtolower($ext[count($ext)-1]); //取最後一筆
$pic=$wwwpath.$picpath.".".$imgext;
$mem_logo=$imgext;
move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic);
}
*///SELECT a.*,b.scode as bscode,b.mem_name as pname FROM member as a left join member as b on a.mem_num=b.mem_auto WHERE a.mem_auto = 262
$updateSQL = sprintf("UPDATE member SET m_bankcode=%s, m_bankname=%s,m_bank=%s,m_bank2=%s,
m_pic1=%s, m_pic2=%s, m_pic4=%s WHERE mem_auto=%s",
GetSQLValueString($_POST['m_bankcode'], "text"),
GetSQLValueString($_POST['m_bankname'], "text"),
GetSQLValueString($_POST['m_bank'], "text"),
GetSQLValueString($_POST['m_bank2'], "text"),
GetSQLValueString($m_pic1, "text"),
GetSQLValueString($m_pic2, "text"),
GetSQLValueString($m_pic4, "text"),
GetSQLValueString($_SESSION['login_memid'], "int"));
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error());
$msg='更新完成....' ;
$updateGoTo = "editprofile.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 a.*,b.scode as bscode,b.mem_name as pname FROM member as a left join member as b on a.mem_num=b.mem_auto WHERE a.mem_auto = %s", 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);
mysql_select_db($database_BE2, $BE2);
$query_Rt3 = "SELECT * FROM creditcard order by pp1" ;
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
//creditcard
// echo $query_Rt2;
?>