blob: f4dff7979fc2b40c5f5b7c270c343386c6132736 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
<?php
declare(strict_types=1);
// PDO singleton for MariaDB connections.
namespace App;
class Database
{
private static ?Database $instance = null;
private \PDO $pdo;
private function __construct()
{
$host = getenv('MYSQL_HOST') ?: 'mariadb';
$db = getenv('MYSQL_DATABASE');
$user = getenv('MYSQL_USER');
$pass = getenv('MYSQL_PASSWORD');
$this->pdo = new \PDO(
"mysql:host=$host;dbname=$db;charset=utf8mb4",
$user,
$pass,
[
\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
\PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
\PDO::ATTR_EMULATE_PREPARES => false,
]
);
}
public static function getInstance(): self
{
if (self::$instance === null) {
self::$instance = new self();
}
return self::$instance;
}
public function getPdo(): \PDO
{
return $this->pdo;
}
}
|