alert('".$write."');"; } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $idpath= sprintf("%07d",$_SESSION['login_coid']) ; $wwwpath='/www2/skybni'; $picpath= "/admin/upload2_image/".$idpath; if ( !file_exists( $wwwpath.$picpath ) && !is_dir( $wwwpath.$picpath ) ) { mkdir( $wwwpath.$picpath ); } $write=''; $img=date('YmdHis').'_'.sprintf("%04d",rand(1,9999)); $imgext=''; //p_tag $tfile="fileToUpload1"; if($_FILES[$tfile]["name"]<>''){ $ext= explode('.',$_FILES[$tfile]['name']) ; $imgext=strtolower($ext[count($ext)-1]); //取最後一筆 $pic=$wwwpath.$picpath.'/'.$img.".".$imgext; move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic); } // test double data mysql_select_db($database_BE2, $BE2); $query_Rt3 = sprintf("SELECT * FROM product_data WHERE meta_img='%s' AND company_num = '%s'",$img,$_SESSION['login_coid']); $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); mysql_free_result($Rt3); if($totalRows_Rt3==0){ // p_rank //$_SESSION['login_memid'] p_percent31 // 1 2 $updateSQL = sprintf("insert into product_data (mem_time,company_num,p_check,p_check_time,p_check_time2,p_hot,p_hot2,pic_num,p_tag,meta_img,p_title,p_explan,p_content,p_size,p_new,p_money,p_num,p_express,p_count,p_percent31,p_percent32,p_percent33,p_percent34,p_percent35,p_percent36)VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s' ,'%s','%s' ,'%s')",date('Y-m-d'),$_SESSION['login_coid'],$_POST['p_check'],$_POST['p_check_time'],$_POST['p_check_time2'],$_POST['p_hot'],$_POST['p_hot2'],$_POST['pic_num'],$imgext,$img,$_POST['p_title'],$_POST['p_explan'],$_POST['p_content'],$_POST['p_size'],'1',$_POST['p_money'] ,$_POST['p_num'] ,$_POST['p_express'],$_POST['p_count'],$_POST['p_percent31'],$_POST['p_percent32'],$_POST['p_percent33'],$_POST['p_percent34'],$_POST['p_percent35'],$_POST['p_percent36']); mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); // // test double data mysql_select_db($database_BE2, $BE2); $query_Rt3 = sprintf("SELECT * FROM product_data WHERE meta_img='%s' AND company_num = '%s'",$img,$_SESSION['login_coid']); $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); $pid=$row_Rt3['mem_auto']; mysql_free_result($Rt3); for($i=0;$ialert('".$write."');location.href='". $insertGoTo."';"; } } $currentPage = "productadd.html";//$_SERVER["PHP_SELF"]; mysql_select_db($database_BE2, $BE2); //$query_Rtg = sprintf("SELECT a.* FROM member_data as a, member as b WHERE a.mid=b.mem_auto AND b.mem_mobile = '%s'",$_SESSION['login_memid']); $query_Rtg = sprintf("SELECT * FROM product_kind WHERE company_num = '%s'",$_SESSION['login_coid']); $Rtg = mysql_query($query_Rtg, $BE2) or die(mysql_error()); $row_Rtg = mysql_fetch_assoc($Rtg); $totalRows_Rtg = mysql_num_rows($Rtg); $mid=0; //if ($totalRows_Rtg>0) { $mid=$row_Rtg['mid']; } ?>