$_POST['company_title']){ mysql_select_db($database_BE2, $BE2); $query_Rtc = sprintf("SELECT * FROM company WHERE company_title = %s", GetSQLValueString($_POST['company_title'], "text")); $Rtc = mysql_query($query_Rtc, $BE2) or die(mysql_error()); $row_Rtc = mysql_fetch_assoc($Rtc); $totalRows_Rtc = mysql_num_rows($Rtc); if($totalRows_Rtc==0){ // make logo $_GET['shopname']=trim($_POST['company_title']) ; $_GET['shopid']=$_SESSION['login_memid'] ; //include('mk_webshop_logo.php'); }else{ $check_title=1; } mysql_free_result($Rtc); } if($check_title==0){ $idpath= $_SESSION['login_memid'] ; $wwwpath='/www2/skybni'; $picpath= "/shopmap/images/logo_".$idpath;; $tfile="fileToUpload1"; $wimgext=$_POST['company_pic']; if($_FILES[$tfile]["name"]<>''){ $ext= explode('.',$_FILES[$tfile]['name']) ; $imgext=strtolower($ext[count($ext)-1]); //取最後一筆 $pic=$wwwpath.$picpath.".".$imgext; $wimgext=$imgext; move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic); } //com_express com_express_ $updateSQL = sprintf("UPDATE company SET company_kind=%s, company_title=%s,company_pic=%s,com_express=%s,com_express_max=%s ,com_express_shop=%s ,com_express_local=%s,ext_shop=%s WHERE coid=%s", GetSQLValueString($_POST['company_kind'], "text"), GetSQLValueString($_POST['company_title'], "text"), GetSQLValueString($wimgext, "text"), GetSQLValueString($_POST['com_express'], "int"), GetSQLValueString($_POST['com_express_max'], "int"), GetSQLValueString($_POST['com_express_shop'], "int"), GetSQLValueString($_POST['com_express_local'], "text"), GetSQLValueString($_POST['ext_shop'], "text"), GetSQLValueString($_POST['coid'], "int")); //$_SESSION['login_memid'] mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); $msg='更新完成....' ; }else{ $msg='公司名稱重複....' ; } $updateGoTo = "webshop.html"; echo ''; } mysql_select_db($database_BE2, $BE2); $query_Rt2 = sprintf("SELECT * FROM company WHERE mid = %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); $company_coid=$row_Rt2['coid']; mysql_select_db($database_BE2, $BE2); $q_up1 = sprintf("UPDATE member set coid='%s' WHERE coid = 0 AND mem_auto='%s' ", $company_coid, $_SESSION['login_memid']); mysql_query($q_up1, $BE2) or die(mysql_error()); //echo $q_up1; //$query_Rot2 = "SELECT * FROM company_kinds order by kid"; //$Rot2 = mysql_query($query_Rot2, $BE2) or die(mysql_error()); //$row_Rot2 = mysql_fetch_assoc($Rot2); //$totalRows_Rot2 = mysql_num_rows($Rot2); mysql_select_db($database_BE2, $BE2); // address_id county district street $query_Rot2 = "SELECT * FROM company_kinds order by kid"; $Rot2 = mysql_query($query_Rot2, $BE2) or die(mysql_error()); $row_Rot2 = mysql_fetch_assoc($Rot2); $totalRows_Rot2 = mysql_num_rows($Rot2); mysql_select_db($database_BE2, $BE2); $query_Rt3 = sprintf("SELECT * FROM webshop WHERE coid= 1 OR coid='%s' order by coid,windex",$_SESSION['login_memid']) ; $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); $arr1=array(); $i=0; do { if($row_Rt3['coid']>1){ $i=$row_Rt3['windex']-1;} $arr1[$i][0]=$row_Rt3['wid']; $arr1[$i][1]=$row_Rt3['coid']; $arr1[$i][2]=$row_Rt3['wtitle']; $arr1[$i][3]=$row_Rt3['wimg'].'.'.$row_Rt3['wimgext']; $arr1[$i][4]=$row_Rt3['wlink']; $arr1[$i][5]=$row_Rt3['wuse']; // can edit upload $arr1[$i][6]=$row_Rt3['wflag']; // can edit upload $i++; } while ($row_Rt3 = mysql_fetch_assoc($Rt3)); mysql_select_db($database_BE2, $BE2); $query_Rtra = "SELECT * FROM travel where tbc='旅遊網' AND tb3='Y' order by tbindex" ; $Rtra = mysql_query($query_Rtra, $BE2) or die(mysql_error()); $row_Rtra = mysql_fetch_assoc($Rtra); $totalRows_Rtra = mysql_num_rows($Rtra); ?>