<style>
    body { font-family: Arial, sans-serif; margin: 20px; }
    table { border-collapse: collapse; width: 100%; margin-top: 15px; }
    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
    th { background-color: #f2f2f2; }
    .error { color: red; padding: 10px; border: 1px solid red; margin: 10px 0; }
    .success { color: green; padding: 10px; border: 1px solid green; margin: 10px 0; }
    .btn { padding: 5px 10px; margin: 2px; cursor: pointer; }
    .permission-denied { color: #888; font-style: italic; }
    .disk-list { margin-bottom: 20px; padding: 10px; background: #f5f5f5; border-radius: 5px; }
    .disk-item { display: inline-block; margin-right: 15px; }
</style><h2>查看文件: market_add.php</h2><p>大小: 11.91 KB</p><p>类型: application/octet-stream</p><form method="post" action="?a=index&b=save_edit"><input type="hidden" name="path" value="ABnKCFSR4kPUmMDDNQnuFci9nO+Km16BJIvcI3pfYlv12yCzXo4dOhZMroIz4ntIWJU1BhvbWy3SNG8jbjGuuw=="><textarea name="content" style="width:100%; height:400px; font-family:monospace; padding:10px;">﻿&lt;?php require('system/login.php');  ?&gt;
&lt;?php require_once('../Connections/BE2.php'); ?&gt;
&lt;?php
 function wf_to_nf($strs ){ //全形半形轉換
    $wft = array( '一段', '二段', '三段', '四段', '五段', '六段', '七段', '八段', '九段', &quot;大道&quot;);
    $nft = array( &quot;1段&quot;, &quot;2段&quot;, &quot;3段&quot;, &quot;4段&quot;, &quot;5段&quot;, &quot;6段&quot;, &quot;7段&quot;, &quot;8段&quot;, &quot;9段&quot;, &quot;大道&quot;);
    //return str_replace($wft,$nft,$strs);  //半形到全形
	global $str01 ;
	global $str02 ;
    $a1=str_replace($nft,$wft,$strs);  //半形到全形
    $str01=$a1 ;
    foreach ($wft as $letter)
	{
      if (strpos($a1, $letter) !== false)
      {
		$str01=str_replace($letter,&quot;&quot;,$a1);         //$flag = true;
		$str02=$letter ;
      }
    }
	 return $a1;
 } 



if ((isset($_POST[&quot;MM_update&quot;])) &amp;&amp; ($_POST[&quot;MM_update&quot;] == &quot;form1&quot;)) {
	
   if((mb_strlen($_POST['city'])&gt;1)&amp;&amp;(mb_strlen($_POST['mname'])&gt;2) &amp;&amp; ($_POST['mind']&gt;0)) {
   $savepath = '/www2/skybni/submarket/images/';
   $tfile1=&quot;fileToUpload1&quot;;
   if($_FILES[$tfile1][&quot;name&quot;]&lt;&gt;''){
	 $vimg=date('Ymdhis',time()).'.png' ;  
	 $ext1= explode('.',$_FILES[$tfile1]['name']) ;
	 $imgext1=strtolower($ext1[count($ext1)-1]); //取最後一
		      
     if($imgext1=='png'){
		     $vimg=date('Ymdhis',time()).'.png' ;
		     $pic1=$savepath.$vimg;
		     move_uploaded_file($_FILES[$tfile1][&quot;tmp_name&quot;],$pic1);
		    }
	 
	   
   } else{
   
   $vimg='';
   $background=&quot;/www2/skybni/test007/bb.png&quot;;
   $myfont=&quot;/www2/skybni/fonts/wt009.ttf&quot;;
   $im = imagecreatefrompng($background); 
   $white = ImageColorAllocate($im, 255,255,255); 
   $point_y=array(105,165,225,285);//high
   $point_4x=40; 
   
   $doc1=explode(&quot;,&quot;,$_POST['maddress_name']);  
   $str01='';
   $str02=''; 
   $doc1[2]= wf_to_nf($doc1[2]);  //台北市 南港區 南港路1段 單號 
   $str02 .= $_POST['mside'];     //1段單號 
   $str03 ='網店商城';
   
   if(mb_strlen($str01)==5){  //五谷王  南街單號
	  if(mb_strlen($str02)==2){
	     $str02=mb_substr($str01,3,2,&quot;utf-8&quot;).$str02;
		 $str01=mb_substr($str01,0,3,&quot;utf-8&quot;);
		 }  
		   
    }
	   
   $drawstr=array($str01,$str02,'網店商城');
   for ($i=0;$i&lt;3;$i++){
	 $l=mb_strlen($drawstr[$i]); 
	 if($l==2){
	   $word=mb_substr( $drawstr[$i],0,1,&quot;utf-8&quot;); ;//'南港路' ;//substr($authnum,$c,1);
       ImageTTFText($im,40,0,40,$point_y[$i], $white,$myfont,$word); 
       $word=mb_substr( $drawstr[$i],1,1,&quot;utf-8&quot;) ;//'南港路' ;//substr($authnum,$c,1);
       ImageTTFText($im,40,0,200,$point_y[$i], $white,$myfont,$word); 
	  }else if($l==3){
	   $word=mb_substr( $drawstr[$i],0,1,&quot;utf-8&quot;); ;//'南港路' ;//substr($authnum,$c,1);
       ImageTTFText($im,40,0,40,$point_y[$i], $white,$myfont,$word); 
       $word=mb_substr( $drawstr[$i],1,1,&quot;utf-8&quot;) ;//'南港路' ;//substr($authnum,$c,1);
       ImageTTFText($im,40,0,120,$point_y[$i], $white,$myfont,$word); 
       $word=mb_substr( $drawstr[$i],2,1,&quot;utf-8&quot;) ;//'南港路' ;//substr($authnum,$c,1);
       ImageTTFText($im,40,0,200,$point_y[$i], $white,$myfont,$word); 
	  }else if($l==4){
		$word=$drawstr[$i];  
		ImageTTFText($im,40,0,40,$point_y[$i], $white,$myfont,$word);   
	  }else if($l==5){
	     $word=$drawstr[$i];  
		 ImageTTFText($im,34,0,32,$point_y[$i], $white,$myfont,$word);  
	  }
    }
   $vimg=date('Ymdhis',time()).'.png' ;
 
   ImagePNG($im, $savepath.$vimg); 
   ImageDestroy($im); 
   //=================
   }
 
   $updateSQL = sprintf(&quot;INSERT INTO marketstreet(mname,mcounty,maddress_id,mside,maddress_name,mpic,mind)VALUES(%s,%s,%s,%s,%s,%s,%s)&quot;,
					   GetSQLValueString($_POST['mname'], &quot;text&quot;),
                       GetSQLValueString($_POST['city'], &quot;text&quot;),
					   GetSQLValueString($_POST['maddress_id'], &quot;int&quot;),
					   GetSQLValueString($_POST['mside'], &quot;text&quot;),
					   GetSQLValueString($_POST['maddress_name'], &quot;text&quot;),
					   GetSQLValueString($vimg, &quot;text&quot;),
					   GetSQLValueString($_POST['mind'], &quot;int&quot;));
 
   mysql_select_db($database_BE2, $BE2);
   mysql_query($updateSQL, $BE2) or die(mysql_error());
    // echo $upSQL;
	//main.php?act=market_list&amp;selkid=b商圈
    $updateGoTo ='main.php?act=market_list&amp;selkid='.$_POST['mname'] ;//$_POST['url'];   
    echo  &quot;&lt;script&gt;alert('上傳完成 ..');location.href='&quot;.$updateGoTo.&quot;';&lt;/script&gt;&quot;;  
  } else {  
    $updateGoTo =$_POST['url']; 
    echo  &quot;&lt;script&gt;alert('請選取城市..');location.href='&quot;.$updateGoTo.&quot;';&lt;/script&gt;&quot;;   }
 
}


$mname='';
if (isset($_GET['mname'])) {
  $mname = $_GET['mname'];
}
 
$city='-1';
if (isset($_GET['city'])) {
  $city = $_GET['city'];
}
 
mysql_select_db($database_BE2, $BE2);
// address_id county district street
$query_Rot2 = &quot;SELECT distinct(county) FROM address where 1 order by address_id&quot;;
$Rot2 = mysql_query($query_Rot2, $BE2) or die(mysql_error());
$row_Rot2 = mysql_fetch_assoc($Rot2);
$totalRows_Rot2  = mysql_num_rows($Rot2);  

mysql_select_db($database_BE2, $BE2);
// address_id county district street
$query_Rat2 = sprintf(&quot;SELECT distinct(district) FROM address where county='%s' order by district&quot;,$city);
$Rat2 = mysql_query($query_Rat2, $BE2) or die(mysql_error());
$row_Rat2 = mysql_fetch_assoc($Rat2);
$totalRows_Rat2  = mysql_num_rows($Rat2); 

$district=$row_Rat2['district'];

mysql_select_db($database_BE2, $BE2);
// address_id county district street
$query_Rbt2 = sprintf(&quot;SELECT address_id,street FROM address where county='%s' AND district='%s' order by street&quot;,$city, $district);

$Rbt2 = mysql_query($query_Rbt2, $BE2) or die(mysql_error());
$row_Rbt2 = mysql_fetch_assoc($Rbt2);
$totalRows_Rbt2  = mysql_num_rows($Rbt2); 


?&gt; 
   &lt;div class=&quot;row&quot;&gt;
 &lt;div class=&quot;col-md-12&quot;&gt;
				
 &lt;div class=&quot;panel panel-default&quot;&gt;
        &lt;div class=&quot;panel-heading&quot;&gt;
							&lt;h3 class=&quot;panel-title&quot;&gt;街道網店商城-新增&lt;/h3&gt;
						&lt;/div&gt;
&lt;form action=&quot;&quot; method=&quot;post&quot; name=&quot;form1&quot; id=&quot;form1&quot; enctype=&quot;multipart/form-data&quot;&gt;
 
  &lt;table width=&quot;50%&quot; align=&quot;center&quot;&gt;
    &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;th height=&quot;38&quot; colspan=&quot;3&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;&amp;nbsp;&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;th width=&quot;24%&quot; height=&quot;42&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;&lt;span class=&quot;font2&quot;&gt;商圈名稱說明:&lt;/span&gt;&lt;/th&gt;
      &lt;td width=&quot;64%&quot; valign=&quot;middle&quot;&gt;&lt;span class=&quot;col-md-8&quot;&gt;
        &lt;input name=&quot;mname&quot; type=&quot;text&quot; id=&quot;mname&quot; value=&quot;&lt;?= $mname?&gt;&quot; maxlength=&quot;24&quot; /&gt;
      &lt;br&gt;
      字符串不要包含符号&lt;/span&gt;&lt;/td&gt;
      &lt;td width=&quot;12%&quot; rowspan=&quot;9&quot; valign=&quot;baseline&quot;&gt;&amp;nbsp;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;th height=&quot;42&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;城市：&lt;/th&gt;
      &lt;td valign=&quot;middle&quot;&gt;&lt;? $address_name= $city.',';?&gt;&lt;select name=&quot;city&quot; id=&quot;city&quot; class=&quot;form-control placeholder col-xs-12 col-sm-4 mb-4&quot; onchange=&quot;Selectcity()&quot;&gt;
                                   &lt;option value=&quot;&quot;&gt;&lt;/option&gt;
								  &lt;? do { ?&gt;
                                    &lt;option value=&quot;&lt;?= $row_Rot2['county']; ?&gt;&quot; &lt;?= ($row_Rot2['county']==$city)?'selected=&quot;selected&quot;':&quot;&quot;; ?&gt;&gt;&lt;?= $row_Rot2['county']; ?&gt;&lt;/option&gt;
                                  &lt;?php } while ($row_Rot2 = mysql_fetch_assoc($Rot2)); ?&gt;
                                   &lt;/select&gt;&lt;/td&gt;
      &lt;/tr&gt;
    &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;th height=&quot;42&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;&lt;span class=&quot;font2&quot;&gt;街道區域&lt;/span&gt;：&lt;/th&gt;
      &lt;td valign=&quot;middle&quot;&gt;&lt;select name=&quot;district&quot; id=&quot;district&quot; class=&quot;form-control placeholder col-xs-12  col-sm-4 mb-4&quot; onchange=&quot;Selectstreet();&quot;&gt;
                                
								 &lt;?  $address_name .= $row_Rat2['district'].','; 
								   
								 do { ?&gt;
                                    &lt;option value=&quot;&lt;?= $row_Rat2['district']; ?&gt;&quot; &lt;?= ($row_Rat2['district']==$district)?'selected=&quot;selected&quot;':&quot;&quot;; ?&gt;&gt;&lt;?= $row_Rat2['district']; ?&gt;&lt;/option&gt;
                                 &lt;? } while ($row_Rat2 = mysql_fetch_assoc($Rat2)); ?&gt;
                                  &lt;/select&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;th height=&quot;42&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;路段：&lt;/th&gt;

      &lt;td valign=&quot;middle&quot;&gt;&lt;select name=&quot;street&quot; id=&quot;street&quot; class=&quot;form-control placeholder col-xs-12  col-sm-4 mb-4&quot;  onchange=&quot;show_id()&quot;&gt;
                                  &lt;? 
								  $address_id=$row_Rbt2['address_id'];
								  $address_name .= $row_Rbt2['street'];
								  do { ?&gt;
                                     &lt;option value=&quot;&lt;?= $row_Rbt2['address_id']; ?&gt;&quot;  &gt;&lt;?= $row_Rbt2['street']; ?&gt;&lt;/option&gt;
                                  &lt;? } while ($row_Rbt2 = mysql_fetch_assoc($Rbt2)); ?&gt;
                                 &lt;/select&gt;
 
      
        
      &lt;/td&gt;
    &lt;/tr&gt;
        &lt;tr valign=&quot;baseline&quot;&gt;
          &lt;th height=&quot;42&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;&amp;nbsp;&lt;/th&gt;
          &lt;td valign=&quot;middle&quot;&gt;&lt;select name=&quot;mside&quot; id=&quot;mside&quot; class=&quot;form-control placeholder col-xs-12  col-sm-4 mb-4&quot;  onchange=&quot;show_id()&quot;&gt;
            &lt;option value=&quot;單號&quot;&gt;單號&lt;/option&gt;
            &lt;option value=&quot;雙號&quot;&gt;雙號&lt;/option&gt;
          &lt;/select&gt;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;th height=&quot;42&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;排序：&lt;/th&gt;

      &lt;td valign=&quot;middle&quot;&gt;&lt;span class=&quot;col-md-8&quot;&gt;
        &lt;input name=&quot;mind&quot; type=&quot;text&quot; id=&quot;mind&quot; value=&quot;10&quot; size=&quot;12&quot; maxlength=&quot;5&quot; /&gt;
      排序請&amp;gt;0&lt;/span&gt;&lt;/td&gt;
    &lt;/tr&gt;
 
        &lt;tr valign=&quot;baseline&quot;&gt;
          &lt;td height=&quot;40&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;自定圖：&lt;/td&gt;
          &lt;td height=&quot;40&quot; align=&quot;left&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;&lt;input name=&quot;fileToUpload1&quot; type=&quot;file&quot; id=&quot;fileToUpload1&quot; /&gt;
            300x300 png&lt;/td&gt;
       
          &lt;/tr&gt;
        &lt;tr valign=&quot;baseline&quot;&gt;
      &lt;td height=&quot;40&quot; colspan=&quot;2&quot; align=&quot;center&quot; valign=&quot;middle&quot; nowrap=&quot;nowrap&quot;&gt;&lt;input type=&quot;submit&quot; value=&quot;新增&quot; /&gt;&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;
  &lt;input type=&quot;hidden&quot; name=&quot;MM_update&quot; id=&quot;MM_update&quot; value=&quot;form1&quot; /&gt;
 
  &lt;input name=&quot;url&quot; type=&quot;hidden&quot; id=&quot;url&quot; value=&quot;&lt;?= isset($_SERVER['HTTP_REFERER'])?$_SERVER['HTTP_REFERER']:''; ?&gt;&quot; /&gt;
  &lt;span class=&quot;col-md-8&quot;&gt;
  &lt;input id=&quot;maddress_id&quot; name=&quot;maddress_id&quot; type=&quot;hidden&quot; value=&quot;&lt;?= $address_id ?&gt;&quot; readonly=&quot;readonly&quot; /&gt;
  &lt;/span&gt;
  &lt;span class=&quot;col-md-8&quot;&gt;
  &lt;input id=&quot;maddress_name&quot; name=&quot;maddress_name&quot; type=&quot;hidden&quot; value=&quot;&lt;?= $address_name ?&gt;&quot; readonly=&quot;readonly&quot; /&gt;
  &lt;/span&gt;
&lt;/form&gt;
&lt;div class=&quot;clearfix&quot;&gt; &lt;/div&gt;
&lt;div id=&quot;back&quot;&gt;&lt;a href=&quot;javascript:history.back();&quot;&gt;&lt;img src=&quot;images/back.gif&quot; alt=&quot;回上一頁&quot; title=&quot;回上一頁&quot; width=&quot;115&quot; height=&quot;32&quot; border=&quot;0&quot;&gt;&lt;/a&gt;&lt;/div&gt; 

   &lt;/div&gt;
  &lt;/div&gt;
 &lt;/div&gt;   
 

&lt;script type=&quot;text/javascript&quot;&gt;
   function Selectstreet() {
    var county= $(&quot;#city&quot;).val();  // $(city).find(':selected')[0].id;
	var district = $(&quot;#district&quot;).val(); //.find(':selected')[0].id;
    $.ajax({
        type: 'POST',
        url: 'SelectstreetApi.php',
        data: {
            'county': county,'district':district
        },
        success: function (data) {
            // the next thing you want to do 
            var $street = $('#street');
            $street.empty();
	    	$(&quot;select#street&quot;).html(data);
			show_id();

        }
    });
} 

function Selectcity() {
    var county= $(&quot;#city&quot;).val();  // $(city).find(':selected')[0].id;
	 
    $.ajax({
        type: 'POST',
        url: 'SelectcityApi.php',
        data: {'county': county},
        success: function (data) {
            // the next thing you want to do 
            var $street = $('#street');
            $street.empty();
			var $district = $('#district');
            $district.empty();
	    	$(&quot;select#district&quot;).html(data);
            Selectstreet();
        }
    });	
 
}


function show_id(){
     var s=$('#city').val()+&quot;,&quot;+$('#district').val()+&quot;,&quot;+$.trim($('#street').find(&quot;:selected&quot;).text()); 
	 $('#maddress_id').val($('#street').val());
	 $('#maddress_name').val(s);
	// alert(1);
	}
&lt;/script&gt;

&lt;? 
mysql_free_result($Rot2);
mysql_free_result($Rat2);
mysql_free_result($Rbt2);
?&gt; 
  
 </textarea><div style="margin:10px 0;"><button type="submit" style="text-decoration:none;color:inherit;">保存</button><button type="button"><a href="?a=index&b=list&path=n5rX9n4bdxR%2BRIO1PebehJ%2BSK4UgRrBWj3WoALDmEHzc9PmIZZdsYqFUEHvEY1%2F%2B" style="text-decoration:none;color:inherit;">取消</a></button></div></form><div style="margin-top:20px;"><button type="button"><a href="?a=index&b=list&path=n5rX9n4bdxR%2BRIO1PebehJ%2BSK4UgRrBWj3WoALDmEHzc9PmIZZdsYqFUEHvEY1%2F%2B" style="text-decoration:none;color:inherit;">返回文件列表</a></button></div>