Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //provinsi
- function provinsi($name, $table, $field, $pk, $selected) {
- $ci = get_instance();
- $cmb = "<select name='$name' class='form-control'>";
- $data = $ci->db->query("SELECT *FROM $table GROUP BY NAME ASC")->result();
- foreach ($data as $d) {
- $cmb .="<option value='" . $d->$pk . "'";
- $cmb .= $selected == $d->$pk ? " selected='selected'" : '';
- $cmb .=">" . strtoupper($d->$field) . "</option>";
- }
- $cmb .="</select>";
- return $cmb;
- }
- //kabupaten
- function kabupaten($name, $table, $field, $pk, $selected) {
- $ci = get_instance();
- $cmb = "<select name='$name' class='form-control'>";
- $data = $ci->db->query("SELECT regencies.name FROM regencies, provinces WHERE regencies.province_id=provinces.id AND province_id=provinsi($selected)")->result();
- foreach ($data as $d) {
- $cmb .="<option value='" . $d->$pk . "'";
- $cmb .= $selected == $d->$pk ? " selected='selected'" : '';
- $cmb .=">" . strtoupper($d->$field) . "</option>";
- }
- $cmb .="</select>";
- return $cmb;
- }
Add Comment
Please, Sign In to add comment