1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
class DbConnect extends PDO{
private static $instance = false;
public static function getInstance(){
if(!self::$instance){
throw new Exception("PDO instance not initialized");
}else{
return self::$instance;
}
}
public static function connect($dsn = "mysql:host=localhost;dbname=cambodge;charset=utf8", $username = "*****", $passwd = "*****"){
self::$instance = new PDO($dsn, $username, $passwd);
self::$instance->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND,'SET NAMES UTF8');
self::$instance->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);
self::$instance->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
self::$instance->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ);
self::$instance->setAttribute(PDO::ATTR_PERSISTENT,TRUE);
return self::$instance;
}
}
$db = DbConnect::connect(); |
Partager