define('DB_LOCALUSER', 'root');
define('DB_LOCALDATABASE', 'db');
define('DB_LOCALPWD', 's3cret');
define('DB_LOCALPORT', '3306');
class DatabaseController
{
private static $db;
public static function getDb()
{
try {
self::$db = new PDO('mysql:host=' . DB_LOCALHOST . ';port=' . DB_LOCALPORT . ';dbname=' . DB_LOCALDATABASE, DB_LOCALUSER, DB_LOCALPWD, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => false));
self::$db->exec("set names utf8");
return self::$db;
} catch (PDOException $e) {
header('HTTP/1.1 500 Internal Server Error');
die(json_encode(array('code' => '500', 'error' => $e->getMessage())));
}
}
public static function closeConn()
{
try {
self::$db = null;
} catch (Exception $e) {
header('HTTP/1.1 500 Internal Server Error');
die(json_encode(array('code' => '500', 'error' => $e->getMessage())));
}
}
}
$connexion = DatabaseController::getDb();
echo "<h1>Connection to Database successful</h1>";
phpinfo();
