Example #1
0
    }
    // Подключение к БД
    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());
Example #2
0
 public function getConnect()
 {
     $this->_connect = Database::getConnect();
 }
Example #3
0
 /**
  * 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);
 }