Пример #1
0
 /**
  * Build and return the fields of a table.
  *
  * @param SimpleCrud $db
  * @param string     $table
  *
  * @return array
  */
 public static function getFields(SimpleCrud $db, $table)
 {
     $result = $db->execute("pragma table_info(`{$table}`)")->fetchAll(PDO::FETCH_ASSOC);
     $fields = [];
     foreach ($result as $field) {
         $fields[$field['name']] = strtolower($field['type']);
     }
     return $fields;
 }
Пример #2
0
 /**
  * Build and return the fields of a table.
  *
  * @param SimpleCrud $db
  * @param string     $table
  *
  * @return array
  */
 public static function getFields(SimpleCrud $db, $table)
 {
     $result = $db->execute("DESCRIBE `{$table}`")->fetchAll(PDO::FETCH_ASSOC);
     $fields = [];
     foreach ($result as $field) {
         preg_match('#^(\\w+)#', $field['Type'], $matches);
         $fields[$field['Field']] = $matches[1];
     }
     return $fields;
 }