Database Connection PHP using the class PDO.
<?php
class Connection{
public static $db;
private static function doConnection(){
if (!isset(self::$db)) {
try {
$host = "YOUR_HOST";
$db_name = "YOUR_DB";
$user = "YOUR_USER";
$pass = "YOUR_PASS";
self::$db = new PDO("mysql:host=$host;dbname=$db_name", $user, $pass);
self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
self::$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
}
catch (PDOException $e) {
echo "CONNECTION ERRO" . $e->getMessage();
}
}
return self::$db;
}
public static function prepare($sql){
return self::doConnection()->prepare($sql);
}
}