private function getFieldsListFromDatabase() { $Connection = Connection::getConnection(); $request = $Connection->prepare("SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA LIKE ? AND TABLE_NAME LIKE ?"); $request->execute([Connection::getDatabaseName(), $this->_tableName]); $array = []; foreach ($request->fetchAll() as $k => $v) { $array[] = $v['COLUMN_NAME']; } return $array; }
public static function query($sql, $params = []) { $Connection = Connection::getConnection(); $request = $Connection->prepare($sql); if ($request->execute($params)) { $Logger = new Logger(dirname(dirname(__DIR__)) . '/access.log'); $Logger->add($sql); } else { $errorInfo = $request->errorInfo(); $Logger = new Logger(dirname(dirname(__DIR__)) . '/error.log'); $Logger->add($sql . ' | ' . $errorInfo[2]); } return $request->fetchAll(); }
/** * Establish connection * * @param $connection Connection connection params */ public static function establishConnection(Connection $connection) { static::$connection = $connection->getInstance(); }