/** * @description connect the database * @param null * @return an object of the PDO */ public function connect() { $config = new DbConfig(); try { $pdo = new PDO($config->getDBNameHost(), $config->getDBUsr(), $config->getDBPwd()); // set attributes of the PDO $pdo->setAttribute(PDO::ATTR_AUTOCOMMIT, false); $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); $pdo->query("set names utf8"); echo date("Y-m-d h:i:s") . " :connect to database successfully...<br>"; return $pdo; } catch (PDOException $e) { echo date("Y-m-d h:i:s") . " :Could not connect to the database:<br>.{$e}"; } }