API tools faq
paste
Advertisement
cdsatrian

Chained Combobox Fak-Jur-Konsentrasi

cdsatrian
Feb 9th, 2017
247
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.38 KB | None | 0 0
raw download clone embed print report
  1. /* ----CONTOH DATA
  2.  
  3. DROP TABLE IF EXISTS fakultas;
  4. CREATE TABLE IF NOT EXISTS fakultas(
  5.     id INT AUTO_INCREMENT PRIMARY KEY,
  6.     nama VARCHAR(50)
  7. );
  8.  
  9. INSERT INTO fakultas(nama)
  10. VALUES
  11. ('Tehnik'),
  12. ('Ilmu Komputer'),
  13. ('Ekonomi');
  14.  
  15. DROP TABLE IF EXISTS jurusan;
  16. CREATE TABLE IF NOT EXISTS jurusan(
  17.     id INT AUTO_INCREMENT PRIMARY KEY,
  18.     id_fakultas INT,
  19.     nama VARCHAR(50)
  20. );
  21.  
  22. INSERT INTO jurusan(id_fakultas,nama)
  23. VALUES
  24. (1,'Elektro'),
  25. (1,'Mesin'),
  26. (1,'Sipil'),
  27. (2,'Sistem Informatika'),
  28. (2,'Tehnik Informatika'),
  29. (3,'Akuntansi'),
  30. (3,'Manajemen');
  31.  
  32. DROP TABLE IF EXISTS konsentrasi;
  33. CREATE TABLE IF NOT EXISTS konsentrasi(
  34.     id INT AUTO_INCREMENT PRIMARY KEY,
  35.     id_jurusan INT,
  36.     nama VARCHAR(50)
  37. );
  38.  
  39. INSERT INTO konsentrasi(id_jurusan,nama)
  40. VALUES
  41. (1,'Arus Kuat'),
  42. (1,'Instrumentasi'),
  43. (1,'Telekomunikasi'),
  44. (2,'Industri'),
  45. (2,'Kendaraan'),
  46. (3,'Jalan Raya'),
  47. (3,'Pengairan'),
  48. (4,'Sistem Informasi Korporat'),
  49. (4,'E-Business'),
  50. (5,'Sistem Kecerdasan'),
  51. (5,'Sistem Perangkat Lunak'),
  52. (6,'Keuangan'),
  53. (6,'Auditing'),
  54. (6,'Manajerial'),
  55. (7,'Pemasaran'),
  56. (7,'Sumber Daya Manusia');
  57. */
  58.  
  59. //-- FILE : koneksi.php
  60. <?php
  61. $dbhost='localhost';
  62. $dbuser='root';
  63. $dbpass='';
  64. $dbname='test';
  65. $db=new mysqli($dbhost,$dbuser,$dbpass,$dbname);
  66.  
  67. //-- FILE : fakultas.php
  68. <!DOCTYPE html>
  69. <html>
  70.     <head>
  71.         <title>Latihan AJaX</title>
  72.     </head>
  73.     <body>
  74.         <form>
  75.             Fakultas
  76.             <select id='fakultas' name='fakultas'>
  77.                 <option value=''>--pilih fakultas --</option>
  78.                 <?php
  79.                 include 'koneksi.php';
  80.                 $sql='SELECT id,nama FROM fakultas ORDER BY nama';
  81.                 $result=$db->query($sql);
  82.                 while($row=$result->fetch_object()){
  83.                     echo "<option value='{$row->id}'>{$row->nama}</option>";
  84.                 }
  85.                 ?>
  86.             </select>
  87.             jurusan <select id='jurusan' name='jurusan'><option value=''>--pilih jurusan --</option></select>
  88.             konsentrasi <select id='konsentrasi' name='konsentrasi'><option value=''>--pilih konsentrasi --</option></select><br>
  89.             <input type='submit' value='kirim'>
  90.         </form>
  91.     </body>
  92.     <script
  93.         src="https://code.jquery.com/jquery-1.12.4.min.js"
  94.         integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ="
  95.         crossorigin="anonymous">
  96.     </script>
  97.     <script>
  98.     $(document).ready(function(){
  99.         $('#fakultas').change(function(){
  100.             $.post(
  101.                 'jurusan_ajax.php',
  102.                 {'fakultas':$(this).val()},
  103.                 function(data){
  104.                     $('#jurusan').html(data);
  105.                 }
  106.             );
  107.         });
  108.         $('#jurusan').change(function(){
  109.             $.post(
  110.                 'konsentrasi_ajax.php',
  111.                 {'jurusan':$(this).val()},
  112.                 function(data){
  113.                     $('#konsentrasi').html(data);
  114.                 }
  115.             );
  116.         });
  117.     });
  118.     </script>
  119. </html>
  120.  
  121. //-- FILE : jurusan_ajax.php
  122. <?php
  123. if(isset($_POST['fakultas'])){
  124.     $hasil="<option value=''>--pilih jurusan--</option>";
  125.     include 'koneksi.php';
  126.     $sql="SELECT id,nama FROM jurusan WHERE id_fakultas={$_POST['fakultas']} ORDER BY nama";
  127.     $result=$db->query($sql);
  128.     while($row=$result->fetch_object()){
  129.         $hasil.="<option value='{$row->id}'>{$row->nama}</option>";
  130.     }
  131.     echo $hasil;
  132. }
  133.  
  134. //-- FILE : konsentrasi_ajax.php
  135. <?php
  136. if(isset($_POST['jurusan'])){
  137.     $hasil="<option value=''>--pilih konsentrasi--</option>";
  138.     include 'koneksi.php';
  139.     $sql="SELECT id,nama FROM konsentrasi WHERE id_jurusan={$_POST['jurusan']} ORDER BY nama";
  140.     $result=$db->query($sql);
  141.     while($row=$result->fetch_object()){
  142.         $hasil.="<option value='{$row->id}'>{$row->nama}</option>";
  143.     }
  144.     echo $hasil;
  145. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!