blob: 3308e4cbd55628b28435dd7df8098d3097e6e28f (
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
|
<?php
class Database
{
private static $instance = null;
private $sql_connection;
private function __construct()
{
$config = parse_ini_file('config.ini', true)['mysql_credentials'];
$db_server = $config['server'];
$db_user = $config['user'];
$db_pass = $config['password'];
$db_database = $config['database'];
$this->sql_connection = mysqli_connect($db_server, $db_user, $db_pass, $db_database);
if (!$this->sql_connection) {
trigger_error("Database connection error: " . mysqli_connect_error());
}
}
public static function get(): ?Database
{
if (self::$instance == null) {
self::$instance = new Database();
}
return self::$instance;
}
public function query(string $sql)
{
mysqli_query($this->sql_connection, $sql);
}
}
|
