Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Pilihan Berantai</title>
- </head>
- <body>
- <?php
- // koneksi ke database
- mysql_connect('localhost', 'username', 'password');
- mysql_select_db('namadatabase');
- ?>
- <form method="post">
- <!--provinsi-->
- <select id="provinsi" name="provinsi">
- <option value="">Please Select</option>
- <?php
- $query = mysql_query("SELECT * FROM provinsi ORDER BY nm_prov");
- while ($row = mysql_fetch_array($query)) {
- ?>
- <option value="<?php echo $row['id_prov']; ?>">
- <?php echo $row['nm_prov']; ?>
- </option>
- <?php
- }
- ?>
- </select>
- <!--kota-->
- <select id="kota" name="kota">
- <option value="">Please Select</option>
- <?php
- $query = mysql_query("SELECT
- *
- FROM
- kota
- INNER JOIN provinsi ON kota.id_prov_fk = provinsi.id_prov ORDER BY nama_kota");
- while ($row = mysql_fetch_array($query)) {
- ?>
- <option id="kota" class="<?php echo $row['id_prov']; ?>" value="<?php echo $row['id_kota']; ?>">
- <?php echo $row['nama_kota']; ?>
- </option>
- <?php
- }
- ?>
- </select>
- </form>
- <script src="jquery-1.10.2.min.js"></script>
- <script src="jquery.chained.min.js"></script>
- <script>
- $("#kota").chained("#provinsi");
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement