wilayah/index.php at master · adeiming/wilayah · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
/*
BISMILLAAHIRRAHMAANIRRAHIIM - In the Name of Allah, Most Gracious, Most Merciful
================================================================================
filename 	: index.php
purpose  	: main application page
create   	: 20170117
last edit	: 20210304
author   	: cahya dsn
demo site 	: https://wilayah.cahyadsn.com/v2
soure code 	: https://github.com/cahyadsn/wilayah
================================================================================
This program is free software; you can redistribute it and/or modify it under the
terms of the MIT License.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.

See the MIT License for more details

copyright (c) 2017-2021 by cahya dsn; cahyadsn@gmail.com
================================================================================*/
$dbhost ='localhost';
$dbuser ='root';
$dbpass ='';
$dbname ='wilayah';
$dbdsn = "mysql:dbname=$dbname;host=$dbhost";
try {
  $db = new PDO($dbdsn, $dbuser, $dbpass);
} catch (PDOException $e) {
  echo 'Connection failed: '.$e->getMessage();
}
$wil=array(
	2=>array(5,'Kota/Kabupaten','kab'),
	5=>array(8,'Kecamatan','kec'),
	8=>array(13,'Kelurahan','kel')
);
if (isset($_GET['id']) && !empty($_GET['id'])){
	$n=strlen($_GET['id']);
	$query = $db->prepare("SELECT * FROM wilayah_2020 WHERE LEFT(kode,:n)=:id AND CHAR_LENGTH(kode)=:m ORDER BY nama");
	$query->execute(array(':n'=>$n,':id'=>$_GET['id'],':m'=>$wil[$n][0]));
	echo"<option value=''>Pilih {$wil[$n][1]}</option>";
	while($d = $query->fetchObject())
		echo "<option value='{$d->kode}'>{$d->nama}</option>";
}else{
?>
<!DOCTYPE html>
<html>
	<head>
		<title>Data Daerah</title>
		<style>
			td,select {width:240px;}
			#kab_box,#kec_box,#kel_box{display:none;}
		 </style>
		<script>
		var my_ajax=do_ajax();
		var ids;
		var wil=new Array('kab','kec','kel');
		function ajax(id){
			if(id.length<13){
				ids=id;
				var url="?id="+id+"&sid="+Math.random();
				my_ajax.onreadystatechange=stateChanged;
				my_ajax.open("GET",url,true);
				my_ajax.send(null);
			}
		}
		function do_ajax(){
			if (window.XMLHttpRequest) return new XMLHttpRequest();
			if (window.ActiveXObject) return new ActiveXObject("Microsoft.XMLHTTP");
			return null;
		}
		function stateChanged(){
			var n=ids.length;
			var w=(n==2?wil[0]:(n==5?wil[1]:wil[2]));
			var data;
			if (my_ajax.readyState==4){
				data=my_ajax.responseText;
				document.getElementById(w).innerHTML = data.length>=0 ? data:"<option selected>Pilih Kota/Kab</option>";
				<?php foreach($wil as $k=>$w):?>
					document.getElementById("<?php echo $w[2];?>_box").style.display=(n><?php echo $k-1;?>)?'table-row':'none';
				<?php endforeach;?>
			}
		}
		</script>
	</head>
	<body>
		<table>
			<tr>
			<td>Provinsi</td>
			<td>
				<select id="prov" onchange="ajax(this.value)">
					<option value="">Provinsi</option>
					<?php
					$query=$db->prepare("SELECT kode,nama FROM wilayah WHERE CHAR_LENGTH(kode)=2 ORDER BY nama");
					$query->execute();
					while ($data=$query->fetchObject())
						echo '<option value="'.$data->kode.'">'.$data->nama.'</option>';
					?>
				<select>
			</td>
		</tr>
		<?php foreach($wil as $w):?>
		<tr id='<?php echo $w[2];?>_box'>
			<td><?php echo $w[1];?></td>
			<td>
				<select id="<?php echo $w[2];?>" onchange="ajax(this.value)">
					<option value="">Pilih <?php echo $w[1];?></option>
				</select>
			</td>
		</tr>
		<?php endforeach;?>
	</body>
</html>
<?php } ?>