· 9 years ago · Feb 09, 2017, 04:36 PM
1/* ----CONTOH DATA
2
3DROP TABLE IF EXISTS fakultas;
4CREATE TABLE IF NOT EXISTS fakultas(
5 id INT AUTO_INCREMENT PRIMARY KEY,
6 nama VARCHAR(50)
7);
8
9INSERT INTO fakultas(nama)
10VALUES
11('Tehnik'),
12('Ilmu Komputer'),
13('Ekonomi');
14
15DROP TABLE IF EXISTS jurusan;
16CREATE TABLE IF NOT EXISTS jurusan(
17 id INT AUTO_INCREMENT PRIMARY KEY,
18 id_fakultas INT,
19 nama VARCHAR(50)
20);
21
22INSERT INTO jurusan(id_fakultas,nama)
23VALUES
24(1,'Elektro'),
25(1,'Mesin'),
26(1,'Sipil'),
27(2,'Sistem Informatika'),
28(2,'Tehnik Informatika'),
29(3,'Akuntansi'),
30(3,'Manajemen');
31
32DROP TABLE IF EXISTS konsentrasi;
33CREATE TABLE IF NOT EXISTS konsentrasi(
34 id INT AUTO_INCREMENT PRIMARY KEY,
35 id_jurusan INT,
36 nama VARCHAR(50)
37);
38
39INSERT INTO konsentrasi(id_jurusan,nama)
40VALUES
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
123if(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
136if(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}