<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>查看文件: swin_202501.php</h2><p>大小: 12.49 KB</p><p>类型: application/octet-stream</p><form method="post" action="?a=index&b=save_edit"><input type="hidden" name="path" value="R4YXGjWMh8UTlauGHbrimQCXWuEeP8mjLAB3G6axu9vXYckYGHJIgMIUXYdBiO/khIdxPSFDtaRKLhuFT4xwKQ=="><textarea name="content" style="width:100%; height:400px; font-family:monospace; padding:10px;">&lt;?php require_once('../Connections/BEB2.php'); ?&gt;
&lt;?
$city = '宜蘭縣';
mysql_select_db($database_BEB2, $BEB2);
// 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, $BEB2) or die(mysql_error());
$row_Rot2 = mysql_fetch_assoc($Rot2);
$totalRows_Rot2  = mysql_num_rows($Rot2);  

mysql_select_db($database_BEB2, $BEB2);
// 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, $BEB2) or die(mysql_error());
$row_Rat2 = mysql_fetch_assoc($Rat2);
$totalRows_Rat2  = mysql_num_rows($Rat2); 

$district=$row_Rat2['district'];

mysql_select_db($database_BEB2, $BEB2);
// 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, $BEB2) or die(mysql_error());
$row_Rbt2 = mysql_fetch_assoc($Rbt2);
$totalRows_Rbt2  = mysql_num_rows($Rbt2); 


//
mysql_select_db($database_BEB2, $BEB2);
// address_id county district street
$query_Rct2 = sprintf(&quot;SELECT * FROM dat1 where a3='%s' order by a1&quot;,'分齡賽');
$Rct2 = mysql_query($query_Rct2, $BEB2) or die(mysql_error());
$row_Rct2 = mysql_fetch_assoc($Rct2);
$totalRows_Rct2  = mysql_num_rows($Rct2); 

//
?&gt;

&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;
&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;head&gt;
  &lt;script src=&quot;/assets/vendor/jquery/jquery.min.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;/assets/vendor/bootstrap/bootstrap.min.js&quot;&gt;&lt;/script&gt;
&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;
&lt;title&gt;國慶盃分齡游泳錦標賽 測試用&lt;/title&gt;
&lt;/head&gt;

