查看文件: city_zone_add.php

大小: 3.96 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")) {
  $kbdoc=trim($_POST['kbdoc']);
  if  (isset($_POST['city']) && ($kbdoc<>'')){ 
   $INSERTSQL ="INSERT INTO addzone (k1,kbdoc)VALUES";
   
   $city = $_POST['city'];
   foreach ($city as $scity=>$value) {
            // echo "city : ".$value."<br />";
		    $s1=sprintf(" ( '%s','%s' ) ,",$value ,$kbdoc);
		$INSERTSQL .=$s1;   	 
        }
	$INSERTSQL=substr($INSERTSQL,0,-1);
	$INSERTSQL.=';';	
	
    mysql_select_db($database_BE2, $BE2);
    $Result1 = mysql_query($INSERTSQL, $BE2) or die(mysql_error());
	
    $updateGoTo =$_POST['url']; 
    echo  "<script>alert('上傳完成 ..');location.href='".$updateGoTo."';</script>";
	
  }
 
}
 
 
mysql_select_db($database_BE2, $BE2);
$query_R2 = "SELECT * FROM `addrcity` WHERE k1 <25";
$R2 = mysql_query($query_R2, $BE2) or die(mysql_error());
$row_R2 = mysql_fetch_assoc($R2);

?>
   <div class="row">
 <div class="col-md-12">
				
 <div class="panel panel-default">
        <div class="panel-heading">
							<h3 class="panel-title">新增-城市分區表</h3>
						</div>  
<form action="" method="post" name="form1" id="form1" >
 
  <table width="50%" align="center">
    <tr valign="baseline">
      <th height="38" colspan="3" align="center" valign="middle" nowrap="nowrap"><span class="font2">城市分區表 新增</span><span class="font2">分區</span></th>
    </tr>
    <tr valign="baseline">
      <th width="16%" height="42" align="center" valign="middle" nowrap="nowrap">&nbsp;</th>
      <td width="71%" valign="middle">&nbsp;</td>
      <td width="13%" valign="baseline">&nbsp;</td>
    </tr>
    <tr valign="baseline">
      <th height="42" align="center" valign="middle" nowrap="nowrap"><span class="font2">分區說明</span>：</th>

</div>
  </div>
 </div>

<? 
mysql_free_result($R2);