查看文件: tb2cityadd.php

大小: 2.87 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")) {
 
  $ec=explode(",",$_POST['ec1']);
  $insertkid = sprintf("INSERT INTO tb2city(buid2,ec1,ec3,bctaddr,bcttel) VALUES('%s','%s','%s','%s','%s')",$_POST['buid'],$ec[0],$ec[1],$_POST['bctaddr'],$_POST['bcttel']);
 
   mysql_select_db($database_BE2, $BE2);
   $Result1 = mysql_query($insertkid, $BE2) or die(mysql_error());
 	   
   $write='資料已更新...';
   echo  "<script>alert('".$write."');</script>";
   $updateGoTo =$_POST['url']; 
   header(sprintf("Location: %s", $updateGoTo));
	 
 }

mysql_select_db($database_BE2, $BE2);
$query_Rt2 =sprintf("select c.bc2,c.bc3,c.bc4,a.* from tb2 as c,tb1 as a  where c.buid='%s' order by a.tbc0,a.ec4",$_GET['id']);
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
// if($_SERVER['REMOTE_ADDR']=='220.130.43.121'){ echo $query_Rt2;}
?>
<div class="font2"><? echo $row_Rt2['bc2']." ".$row_Rt2['bc3'].$row_Rt2['bc4'] ?></div> 
<div id="content" align="center">
 <form id="form1" name="form1" method="post" action="">
 <table width="46%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <th height="33" align="center" valign="middle" nowrap="nowrap" class="font2">服務城市</th>
          <th valign="middle" nowrap="nowrap" class="font2">服務電話</th>
          <th align="center" valign="middle" class="font2">服務地址</th>
          <th align="center" valign="middle" class="font2">&nbsp;</th>
        </tr>

<?php
mysql_free_result($Rt2);
?>