editweshop " .date('Y-m-d H:i:s')."\r\n"); // fclose($fp); $idpath= sprintf("%07d",$_SESSION['login_memid']) ; $wwwpath='/www2/skybni'; $picpath= "/shop/img/wp_".$idpath.'_'.$_POST['windex']; $wimg="wp_".$idpath.'_'.$_POST['windex']; $tfile="fileToUpload1"; $wimgext=$_POST['wimgext']; 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); } if($_POST['wid']==0){ $updateSQL = sprintf("INSERT INTO webshop (wtitle,wlink,wimg,wimgext,windex,wflag,coid)VALUES (%s,%s,%s,%s,%s,%s,%s)", GetSQLValueString($_POST['wtitle'], "text"), GetSQLValueString($_POST['wlink'], "text"), GetSQLValueString($wimg, "text"), // GetSQLValueString($_POST['coid'], "int"), GetSQLValueString($wimgext, "text"), GetSQLValueString($_POST['windex'], "int"), GetSQLValueString($_POST['wflag'], "int"), GetSQLValueString($_SESSION['login_coid'], "int")); //$_SESSION['login_memid'] } else{ $updateSQL = sprintf("UPDATE webshop SET wtitle=%s,wlink=%s,wimgext=%s,wflag=%s WHERE wid=%s AND coid=%s", GetSQLValueString($_POST['wtitle'], "text"), GetSQLValueString($_POST['wlink'], "text"), GetSQLValueString($wimgext, "text"), GetSQLValueString($_POST['wflag'], "int"), GetSQLValueString($_POST['wid'], "int"), GetSQLValueString($_SESSION['login_coid'], "int")); //$_SESSION['login_memid'] } // fwrite($fp,"updateSQL => " .$updateSQL."\r\n"); // fclose($fp); mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); $msg='更新完成....' ; $updateGoTo = "webshop.html"; echo ""; } //update `member` set company_title=mem_name WHERE mem_auto>10 and mem_auto<26 $id=-1; $id= (isset($_GET["id"]))?$_GET["id"]:-1; $canedit=false; $arr1=array(); // 1,2,5 fail3,4,6,7,8,9 mysql_select_db($database_BE2, $BE2); $query_Rt1 = "SELECT * FROM webshop WHERE coid= 1 order by windex" ; // $query_Rt3 = sprintf("SELECT * FROM webshop WHERE wid= '%s' ",$id); $Rt1 = mysql_query($query_Rt1, $BE2) or die(mysql_error()); $row_Rt1 = mysql_fetch_assoc($Rt1); $totalRows_Rt1 = mysql_num_rows($Rt1); $i=0; do { if($row_Rt1['wuse']=='Y'){ $arr1[$i]=$row_Rt1['windex']; $i++; } } while ($row_Rt1 = mysql_fetch_assoc($Rt1)); mysql_free_result($Rt1); if (in_array($id, $arr1)){ $canedit=true;} if ($id==0){ $canedit=true;} //if (($id>3) && ($id<10)){ $canedit=true;} mysql_select_db($database_BE2, $BE2); $query_Rt3 = sprintf("SELECT * FROM webshop WHERE coid= '%s' AND windex='%s' " ,$_SESSION['login_coid'],$id); // $query_Rt3 = sprintf("SELECT * FROM webshop WHERE wid= '%s' ",$id); $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); ?>

網店資料管理-廣告圖

標題:

" size="40" maxlength="60" /> " /> " />

連結:

啟用:

啟用 /> 不啟用/>

圖檔:

圖檔 Size 350 x 350 dpi

" alt="" />

網店管理

網店資料管理-廣告圖