Untitled

<html>
<head>
<title></title>
</head>

<body>
 <?php
//koneksi ke database
        $host = "localhost";
		$username = "root";
		$password = "";
		$nama_db = "1084_db";

		$koneksi_db = mysqli_connect($host,$username,$password,$nama_db) or die (mysqli_error());
        ?>
<form method="post">
	<table>
            <tr>
            <td>Provinsi</td>
            <td>:</td>
            <td>
            <!--province-->
            <select id="province" name="province">
                <option value="">Please Select</option>
                <?php
                $query = "SELECT * FROM province ORDER BY province_name";
				$hasil_query = mysqli_query($koneksi_db,$query);
                while ($row = mysqli_fetch_array($hasil_query))
				{
                ?>
                    <option value="<?php echo $row['province_id']; ?>">
                        <?php echo $row['province_name']; ?>
                    </option>
                <?php
                }
                ?>
            </select>
            </td>
            </tr>

            <tr>
            <td>Wilayah</td>
            <td>:</td>
            <td>
            <!--region-->
            <select id="region" name="region">
                <option value="">Please Select</option>
                <?php
                $query = "SELECT * FROM region
				INNER JOIN province ON region.province_id_fk = province.provice_id ORDER BY region_name";
				$hasil_query = mysqli_query($koneksi_db,$query);
                while ($row = mysqli_fetch_array($hasil_query))
				{
                ?>
                    <option id="kota" class="<?php echo $row['province_id']; ?>" value="<?php echo $row['region_id']; ?>">
                        <?php echo $row['region_name']; ?>
                    </option>
                <?php
                }
                ?>
            </select>
            </td>
            </tr>

 			<tr>
            <td>Kecamatan</td>
            <td>:</td>
            <td>
            <!--distric-->
            <select id="distric" name="distric">
                <option value="">Please Select</option>
                <?php
                $query = "SELECT * FROM distric
				LEFT JOIN region ON distric.region_id_fk = region.region_id ORDER BY district_name";
				$hasil_query = mysqli_query($koneksi_db,$query);
                while ($row = mysqli_fetch_array($hasil_query))
				{
                ?>
                    <option id="kecamatan" class="<?php echo $row['region_id']; ?>" value="<?php echo $row['district_id']; ?>">
                        <?php echo $row['district_name']; ?>
                    </option>
                <?php
                }
                ?>
            </select>
            </td>
            </tr>

            <tr>
            <td><input type="submit" value="SIMPAN"></td>
            </tr>

	</table>
</form>

        <script src="jquery-1.10.2.min.js"></script>
        <script src="jquery.chained.min.js"></script>
        <script>
            $("#region").chained("#province");
            $("#distric").chained("#region");
        </script>

</body>
</html>