} // Подключение к БД public function Connect() { if (!isset(self::$settings['options'])) { self::$settings['options'] = null; } $connectstring = self::setConnectString(); $connect = new PDO($connectstring, self::$settings['user'], self::$settings['password'], self::$settings['options']); self::$connect = $connect; //self::$version = self::getVersion(); //$this->Databases = $this->getDatabases(); return self::$connect; } public function listTables() { $sth = self::$connect->query('SHOW TABLES;'); $result = array(); foreach ($sth->fetchAll() as $row) { $result[] = $row[0]; } return $result; } } $settings = array('host' => '', 'user' => '9', 'password' => 'EoCVr', 'database' => 'db9m', 'type' => 'mysql'); //$dns = "mysql:host=dbhe23.hoster.ru;dbname=db81799m"; //$connect = new PDO($dns, 'm81799', // 'EoXYnCVr', $settings['options']); print_r(Database::setConnectString()); $connect = Database::getConnect($settings); print_r($connect->listTables());
public function getConnect() { $this->_connect = Database::getConnect(); }
/** * Build the connection string from input. * @param array $parameters The connection details. * @return string $connect The connection string. **/ public function getConnect($parameters) { return DB::$globalConn->getConnect($parameters); }