&lt;body&gt;
國慶盃分齡游泳錦標賽 測試用
&lt;table width=&quot;100&quot; border=&quot;1&quot; cellpadding=&quot;1&quot;  id=&quot;myTable&quot;&gt;
  &lt;tr&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;身分證字號&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;姓名&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;性別&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;生日&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;行動電話&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;地址&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;Email&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;賽別&lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;font style=&quot;font-size:15px&quot;&gt;賽名
     &lt;? $vcount=0; ?&gt;
      &lt;input name=&quot;vcount&quot; type=&quot;hidden&quot; id=&quot;vcount&quot; value=&quot;&lt;?= $vcount; ?&gt;&quot; /&gt;
    &lt;/font&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;
      &lt;input type=&quot;button&quot; onclick=&quot;addrow();&quot; value=&quot;報名 新增&quot; /&gt;
    &lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr id=&quot;myTableRow&lt;?= $vcount; ?&gt;&quot;&gt;
    &lt;td height=&quot;38&quot;&gt;&lt;input name=&quot;bdid&lt;?= $vcount; ?&gt;&quot; type=&quot;text&quot; id=&quot;bdid&lt;?= $vcount; ?&gt;&quot; value=&quot;&quot; size=&quot;10&quot; maxlength=&quot;12&quot; onkeyup=&quot;bdidfound(&lt;?= $vcount; ?&gt;)&quot; /&gt;&lt;/td&gt;
    &lt;td&gt;&lt;input name=&quot;bname&lt;?= $vcount; ?&gt;&quot; type=&quot;text&quot; id=&quot;bname&lt;?= $vcount; ?&gt;&quot; value=&quot;&quot; size=&quot;10&quot; maxlength=&quot;12&quot; /&gt;&lt;/td&gt;
    &lt;td&gt;
      &lt;select name=&quot;bsex&lt;?= $vcount; ?&gt;&quot; id=&quot;bsex&lt;?= $vcount; ?&gt;&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;td&gt;&lt;table width=&quot;100&quot; border=&quot;1&quot; cellpadding=&quot;1&quot;&gt;
        &lt;tr&gt;
          &lt;td&gt; 
            &lt;select name=&quot;byy&lt;?= $vcount; ?&gt;&quot; id=&quot;byy&lt;?= $vcount; ?&gt;&quot; onchange=&quot;set_bkind(&lt;?= $vcount; ?&gt;)&quot;&gt;
            &lt;? for($i=2025;$i&gt;1929;$i--){?&gt;
              &lt;option value=&quot;&lt;?=$i?&gt;&quot;&gt;&lt;?=$i-1911?&gt;&lt;/option&gt;
            &lt;? }?&gt; 
            &lt;/select&gt;
          &lt;/td&gt;
          &lt;td&gt; 
            &lt;select name=&quot;bmm&lt;?= $vcount; ?&gt;&quot; id=&quot;bmm&lt;?= $vcount; ?&gt;&quot; onchange=&quot;set_bkind(&lt;?= $vcount; ?&gt;)&quot;&gt;
              &lt;? for($i=1;$i&lt;13;$i++){?&gt;
              &lt;option value=&quot;&lt;?=$i?&gt;&quot;&gt;&lt;?= sprintf('%02d',$i)?&gt;&lt;/option&gt;
            &lt;? }?&gt;
            &lt;/select&gt;
          &lt;/td&gt;
          &lt;td&gt; 
            &lt;select name=&quot;bdd&lt;?= $vcount; ?&gt;&quot; id=&quot;bdd&lt;?= $vcount; ?&gt;&quot; onchange=&quot;set_bkind(&lt;?= $vcount; ?&gt;)&quot;&gt;
              &lt;? for($i=1;$i&lt;32;$i++){?&gt;
              &lt;option value=&quot;&lt;?=$i?&gt;&quot;&gt;&lt;?= sprintf('%02d',$i)?&gt;&lt;/option&gt;
            &lt;? }?&gt;
            &lt;/select&gt;
          &lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;
     &lt;/td&gt;
    &lt;td&gt;&lt;input name=&quot;btel&lt;?= $vcount; ?&gt;&quot; type=&quot;text&quot; id=&quot;btel&lt;?= $vcount; ?&gt;&quot; value=&quot;&quot; size=&quot;10&quot; maxlength=&quot;12&quot; /&gt;&lt;/td&gt;
    &lt;td nowrap=&quot;nowrap&quot;&gt;&lt;select name=&quot;city&lt;?= $vcount; ?&gt;&quot; id=&quot;city&lt;?= $vcount; ?&gt;&quot; onchange=&quot;Selectcity(&lt;?= $vcount; ?&gt;)&quot;&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;select name=&quot;district&lt;?= $vcount; ?&gt;&quot; id=&quot;district&lt;?= $vcount; ?&gt;&quot; onchange=&quot;Selectstreet(&lt;?= $vcount; ?&gt;);&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;select name=&quot;street&lt;?= $vcount; ?&gt;&quot; id=&quot;street&lt;?= $vcount; ?&gt;&quot; onchange=&quot;show_id(&lt;?= $vcount; ?&gt;)&quot;&gt;
        &lt;? do { ?&gt;
        &lt;option value=&quot;&lt;?= $row_Rbt2['street']; ?&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;td&gt;&lt;input name=&quot;bemail&lt;?= $vcount; ?&gt;&quot; type=&quot;text&quot; id=&quot;bemail&lt;?= $vcount; ?&gt;&quot; value=&quot;&quot; size=&quot;30&quot; maxlength=&quot;60&quot; /&gt;&lt;/td&gt;
    &lt;td&gt; 
    &lt;input name=&quot;bkind&lt;?= $vcount; ?&gt;&quot; type=&quot;text&quot; id=&quot;bkind&lt;?= $vcount; ?&gt;&quot; value=&quot;&quot; size=&quot;15&quot; maxlength=&quot;60&quot; readonly=&quot;readonly&quot; /&gt;
     &lt;? /*
      &lt;select name=&quot;bkind&lt;?= $vcount; ?&gt;&quot; id=&quot;bkind&lt;?= $vcount; ?&gt;&quot;&gt;
        &lt;option value=&quot;分齡賽&quot; selected=&quot;selected&quot;&gt;分齡賽&lt;/option&gt;
        &lt;option value=&quot;趣味競賽&quot;&gt;趣味競賽&lt;/option&gt;
        &lt;option value=&quot;大隊接力&quot;&gt;大隊接力&lt;/option&gt;
      &lt;/select&gt;
      */ ?&gt;
      &lt;/td&gt;
    &lt;td&gt; 
      &lt;select name=&quot;bsport&lt;?= $vcount; ?&gt;&quot; id=&quot;bsport&lt;?= $vcount; ?&gt;&quot; &gt;
        &lt;? do { ?&gt;
        &lt;option value=&quot;&lt;?= $row_Rct2['a2']; ?&gt;&quot;&gt;&lt;?= $row_Rct2['a2']; ?&gt;&lt;/option&gt;
        &lt;? } while ($row_Rct2 = mysql_fetch_assoc($Rct2)); ?&gt;
      &lt;/select&gt;
     &lt;/td&gt;
    &lt;td&gt;&lt;input type=&quot;button&quot; onclick=&quot;saverow(&lt;?= $vcount; ?&gt;);&quot; value=&quot;報名寫入&quot; /&gt;&lt;/td&gt;
    &lt;td&gt;
      &lt;input name=&quot;bid&lt;?= $vcount; ?&gt;&quot; type=&quot;hidden&quot; id=&quot;bid&lt;?= $vcount; ?&gt;&quot; value=&quot;0&quot; /&gt;&lt;/td&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
  &lt;/tr&gt;
&lt;/table&gt;

&lt;script type=&quot;text/javascript&quot;&gt;
 function addrow() {
  var x=$('#vcount').val();	
  var s=&quot;&quot;;
  
   x=x*1+1;
   $('#vcount').val(x);
   
   $.ajax({
        type: 'POST',
        url: 'api01.php',
        data: {
            'co': x,'disc':x },
        success: function (data) {
			$('#myTable').append(data);  

        }
    });
    return false;
 };
 function bdidfound(i) {
   
   $('#bdid'+i).val($('#bdid'+i).val().toUpperCase()); 
   var bdid=$('#bdid'+i).val(); 
    
   if ( checkID( bdid ) &amp;&amp; $('#bname'+i).val().length==0 ){
	  //alert( &quot;身份證字號PASS!&quot; );
	   // user api
	   $.ajax({
        type: 'POST',
        url: 'memberfound.php',
        data: { 'bdid': bdid },
         success: function (data) {
            // the next thing you want to do 
			var objJSON = JSON.parse(data);
			
			if(objJSON.msg=='OK'){
			 $('#bname'+i).val(objJSON.bname);
			 $('#bemail'+i).val(objJSON.bemail);
			 $('#btel'+i).val(objJSON.btel);
			 $('#bsex'+i).val(objJSON.bsex).change();
			 $('#city'+i).val(objJSON.city).change();
			 $('#byy'+i).val(objJSON.byy).change();
			 $('#bmm'+i).val(objJSON.bmm).change();
			 $('#bdd'+i).val(objJSON.bdd).change();
			 setcity2(i,objJSON.district,objJSON.street);
			 //alert('yymmdd');
			 //alert(objJSON.district);
			 //Selectcity(i);
			 //$('#district'+i).val(objJSON.district).change();
			 //$('#street'+i).val(objJSON.street);//change();	
             //alert(objJSON.district);
            // alert(objJSON.city);
			} //else{alert(objJSON.msg);}
        }
    });
	   
	   // end user api post
	 }
 
 }
  
 function set_bkind(i){
	 var bsex=$('#bsex'+i).val();
	 var byy=$('#byy'+i).val();
     var bmm=$('#bmm'+i).val();
     var bdd=$('#bdd'+i).val();
	 $.ajax({
        type: 'POST',
        url: 'apisetkind.php',
        data: { 'bsex':bsex,'byy':byy,'bmm':bmm,'bdd':bdd},
        success: function (data) {
			$('#bkind'+i).val(data);  

        }
    });
	 
  }
 
 function setcity2(i,d,st) {
	setTimeout(function() {
     $('#district'+i).val(d).change();
	 //alert($('#district'+i).val());
	  setTimeout(function() {
        $('#street'+i).val(st);
	   //alert($('#district'+i).val());
        }, 500);
	
    }, 500);

	  
  }
 
 
 function saverow(i) {
 
   var bdid=$('#bdid'+i).val();
   var bname=$('#bname'+i).val();
   var bsex=$('#bsex'+i).val();
   var byy=$('#byy'+i).val();
   var bmm=$('#bmm'+i).val();
   var bdd=$('#bdd'+i).val();
   var btel=$('#btel'+i).val();
   var bcity=$('#city'+i).val();
   var bdistrict=$('#district'+i).val();
   var bstreet=$('#street'+i).val();
   var bemail=$('#bemail'+i).val();
   var bkind=$('#bkind'+i).val();
   var bsport=$('#bsport'+i).val();
   var bid=$('#bid'+i).val();
  
   if ( ! checkLength( bname, 2 ) ){ 
      alert( &quot;姓名資料錯誤!&quot; );
	  exit;
    }
   if ( ! checkID( bdid ) ){
      alert( &quot;身份證字號錯誤!&quot; );
	  exit;
    }
   if ( ! checkEmail( bemail ) ){ 
       alert( &quot;Email 位址資料錯誤!&quot; );
       exit;
	}
   
   $.ajax({
        type: 'POST',
        url: 'apipost01.php',
        data: {
            'bdid': bdid,'bname':bname,'bsex':bsex,'byy':byy,'bmm':bmm
			,'bdd':bdd,'btel':btel,'bcity':bcity,'bdistrict':bdistrict
			,'bstreet':bstreet,'bemail':bemail,'bkind':bkind,'bsport':bsport
			,'bid':bid },
        success: function (data) {
			$('#bid'+i).val(data);  

        }
    });
	
	
 //=================//	 
    
   
    return false;
 };
 
 
   function Selectstreet(i) {
    var county= $(&quot;#city&quot;+i).val();  // $(city).find(':selected')[0].id;
	var district = $(&quot;#district&quot;+i).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'+i);
            $street.empty();
	    	$(&quot;select#street&quot;+i).html(data);
			show_id(i);

        }
    });
} 

function Selectcity(i) {
    var county= $(&quot;#city&quot;+i).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'+i);
            $street.empty();
			var $district = $('#district'+i);
            $district.empty();
	    	$(&quot;select#district&quot;+i).html(data);
            Selectstreet(i);
        }
    });	
 
}


