Membuat Form Otomatis

coba main ke http://harviacode.com/2014/09/20/membuat-dropdown-berantai/

http://harviacode.com/2014/09/20/membuat-dropdown-berantai/

Mungkin maksud agan seperti ini ya.

TABEL PROPINSI
id_propinsi              nama_propinsi
---------------------------------------
PR001                    Jawa Barat
PR002                    Jawa Tengah
PR003                    Jawa Timur

TABEL KOTA
id_kota              nama_kota       id_propinsi
---------------------------------------
KT001                Bandung         PR001
KT002                Bogor           PR001
KT003                Cirebon         PR001
KT004                Semarang        PR002
KT005                Malang          PR003

 <?php
$link = mysqli_connect('localhost', 'username', 'password','nama_db');
if (!$link) {
    die('Not connected : ' . mysql_error());
}
?>
<script language="JavaScript" type="text/JavaScript">

 function show_kota()
 {
 <?php

 $query = "SELECT * FROM propinsi ORDER BY id_propinsi";
 $hasil = mysqli_query($link, $query);

 while ($data = mysqli_fetch_array($hasil))
 {
   $id_propinsi = $data['id_propinsi'];

   echo "if (document.demo.id_propinsi.value == \"".$id_propinsi."\")";
   echo "{";

   $query2 = "SELECT * FROM kota WHERE id_propinsi = '$id_propinsi' ORDER BY id_propinsi";
   $hasil2 = mysqli_query($link, $query2);
   $content = "document.getElementById('id_kota').innerHTML = \"";
   while ($data2 = mysqli_fetch_array($hasil2))
   {
       $content .= "<option value='".$data2['id_kota']."'>".$data2['nama_kota']."</option>";
   }
   $content .= "\"";
   echo $content;
   echo "}\n";
 }

 ?>

 }
</script>
<form action="" method="post" name="demo">
  Propinsi :			<select name="id_propinsi" onChange="show_kota()" tabindex="3">
						<?php
						  $result=mysqli_query($link, "select * from propinsi order by id_propinsi");
						  echo '<option></option>';
						  while($data = mysqli_fetch_array($result)){
						   echo '<option value="'.$data['id_propinsi'].'">'.$data['nama_propinsi'].'</option>';
						  }
						?>
					</select>	<br/><br/>
	Kota :		<select name="id_kota" id="id_kota" tabindex="4">
					<option>-- pilih --</option>
					</select>

    <input type="submit" value="Simpan" /><input type='hidden' name='submitted' />
</form>

<?php
if (isset($_POST['submitted'])) {

    $id_propinsi = $_POST['id_propinsi'];
    $id_kota = $_POST['id_kota'];

       $rsl = mysqli_fetch_array( mysqli_query($link, "select * from propinsi,kota where kota.id_propinsi = propinsi.id_propinsi AND
                                                        propinsi.id_propinsi = '$id_propinsi' AND
                                                        id_kota = '$id_kota' "));


    echo "Propinsi : ".$rsl['nama_propinsi']."<br/>";
    echo "Kota : ".$rsl['nama_kota']."<br/>";

}

?>

Happy Coding ^0^

Terimakasih semua ya. Sangat membantu