Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once 'constants.php';
- /**
- * Description of Mysql
- *
- * @author Administrateur
- */
- class Mysql extends PDO {
- private $con;
- public function __construct() {
- try {
- $this->con = parent::__construct(DB_DSN, DB_USER, DB_PASS);
- if ($this->getAttribute(PDO::ATTR_DRIVER_NAME) == DB_TYPE)
- $this->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE);
- return $this->con;
- } catch (PDOException $e) {
- die('Error:' . $e->getMessage());
- }
- }
- public function select($reqSelect) {
- try {
- $this->con = parent::beginTransaction();
- $result = parent::prepare($reqSelect);
- $result->execute();
- //$this->con = parent::commit();
- $this->con = parent::rollBack();
- return $result;
- $result->closeCursor();
- } catch (Exception $e) {
- die('Error:' . $e->getMessage());
- }
- }
- public function selectAll($reqSelect) {
- $result = parent::prepare($reqSelect);
- $result->execute();
- $resultat = $result->fetchAll();
- return $resultat;
- $result->closeCursor();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement