32 lines
890 B
PHP
32 lines
890 B
PHP
<?php
|
|
// config/database.php
|
|
class Database {
|
|
private static $instance = null;
|
|
private $connection;
|
|
|
|
private function __construct() {
|
|
try {
|
|
$this->connection = new PDO(
|
|
"pgsql:host=localhost;dbname=aeterna_db;",
|
|
"postgres",
|
|
"1234"
|
|
);
|
|
$this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
$this->connection->exec("SET NAMES 'utf8'");
|
|
} catch(PDOException $e) {
|
|
die("Ошибка подключения: " . $e->getMessage());
|
|
}
|
|
}
|
|
|
|
public static function getInstance() {
|
|
if (self::$instance == null) {
|
|
self::$instance = new Database();
|
|
}
|
|
return self::$instance;
|
|
}
|
|
|
|
public function getConnection() {
|
|
return $this->connection;
|
|
}
|
|
}
|
|
?>
|