Coding Untuk Membuat Select Propinsi, Kabupaten dan Kecematan

 Membuat Tampilan awal

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>


<div class="container mb-5">

<h2 align="center" style="margin: 60px 10px 10px 10px;">Combobox Bertingkat Daerah Indonesia</h2><hr>

<div class="row">

<div class="col-sm-6">

<div class="form-group">

<label>Provinsi</label>

<select class="form-control" name="provinsi" id="provinsi">

<option value=""> Pilih Provinsi</option>

</select>

</div>

<div class="form-group">

<label>Kabupaten</label>

<select class="form-control" name="kabupaten" id="kabupaten">

<option value=""></option>

</select>

</div>


<div class="form-group">

<label>Kecamatan</label>

<select class="form-control" name="kecamatan" id="kecamatan">

<option value=""></option>

</select>

</div>


<div class="form-group">

<label>Kelurahan</label>

<select class="form-control" name="kelurahan" id="kelurahan">

<option value=""></option>

</select>

</div>


</div>

</div>

<hr>

</div>


<div class="navbar bg-dark fixed-bottom">

<div style="color: #fff;">© <?php echo date('Y'); ?> Copyright:

    <a href="https://dewankomputer.com/"> Dewan Komputer</a>

</div>

</div>


<script type="text/javascript">

  $(document).ready(function(){

        $.ajax({

            type: 'POST',

            url: "get_provinsi.php",

            cache: false, 

            success: function(msg){

              $("#provinsi").html(msg);

            }

        });

 

        $("#provinsi").change(function(){

        var provinsi = $("#provinsi").val();

            $.ajax({

              type: 'POST',

                url: "get_kabupaten.php",

                data: {provinsi: provinsi},

                cache: false,

                success: function(msg){

                  $("#kabupaten").html(msg);

                }

            });

        });

 

        $("#kabupaten").change(function(){

        var kabupaten = $("#kabupaten").val();

            $.ajax({

              type: 'POST',

                url: "get_kecamatan.php",

                data: {kabupaten: kabupaten},

                cache: false,

                success: function(msg){

                  $("#kecamatan").html(msg);

                }

            });

        });

 

        $("#kecamatan").change(function(){

        var kecamatan = $("#kecamatan").val();

            $.ajax({

              type: 'POST',

                url: "get_kelurahan.php",

                data: {kecamatan: kecamatan},

                cache: false,

                success: function(msg){

                  $("#kelurahan").html(msg);

                }

            });

        });

     });

</script>

Membuat Get Provinsi

<?php

include 'koneksi.php';

echo "<option value=''>Pilih Provinsi</option>";

$koneksi = mysqli_connect("localhost","root","","feeder-importer-master");

          $query = "SELECT * FROM data_wilayah WHERE id_level_wil = '1' ORDER BY id DESC";

          $tampil_select_prov = mysqli_query($koneksi, $query); ?>


          <?php while( $tampil_prov = mysqli_fetch_assoc($tampil_select_prov)) {

          echo "<option value='" . $tampil_prov['id_wil'] . "'>" . $tampil_prov['nm_wil'] . "</option>"; }


?>

 

Membuat get Kabupaten

<?php

include 'koneksi.php';

$provinsi = $_POST['provinsi'];

echo "<option value=''>Pilih Kabupaten</option>";

echo "$provinsi";

$query = "SELECT * FROM data_wilayah WHERE id_induk_wilayah = '$provinsi' ORDER BY id DESC";

$tampil_select_prov = mysqli_query($koneksi, $query);

?>

<?php while( $tampil_prov = mysqli_fetch_assoc($tampil_select_prov)) : ?>

<option value="<?=$tampil_prov['id_wil']?>" ><?php echo $tampil_prov['nm_wil'] ?></option>

<?php endwhile ?>

Membuat Get Kecamatan

<?php

include 'koneksi.php';

$kecamatan = $_POST['kabupaten'];

echo "<option value=''>Pilih Kecamatan</option>";

echo "$provinsi";

$query = "SELECT * FROM data_wilayah WHERE id_induk_wilayah = '$kecamatan' ORDER BY id DESC";

$tampil_select_prov = mysqli_query($koneksi, $query);

?>

<?php while( $tampil_prov = mysqli_fetch_assoc($tampil_select_prov)) : ?>

<option value="<?=$tampil_prov['id_wil']?>" ><?php echo $tampil_prov['nm_wil'] ?></option>

<?php endwhile ?>

1 komentar:

mamang mengatakan...

Makasih kak informasinya ...
mampir ke blog saya ya kak :
Ide usaha yang menjanjikan di tahun 2020

Posting Komentar

"Terimakasih telah berkunjung ke blog kami, semoga anda dapat menemukan apa yang anda cari. Mohon untuk menambahkan komentar!"

SEARCH

RECENT POSTS

Loading posts...

CATEGORIES

TAG CLOUD

Loading tags...