Edit Question - KnowledgeHub

Title Body

Below is the db connection class I came out with so far, but I am going to improve it by extending the PDO class itself, <?php class database { protected $connection = null; #make a connection public function __construct($hostname,$dbname,$username,$password) { try { # MySQL with PDO_MYSQL $this->connection = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password); $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { $this->connection = null; die($e->getMessage()); } } #get the number of rows in a result public function num_rows($query) { # create a prepared statement $stmt = $this->connection->prepare($query); if($stmt) { # execute query $stmt->execute(); return $stmt->rowCount(); } else { return self::get_error(); } } #display error public function get_error() { $this->connection->errorInfo(); } # closes the database connection when object is destroyed. public function __destruct() { $this->connection = null; } } ?> extended class, class database extends PDO { #make a connection public function __construct($hostname,$dbname,$username,$password) { parent::__construct($hostname,$dbname,$username,$password); try { $this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die($e->getMessage()); } } #get the number of rows in a result public function num_rows($query) { # create a prepared statement $stmt = parent::prepare($query);

Tags (comma-separated) Cancel