''){ $ext= explode('.',$_FILES[$tfile]['name']) ; $imgext=strtolower($ext[count($ext)-1]); //取最後一筆 if(in_array($imgext,$img_ext_array)){ $spic=$wwwpath.$spicpath.".".$imgext; move_uploaded_file($_FILES[$tfile]["tmp_name"],$spic); $chk_file=true; while($chk_file) { if (file_exists($spic)){ $chk_file=false; } } //$pic=$wwwpath.$picpath.".".$imgext; $picn=$wwwpath.$spicpath.".png"; //$extension = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); switch ($imgext) { case 'jpg': case 'jpeg': $image = imagecreatefromjpeg($spic); break; case 'gif': $image = imagecreatefromgif($spic); break; case 'png': $image = imagecreatefrompng($spic); break; } imagepng($image, $picn); $chk_file=true; $c=time()+10; $ff=0; while($chk_file) { if (file_exists($picn)){ $ff=1; $chk_file=false; } $c1=time(); if($c1>$c){ $chk_file=false; } } if($ff>0){ $repic ='/www2/skybni/number_jpg/vip_'.$_POST['si10b'].".png"; $syscall_3b="/usr/local/bin/convert $picn -resize 100x100 -size 100x100 xc:white +swap -gravity center -composite $repic"; $output2=`$syscall_3b`; } } } $updateSQL = sprintf("UPDATE shop5 SET si5=%s, si6=%s,si6a=%s, si11=%s, si12=%s, si13=%s, si14=%s, sicf=%s, address_id=%s WHERE si1=%s", GetSQLValueString($_POST['si5'], "text"), GetSQLValueString($_POST['si6'], "text"), GetSQLValueString($_POST['si6a'], "text"), GetSQLValueString($_POST['si11'], "text"), GetSQLValueString($_POST['si12'], "text"), GetSQLValueString($_POST['si13'], "text"), GetSQLValueString($_POST['si14'], "text"), GetSQLValueString($_POST['sicf'], "text"), GetSQLValueString($_POST['address_id'], "int"), GetSQLValueString($_POST['si1'], "int")); mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); $write='資料已更新...'; // $updateGoTo = $_POST["url"]; // echo $upSQL; // header(sprintf("Location: %s", $updateGoTo)); echo ""; } if( $_SESSION['login_memid']<1){ exit;} $colname_Rt2 = $_SESSION['login_memid']; //-1 //$_SESSION['login_memid'] //$query_Rt2 = sprintf("SELECT * FROM company WHERE mid = %s", GetSQLValueString($_SESSION['login_memid'], "int")); ; $qr1 = sprintf("SELECT a.*,b.* FROM shop5 as a,address as b where a.si10c='%s' AND a.address_id =b.address_id",$_SESSION['login_memid']); mysql_select_db($database_BE2, $BE2); $query_Rt2 = $qr1; $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); $updateSQL = sprintf("INSERT INTO shop5 (si10,si10c,sicf,address_id)VALUES('0','%s','N','1')",$_SESSION['login_memid'] ); mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); mysql_select_db($database_BE2, $BE2); $query_Rt2 = $qr1; $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); // address_id county district street $query_Rot2 = "SELECT distinct(county) FROM address where 1 order by county"; $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_Rat2 = sprintf("SELECT distinct(district) FROM address where county='%s' order by district",$row_Rt2['county']); $Rat2 = mysql_query($query_Rat2, $BE2) or die(mysql_error()); $row_Rat2 = mysql_fetch_assoc($Rat2); $totalRows_Rat2 = mysql_num_rows($Rat2); $district=$row_Rt2['district']; mysql_select_db($database_BE2, $BE2); // address_id county district street $query_Rbt2 = sprintf("SELECT address_id,street FROM address where county='%s' AND district='%s' order by street",$row_Rt2['county'], $district); $Rbt2 = mysql_query($query_Rbt2, $BE2) or die(mysql_error()); $row_Rbt2 = mysql_fetch_assoc($Rbt2); $totalRows_Rbt2 = mysql_num_rows($Rbt2); ?>

街道網店商城

商店名稱(商家抬頭):

縣市：

區域:

鄉鎮:

巷弄:

巷

弄

號

樓

地址:

圖檔:

圖檔(jpg,png) : Size 100 x 100 px

啟用: