Advertisement
freddy0512

Untitled

Jul 15th, 2013
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. <script language='javascript'>
  2.  
  3. function showKab()
  4.  
  5. {
  6.  
  7. <?php
  8.  
  9. include "koneksi.php";
  10.  
  11.  
  12. // membaca semua propinsi
  13.  
  14. $query = "SELECT * FROM tabel_fakultas ORDER BY id ASC";
  15.  
  16. $hasil = mysql_query($query);
  17.  
  18. // membuat if untuk masing-masing pilihan propinsi beserta isi option untuk combobox kedua
  19.  
  20. while ($data = mysql_fetch_array($hasil))
  21.  
  22. {
  23.  
  24. $prov = $data['id'];
  25.  
  26. // membuat IF untuk masing-masing propinsi
  27.  
  28. echo "if (document.form1.fakultas.value == \"".$prov."\")";
  29.  
  30. echo "{";
  31.  
  32. // membuat option kota untuk masing-masing propinsi
  33.  
  34. $query2 = "SELECT a.id_jurusan, a.jurusan, b.id from tabel_jurusan a, tabel_fakultas b WHERE a.id = '$prov' and a.id=b.id ORDER BY id_jurusan ASC";
  35.  
  36. $hasil2 = mysql_query($query2);
  37.  
  38. $content = "document.getElementById('jurusan').innerHTML = \"";
  39.  
  40. while ($data2 = mysql_fetch_array($hasil2))
  41.  
  42. {
  43.  
  44. $content .= "<option value='".$data2['id_jurusan']."'>".$data2['jurusan']."</option>";
  45.  
  46. }
  47.  
  48. $content .= "\"";
  49.  
  50. echo $content;
  51.  
  52. echo "}\n";
  53.  
  54. }
  55.  
  56. ?>
  57.  
  58. }
  59.  
  60. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement