Returns a PDO Connection
public getConnection ( ) : PDO | ||
Результат | PDO |
/** * Set up the test database table. * * @param PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection $connection */ protected function setUpTable($connection) { $pdo = $connection->getConnection(); $sql = 'CREATE TABLE IF NOT EXISTS simple_table ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, address VARCHAR(100) )'; $pdo->exec($sql); $sql = 'CREATE TABLE IF NOT EXISTS books_array ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, book_id VARCHAR(50) NOT NULL, info TEXT NOT NULL )'; $pdo->exec($sql); $sql = 'CREATE TABLE IF NOT EXISTS books_columns ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, author VARCHAR(100) NOT NULL, title VARCHAR(100) NOT NULL, genre VARCHAR(100) NOT NULL, price VARCHAR(50) NOT NULL, publish_date VARCHAR(50) NOT NULL, description TEXT NOT NULL )'; $pdo->exec($sql); }
protected function getConnection() { if ($this->conn === null) { if (self::$pdo == null) { self::$pdo = new \PDO($GLOBALS['DB_DSN'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD']); } $this->conn = $this->createDefaultDBConnection(self::$pdo, $GLOBALS['DB_DBNAME']); $this->conn->getConnection()->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_SILENT); } return $this->conn; }