Advertisement
Be0wulf

Mysql Class

Oct 3rd, 2012
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.30 KB | None | 0 0
  1. <?php
  2.  
  3. require_once 'constants.php';
  4.  
  5. /**
  6.  * Description of Mysql
  7.  *
  8.  * @author Administrateur
  9.  */
  10. class Mysql extends PDO {
  11.  
  12.     private $con;
  13.  
  14.     public function __construct() {
  15.         try {
  16.  
  17.             $this->con = parent::__construct(DB_DSN, DB_USER, DB_PASS);
  18.  
  19.             if ($this->getAttribute(PDO::ATTR_DRIVER_NAME) == DB_TYPE)
  20.                
  21.                 $this->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE);
  22.            
  23.  
  24.             return $this->con;
  25.            
  26.         } catch (PDOException $e) {
  27.  
  28.             die('Error:' . $e->getMessage());
  29.         }
  30.     }
  31.  
  32.     public function select($reqSelect) {
  33.         try {
  34.             $this->con = parent::beginTransaction();
  35.             $result = parent::prepare($reqSelect);
  36.             $result->execute();
  37.  
  38.             //$this->con = parent::commit();
  39.  
  40.             $this->con = parent::rollBack();
  41.  
  42.             return $result;
  43.  
  44.             $result->closeCursor();
  45.         } catch (Exception $e) {
  46.             die('Error:' . $e->getMessage());
  47.         }
  48.     }
  49.  
  50.     public function selectAll($reqSelect) {
  51.         $result = parent::prepare($reqSelect);
  52.         $result->execute();
  53.  
  54.         $resultat = $result->fetchAll();
  55.  
  56.         return $resultat;
  57.  
  58.         $result->closeCursor();
  59.     }
  60.  
  61. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement