site_view

<?php

require ('config.php');

// jika ada parameter yang dilempar dari script index.php
// maka lakukan pencarian
if (isset($_GET['kab'])) {
    $id = $_GET['kab'];
    $sql = "SELECT * from `site_view` WHERE `kecamatan` LIKE '%".$id."%' or `kelurahan` LIKE '%".$id."%' or `id_site` LIKE '%".$id."%' ";
} else {
// kalo ga, tampilkan semua lokasi
    $sql = "SELECT * from `site_view`";
}

$data = mysql_query($sql);
$r = mysql_num_rows($s);

if($r == 0){

    // Jika data tidak ada
    $data['count']=0;

}else{



    $json = '{"warteg": {';
    $json .= '"cabang" ';
    while($x = mysql_fetch_array($data)){
        $json .= '{';
        $json .= '"idsite":"'.$x['id_site'].'",
        "singkatan":"'.$x['singkatan'].'",
        "x":"'.$x['latitude'].'",

        "y":"'.$x['longitude'].'"


        },';
        $json = substr($json,0,strlen($json)-1);
        $json .= ']';
        $json .= '}}';
        $warteg[]=array('x'=>$x['latitude'], 'y'=>$x['longitude'],
        'idsite'=>$x['id_site'],
        'singkatan'=>$x['singkatan']);

    //echo $json;
    }
    $data['warteg']=$warteg;

}
echo json_encode($data);
?>