sebuahhobi

Helper Prov Kab

Aug 3rd, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. //provinsi
  2. function provinsi($name, $table, $field, $pk, $selected) {
  3.     $ci = get_instance();
  4.     $cmb = "<select name='$name' class='form-control'>";
  5.     $data = $ci->db->query("SELECT *FROM $table GROUP BY NAME ASC")->result();
  6.     foreach ($data as $d) {
  7.         $cmb .="<option value='" . $d->$pk . "'";
  8.         $cmb .= $selected == $d->$pk ? " selected='selected'" : '';
  9.         $cmb .=">" . strtoupper($d->$field) . "</option>";
  10.     }
  11.     $cmb .="</select>";
  12.     return $cmb;
  13. }
  14. //kabupaten
  15. function kabupaten($name, $table, $field, $pk, $selected) {
  16.     $ci = get_instance();
  17.     $cmb = "<select name='$name' class='form-control'>";
  18.     $data = $ci->db->query("SELECT regencies.name FROM regencies, provinces WHERE regencies.province_id=provinces.id AND province_id=provinsi($selected)")->result();
  19.     foreach ($data as $d) {
  20.         $cmb .="<option value='" . $d->$pk . "'";
  21.         $cmb .= $selected == $d->$pk ? " selected='selected'" : '';
  22.         $cmb .=">" . strtoupper($d->$field) . "</option>";
  23.     }
  24.     $cmb .="</select>";
  25.     return $cmb;
  26. }
Add Comment
Please, Sign In to add comment