''){ $ext= explode('.',$_FILES[$tfile]['name']) ; $imgext=strtolower($ext[count($ext)-1]); //取最後一筆 $pic=$wwwpath.$picpath.'/'.$img.".".$imgext; move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic); } // p_rank $p_explan = strip_tags($_POST['p_explan']); $p_content = strip_tags($_POST['p_content']); $updateSQL = sprintf("update product_data set p_check='%s',p_check_time='%s',p_check_time2='%s',p_hot='%s',p_hot2='%s',pic_num='%s',p_tag='%s',meta_img='%s',p_title='%s',p_explan='%s',p_size='%s',p_money='%s',p_num='%s',p_express='%s',p_count='%s',p_percent31='%s',p_percent32='%s',p_percent33='%s' ,p_percent34='%s',p_percent35='%s',p_percent36='%s',p_percent37='%s',p_content='%s' WHERE company_num='%s' AND mem_auto='%s' ", $_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'],$p_explan,$_POST['p_size'],$_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'],$_POST['p_percent37'],$p_content,$_SESSION['login_coid'],$_POST['mem_auto'] ); mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); $img=$_POST['meta_img']; for($i=0;$i<8;$i++){ $up=0; $imgext=$_POST['imge'.$i]; //p_tag $tfile="fileToUploade".$i; if($_POST['pid'.$i]>0){ $up=1;} if($_FILES[$tfile]["name"]<>''){ $ext= explode('.',$_FILES[$tfile]['name']) ; $imgext=strtolower($ext[count($ext)-1]); //取最後一筆 $pic=$wwwpath.$picpath.'/'.$img.$i.".".$imgext; move_uploaded_file($_FILES[$tfile]["tmp_name"],$pic); $up=1; } if($up>0){ $fck=isset($_POST['fck'.$i])?$_POST['fck'.$i]:'N'; if($_POST['pid'.$i]==0){ $Indate = sprintf("INSERT INTO product_img(mid,imgext,imgname,fck)VALUES('%s','%s','%s','%s')",$_POST['mem_auto'],$imgext,$i,$fck); }else{ $Indate = sprintf("UPDATE product_img set imgext='%s',fck='%s' where pid='%s'",$imgext,$fck,$_POST['pid'.$i]); } mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($Indate, $BE2) or die(mysql_error()); } } $write='資料已更新...'; $insertGoTo = "myproduct.html" ; echo ""; } $currentPage = "productedit.html";//$_SERVER["PHP_SELF"]; $pid='-1'; if (isset($_GET['id'])) { $pid = $_GET['id']; } mysql_select_db($database_BE2, $BE2); $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); mysql_select_db($database_BE2, $BE2); $query_Rt2 = sprintf("SELECT * FROM product_data WHERE company_num = '%s' AND mem_auto='%s'",$_SESSION['login_coid'],$pid); $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 = sprintf("SELECT * FROM product_img WHERE mid = '%s' ",$row_Rt2['mem_auto']); $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); $imgdata=0; $imgcount=8; $arr1=array(); if($totalRows_Rt3>0){ $imgdata =0; do { $arr1[$imgdata][1]=$row_Rt3['pid']; $arr1[$imgdata][2]=$row_Rt3['imgext']; $arr1[$imgdata][3]=$row_Rt3['imgname']; $arr1[$imgdata][4]=$row_Rt3['fck']; $imgdata++; } while ($row_Rt3 = mysql_fetch_assoc($Rt3)); } if($imgdata<8){ for($i= $imgdata ;$i<8;$i++){ $arr1[$i][1]=0; $arr1[$i][2]=""; $arr1[$i][3]=""; $arr1[$i][4]=""; } } ?>