Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title></title>
- </head>
- <body>
- <?php
- //koneksi ke database
- $host = "localhost";
- $username = "root";
- $password = "";
- $nama_db = "1084_db";
- $koneksi_db = mysqli_connect($host,$username,$password,$nama_db) or die (mysqli_error());
- ?>
- <form method="post">
- <table>
- <tr>
- <td>Provinsi</td>
- <td>:</td>
- <td>
- <!--province-->
- <select id="province" name="province">
- <option value="">Please Select</option>
- <?php
- $query = "SELECT * FROM province ORDER BY province_name";
- $hasil_query = mysqli_query($koneksi_db,$query);
- while ($row = mysqli_fetch_array($hasil_query))
- {
- ?>
- <option value="<?php echo $row['province_id']; ?>">
- <?php echo $row['province_name']; ?>
- </option>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td>Wilayah</td>
- <td>:</td>
- <td>
- <!--region-->
- <select id="region" name="region">
- <option value="">Please Select</option>
- <?php
- $query = "SELECT * FROM region
- INNER JOIN province ON region.province_id_fk = province.provice_id ORDER BY region_name";
- $hasil_query = mysqli_query($koneksi_db,$query);
- while ($row = mysqli_fetch_array($hasil_query))
- {
- ?>
- <option id="kota" class="<?php echo $row['province_id']; ?>" value="<?php echo $row['region_id']; ?>">
- <?php echo $row['region_name']; ?>
- </option>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td>Kecamatan</td>
- <td>:</td>
- <td>
- <!--distric-->
- <select id="distric" name="distric">
- <option value="">Please Select</option>
- <?php
- $query = "SELECT * FROM distric
- LEFT JOIN region ON distric.region_id_fk = region.region_id ORDER BY district_name";
- $hasil_query = mysqli_query($koneksi_db,$query);
- while ($row = mysqli_fetch_array($hasil_query))
- {
- ?>
- <option id="kecamatan" class="<?php echo $row['region_id']; ?>" value="<?php echo $row['district_id']; ?>">
- <?php echo $row['district_name']; ?>
- </option>
- <?php
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td><input type="submit" value="SIMPAN"></td>
- </tr>
- </table>
- </form>
- <script src="jquery-1.10.2.min.js"></script>
- <script src="jquery.chained.min.js"></script>
- <script>
- $("#region").chained("#province");
- $("#distric").chained("#region");
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement