aries_

multi combo

May 22nd, 2012
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.85 KB | None | 0 0
  1. <html>
  2. <head>
  3.  
  4. <script language="JavaScript" type="text/JavaScript">
  5.  
  6.  function showstream()
  7.  {
  8.  <?php
  9.  
  10.  // membaca semua stream
  11.  $query = "SELECT * FROM STREAM";
  12.  $hasil = mysql_query($query);
  13.  
  14.  // membuat if untuk masing-masing pilihan stream beserta isi option untuk combobox kedua
  15.  while ($data = mysql_fetch_array($hasil))
  16.  {
  17.    $stream = $data['STREAM'];
  18.  
  19.    // membuat IF untuk masing-masing stream
  20.    echo "if (document.pkl_telkom.materi_training.value == \"".$stream."\")";
  21.    echo "{";
  22.  
  23.    // membuat option materi untuk masing-masing stream
  24.    $query2 = "SELECT * FROM materi_training WHERE STREAM = $stream";
  25.    $hasil2 = mysql_query($query2);
  26.    $content = "document.getElementById('M_TRAINING').innerHTML = \"";
  27.    while ($data2 = mysql_fetch_array($hasil2))
  28.    {
  29.        $content .= "<option value='".$data2['Kode_M']."'>".$data2['NAMA_M_TRAINING']."</option>";
  30.    }
  31.    $content .= "\"";
  32.    echo $content;
  33.    echo "}\n";
  34.  }
  35.  
  36.  ?>
  37.  }
  38. </script>
  39.  
  40. </head>
  41. <body>
  42. <h1>Demo</h1>
  43. <form name="demo"  method="post"  action="submit.php">
  44. <table>
  45. <tr><td>Pilih Stream</td><td>:</td>
  46.       <td>
  47.           <select name="stream" onchange="showstream()">
  48.           <option>Silakan Pilih</option>
  49.           <option>------------------------</option>
  50.           <?php
  51.                  // query untuk menampilkan propinsi
  52.                  $query = "SELECT * FROM STREAM";
  53.                  $hasil = mysql_query($query);
  54.                  while ($data = mysql_fetch_array($hasil))
  55.                  {
  56.                     echo "<option value='".$data['STREAM']."'>".$data['STREAM']."</option>";
  57.                  }
  58.           ?>
  59.           </select>
  60.       </td>  
  61. </tr>
  62. <tr><td>Pilih Materi</td><td>:</td>
  63.       <td>
  64.       <select name="materi" id="M_TRAINING">
  65.       </select>
  66.       </td>    
  67. </tr>
  68. </table>
  69. </form>
  70. </body>
  71. </html>
Advertisement
Add Comment
Please, Sign In to add comment