Guest User

Untitled

a guest
Oct 17th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.01 KB | None | 0 0
  1.         static function enum_options($object_or_class_name,$column_name){
  2.             $object_class_name = is_object($object_or_class_name) ? get_class($object_or_class_name) : (is_string($object_or_class_name) ? $object_or_class_name :null);
  3.             $object_table_name = strtolower(Inflector::pluralize($object_class_name));
  4.             $ar = new $object_class_name;
  5.            
  6.             /*
  7.              * SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '$table' AND COLUMN_NAME = '$field' LIMIT 1
  8.              */
  9.            
  10.             $sql= "SHOW COLUMNS FROM `{$object_table_name}` LIKE '{$column_name}'";
  11.             $sql= "SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{$object_table_name}' AND COLUMN_NAME = '{$column_name}' LIMIT 1";
  12.             $response = $ar->simple_query($sql);
  13.             //mail("westonbradfordwatson@gmail.com","{$object_class_name}",print_r($response,true));
  14.             return array($sql,$response);
  15.                    
  16.         }
Add Comment
Please, Sign In to add comment