Dropdown value dari Kolom Database

dropdown_value_db

# source: https://github.com/typesafer/codeigniter-enum-select-boxes
if (!function_exists('dropdownKolom')) {
  function dropdownKolom($table , $field, $all=false)
  {
      $ci = & get_instance();
      $query = "SHOW COLUMNS FROM ".$table." LIKE '$field'";
      $row = $ci->db->query("SHOW COLUMNS FROM ".$table." LIKE '$field'")->row()->Type;  
      $regex = "/'(.*?)'/";
      preg_match_all( $regex , $row, $enum_array );
      $enum_fields = $enum_array[1];
      
      foreach ($enum_fields as $key=>$value)
      {
          if ($all) {
              $enums['all'] = 'All'; 
              $enums[$value] = strtoupper($value); 
          }else{
              $enums[$value] = strtoupper($value); 
          }
      }
      return $enums;
  }
}