select provinsi -> kota

<?php
/*
formnya.. sekedar info cara memakainya
cukup load view di controller
dan anda tidak perlu menambahkan yang lain
*/
        $config2['hostname'] = "localhost";
        $config2['username'] = "root";
        $config2['password'] = "";
        $config2['database'] = "work_fb01";
        $config2['dbdriver'] = "mysqli";
        $config2['dbprefix'] = "";

        $this->db->close();
        $dsn = 'mysql://root:@localhost/work_fb01';
        $db2=$this->load->database($config2,TRUE);

if($_POST)
{
    ob_start();
    $id=$_POST['id'];
    $sql="SELECT id_kab_kota,kab_kota
FROM  `kab_kota` where id_provinsi = $id ";
    $q=$db2->query($sql)->result_array();
    foreach($q as $r)
        echo "\n\t<option value='$r[id_kab_kota]'>$r[kab_kota]</option>";
    $post=ob_get_contents();

    ob_end_clean();
    $a=array(
    'list'=>$post
    );
    $json= json_encode($a);

die($json);
}
?><script src='<?=site_url();?>js/jquery.js'></script>
<!--
silakan hapus yang menurut anda kurang cocok.. tidak ada masalah bila anda hapus
js di atas bisa di ubah sesuai posisi jquery
-->
<div style='width:400px;margin:auto'>
<form>
<p>Propinsi
    <br>

<?php
$s='';
$sql="SELECT id_provinsi,   kode_provinsi,  provinsi FROM  `provinsi` ";
$q=$db2->query($sql)->result_array();
foreach($q as $r)
    $s.= "\n\t<option value='$r[id_provinsi]'>$r[provinsi]</option>";
?>  <select name='prov' class='prov'><option>Pilih Provinsi</option>
<?=$s;?>
    </select><br/>
</p>
<p>Kota
    <br>
    <select name='kota' class='kota'>

    </select><br/>
</p>
<script>
$(".prov").click(function(){
    $(".kota").empty(); //kosongkan
    var id=$(this).val();
    console.log(id);
    var request = $.ajax({
          url: "<?=current_url();?>",
          type: "POST",
          data: {id : id},
          dataType: "json"
    });

    request.success(function(msg) {
        console.log('data sudah terkirim');
        $(".kota").append(msg.list);
    });

});
</script>
</form>
</div>