查看文件: logo_video_add.php

大小: 6.92 KB

类型: application/octet-stream

<?php require('system/login.php');  ?>
<?php require_once('../Connections/BE2.php'); ?>
<?php

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
 
 //if(isset($_POST['vkid'])){
	 	
 if(isset($_POST['city']) && isset($_POST['vkid']) ){
	 
   $vkidzone ="";
   $vkid = $_POST['vkid'];
   foreach ($vkid as $svkid =>$value) {
		    $vkidzone .= $value .',';
        }	 
	 
   $cityzone ="";
   $city = $_POST['city'];
   foreach ($city as $scity=>$value) {
		    $cityzone .= $value .',';
        }
			
 mysql_select_db($database_BE2, $BE2);
 $query_R1 = "SELECT vid FROM video_master WHERE  1 order by vid desc limit 1";
 $R1 = mysql_query($query_R1, $BE2) or die(mysql_error());
 $row_R1 = mysql_fetch_assoc($R1);
 $totalRows_R1 = mysql_num_rows($R1); 
 $vid=$row_R1['vid']+1;
 mysql_free_result($R1);
 
 	
 $write='';
 
// $imgpath= '/www2/skybni/shopmap/images/';
  $imgpath= '/www2/skybni/video_img/logo/';
 
 $tfile1="fileToUpload1";
 $vimg=date('is',time());
   //lbg_ext001 2001 lbg_ext002 2002 
 if($_FILES[$tfile1]["name"]<>''){
		   $ext1= explode('.',$_FILES[$tfile1]['name']) ;
	       $imgext1=strtolower($ext1[count($ext1)-1]); //取最後一筆
		   if($imgext1=='png'){
			 
			 $logo_image=sprintf("%04d",$vid).$vimg.'.png'; 
			 $pic1=$imgpath.$logo_image;
		     move_uploaded_file($_FILES[$tfile1]["tmp_name"],$pic1);
		    }else{ $write='errpng'; }
  } 
 	
   $updateSQL = sprintf("INSERT INTO video_master (vkid,vdoc,vindex,vflag,video,vlink,vzone,vimg)VALUES(%s,%s,%s,%s,%s,%s,%s ,%s)",
                       GetSQLValueString($vkidzine, "text"), //GetSQLValueString($_POST['vkid'], "text"),
					   GetSQLValueString($_POST['vdoc'], "text"),
                       GetSQLValueString($_POST['vindex'], "int"),
					   GetSQLValueString($_POST['vflag'], "text"),
					   GetSQLValueString($_POST['video'], "text"),
					   GetSQLValueString($_POST['vlink'], "text"),
					   GetSQLValueString($cityzone, "text"),
					   GetSQLValueString($vimg, "text") );

mysql_select_db($database_BE2, $BE2);
   $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error());

$updateGoTo =$_POST['url']; 
  if( $write=='errpng'){
    echo  "<script>alert('僅限上傳 PNG 檔');location.href='".$updateGoTo."';</script>";
  }else{ echo  "<script>alert('上傳完成 ..');location.href='".$updateGoTo."';</script>"; }
 } // end isset vzone
//$_GET['id']=$_POST['lid'];
}
 
mysql_select_db($database_BE2, $BE2);
$query_R3 = "SELECT * FROM city_img where 1 order by ctid" ; 
$R3 = mysql_query($query_R3, $BE2) or die(mysql_error());
$row_R3 = mysql_fetch_assoc($R3);

?> 
<form action="" method="post" name="form1" id="form1" enctype="multipart/form-data">
 
  <table width="50%" align="center">
    <tr valign="baseline">
      <th height="38" colspan="3" align="center" valign="middle" nowrap="nowrap">&nbsp;</th>
    </tr>
    <tr valign="baseline">
      <th height="42" align="center" valign="middle" nowrap="nowrap">主圖：</th>
      <td valign="middle"><input name="fileToUpload1" type="file" id="fileToUpload1">  
        130 x 108px </td>
      <td width="23%" rowspan="5" valign="baseline">&nbsp;</td>
    </tr>
    <tr valign="baseline">
      <th height="42" align="center" valign="middle" nowrap="nowrap">分類：</th>

<? 
mysql_free_result($R3);
?>