I am using parent::__construct() in almost every classes to connect Mysql DB.
Example class
class secondClass extends dbconnect
{
public function __construct() {
parent::__construct();
dbconnect class
class dbconnect {
private $mysqli_handler;
public function __construct() {
try {
mysqli_report(MYSQLI_REPORT_STRICT);
$this->mysqli_handler = mysqli_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DBNAME);
} catch (mysqli_sql_exception $e) {
throw new Exception('Error: Could not make a database link using ' . DB_USERNAME . '@' . DB_HOSTNAME . '!');
}
if ($this->mysqli_handler->connect_error) {
trigger_error('Error: Could not make a database link (' . $this->mysqli_handler->connect_errno . ') ' . $this->mysqli_handler->connect_error);
}
$this->mysqli_handler->query("SET NAMES 'utf8'");
$this->mysqli_handler->query("SET CHARACTER SET utf8");
$this->mysqli_handler->query("SET CHARACTER_SET_CONNECTION=utf8");
$this->mysqli_handler->query("SET SQL_MODE = ''");
$this->mysqli_handler->query("SET time_zone = 'Asia/Kolkata'");
}
Is this create multiple instance of mysql dbconnection? I am frequently getting mysql connection error on my shared hosting. If so how to avoid?
I am using PHP Version 7.4.16, some detailed explanation will be useful for me as I am using like this for many projects.
Thank you for your time.
Prabakaran