-
Notifications
You must be signed in to change notification settings - Fork 0
/
maps_marker.php
47 lines (32 loc) · 1.14 KB
/
maps_marker.php
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
<?php
// include "koneksi.php";
require_once('config/koneksi.php');
require_once('model/database.php');
$connection = new Database ($host, $user, $pass, $database);
$id =$_GET['kat'];
if ($id == 0) {
$query = mysqli_query($connection->con, "SELECT * FROM tb_wisata ORDER BY nama ASC");
}else{
$query = mysqli_query($connection->con, "SELECT * FROM tb_wisata WHERE kategori='".$id."' ORDER BY nama ASC");
}
$json = '{"wisata": [';
// create looping dech array in fetch
while ($row = mysqli_fetch_array($query)){
// quotation marks (") are not allowed by the json string, we will replace it with the` character
// strip_tag serves to remove html tags on strings
$char ='"';
$json .=
'{
"id":"'.str_replace($char,'`',strip_tags($row['id'])).'",
"nama":"'.str_replace($char,'`',strip_tags($row['nama'])).'",
"lat":"'.str_replace($char,'`',strip_tags($row['latt'])).'",
"lng":"'.str_replace($char,'`',strip_tags($row['longi'])).'"
},';
}
// omitted commas at the end of the array
$json = substr($json,0,strlen($json)-1);
$json .= ']}';
// print json
echo $json;
mysqli_close($connection->con);
?>