Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <?php
  2. include 'koneksi.php';
  3.  
  4. $kabupaten = $_POST['kabupaten'];
  5.  
  6. echo "<option value=''>Pilih Kecamatan</option>";
  7.  
  8. $query = "SELECT * FROM districts WHERE city_id=? ORDER BY dis_name ASC";
  9. $exec = $db->prepare($query);
  10. $exec->bind_param("i", $kabupaten);
  11. $exec->execute();
  12. $kecamatan = $exec->get_result();
  13.  
  14. while ($row = $kecamatan->fetch_assoc()) {
  15. echo "<option value='" . $row['dis_id'] . "'>" . $row['dis_name'] . "</option>";
  16. }
  17. ?>