/** * 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; }
/** * 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; }