Guest User

Untitled

a guest
Jul 5th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. class MySQL_Database extends PDO {
  2.    
  3.     public function __construct($host, $user, $pass, $database) {
  4.         $user = '';
  5.         $pass = '';
  6.         $host = '';
  7.         $db   = '';
  8.  
  9.         try {
  10.             parent::__construct("mysql:host=$host;dbname=$db",$user,$pass);
  11.             parent::settAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  12.  
  13.         } catch(PDOException $e) {
  14.                 echo $dbError;  
  15.                 file_put_contents($error, $e->getMessage() . "\n", FILE_APPEND);    
  16.         }
  17.  
  18.     }
  19.  
  20.     public function dbQuery($query, $sqlValues) {
  21.         $qry = $this->prepare($query);
  22.         $qry->execute($sqlValues);
  23.     }
  24.  
  25.     public function getArray($query) {
  26.         $asd = $this->dbQuery($query); 
  27.         $r = $asd->fetchAll();
  28.         return $r;
  29.  
  30.     }
  31.  
  32. }
  33.  
  34.  
  35. //$doh    = new PDO("mysql:host=$host;dbname=$db",$user,$pass);
  36. $doh = new MySQL_Database;
  37.  
  38. //$doh->setAttribute(PDO::ATTR_AUTOCOMMIT,FALSE);
  39.  
  40.     $doh->getArray('Select shitz');
  41.     //või saad ka kutsuda
  42.     MySQL_Database::loop('select shitz');
  43.  
  44. ?>
Add Comment
Please, Sign In to add comment