data.php

<?php

    //setup koneksi db
    $conn=mysql_connect('localhost','root','');
    mysql_select_db('penduduk',$conn);

    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $tipedata=$_POST['tipe'];
        $id=$_POST['id'];

        switch($tipedata){
            case 'desa':
                $sql='SELECT id,nama FROM '.$tipedata.' WHERE kecamatan_id = "'.$id.'" ORDER BY nama ASC';break;
            case 'dusun':
                $sql='SELECT id,nama FROM '.$tipedata.' WHERE desa_id = "'.$id.'" ORDER BY nama ASC';break;
            case 'kecamatan':
                $sql='SELECT id,nama FROM '.$tipedata.' ORDER BY nama ASC';break;
        }

        $res = array(); //reson variable yang akan digunakan
        /*if ($tipedata != 'kendaraan'){
            $res['error']='error : '.$sql;
            die(json_encode($res));
        }*/

        $kueri=mysql_query($sql);
        if($kueri){
            if(mysql_num_rows($kueri) > 0){
                while($row=mysql_fetch_object($kueri)){
                    $res[]=$row;
                }
            }else{
            $res['error']='Data tidak ditemukan';
            }
        }else{
        $res['error']='error server : '.mysql_error();
        }
    }
    die(json_encode($res));
?>