I'm trying to close the connection in my class and I wonder if it is correct.
My public function disconnect(); close connection.
Class Connection:
<?php
class Connection{
private static $instance;
public static function getInstance(){
if (!isset(self::$instance)) {
try {
self::$instance = new PDO(DB_DRIVE . ':host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS);
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
self::$instance->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
} catch (PDOException $exception) {
echo $exception->getMessage();
}
}
return self::$instance;
}
public static function prepare($sql){
return self::getInstance()->prepare($sql);
}
public static function lastInsertId($sql){
return self::getInstance()->lastInsertId($sql);
}
public function disconnect(){
return self::$instance = null;
}
}
I use so in my script after execution:
<?php
$connectionDb = new Connection();
$connectionDb->disconnect();
Is correct?
