|
|
<?php |
|
|
|
|
|
|
|
|
class Database { |
|
|
private $host = "127.0.0.1"; |
|
|
private $db_name = "jmdb"; |
|
|
private $username = "root"; |
|
|
private $password = "YourStrongPassword123"; |
|
|
public $conn; |
|
|
|
|
|
public function getConnection() { |
|
|
$this->conn = null; |
|
|
|
|
|
try { |
|
|
$this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password); |
|
|
$this->conn->exec("set names utf8"); |
|
|
$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
|
|
} catch(PDOException $exception) { |
|
|
echo "Connection error: " . $exception->getMessage(); |
|
|
} |
|
|
|
|
|
return $this->conn; |
|
|
} |
|
|
} |
|
|
?> |