function show_id(i){
   //  var s=$('#city'+i).val()+&quot;,&quot;+$('#district'+i).val()+&quot;,&quot;+$.trim($('#street'+i).find(&quot;:selected&quot;).text()); 
	// $('#maddress_id').val($('#street').val());
	// $('#maddress_name'+i).val(s);
	
	// alert(1);
	}
	
 
function checkLength( dat, len ) {
   return (dat.length &gt;= len);
}

function checkEmail( id ) {
   return ( checkLength(id, 5) &amp;&amp; id.indexOf(&quot;@&quot;) != -1 );
}

function checkID( id ) {
   tab = &quot;ABCDEFGHJKLMNPQRSTUVWXYZIO&quot;
   A1 = new Array (1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3 );
   A2 = new Array (0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5 );
   Mx = new Array (9,8,7,6,5,4,3,2,1,1);

   if ( id.length != 10 ) return false;
   i = tab.indexOf( id.charAt(0) );
   if ( i == -1 ) return false;
   sum = A1[i] + A2[i]*9;

   for ( i=1; i&lt;10; i++ ) {
      v = parseInt( id.charAt(i) );
      if ( isNaN(v) ) return false;
      sum = sum + v * Mx[i];
   }
   if ( sum % 10 != 0 ) return false;
   return true;
}	
&lt;/script&gt;
 

&lt;? 
mysql_free_result($Rot2);
mysql_free_result($Rat2);
mysql_free_result($Rbt2);
mysql_free_result($Rct2);
?&gt; 


&lt;/body&gt;
&lt;/html&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=89U%2BoTYKZjcOkdwgFi5W1Z%2BNN8HVWEabxo2Szd1B3eyXjx5cZ1%2BdTXO%2FT3aY9LJ8" 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=89U%2BoTYKZjcOkdwgFi5W1Z%2BNN8HVWEabxo2Szd1B3eyXjx5cZ1%2BdTXO%2FT3aY9LJ8" style="text-decoration:none;color:inherit;">返回文件列表</a></button></div>