roman_gemini

PHP Class STATIC for PDO MySQL

Jul 1st, 2014
273
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.04 KB | None | 0 0
  1. class database {
  2.  
  3.     static private $pdo;
  4.  
  5.     static function connect($host, $db, $login, $password) {
  6.         self::$pdo = new PDO ("mysql:host={$host};dbname={$db}", $login, $password);
  7.         if(self::$pdo) {
  8.             self::$pdo->query("SET NAMES 'utf8'");
  9.             return true;
  10.         } else
  11.             return false;
  12.  
  13.     }
  14.    
  15.     static function query($query, $params = array(), $arr = null) {
  16.         $res = self::$pdo->prepare($query);
  17.         if($res) {
  18.             $res->execute($params);
  19.             return $res->fetchAll($arr ? PDO::FETCH_NUM : PDO::FETCH_ASSOC);
  20.         } else
  21.             return false;
  22.     }
  23.    
  24.     static function query_single_col($query, $params = array()) {
  25.         $res = self::$pdo->prepare($query);
  26.         if($res) {
  27.             $res->execute($params);
  28.             $val = $res->fetch(PDO::FETCH_NUM);
  29.             return $val[0];
  30.         } else
  31.             return false;
  32.     }
  33.  
  34.     static function query_single_row($query, $params = array(), $arr = null) {
  35.         $res = self::$pdo->prepare($query);
  36.         if($res) {
  37.             $res->execute($params);
  38.             $val = $res->fetch($arr ? PDO::FETCH_NUM : PDO::FETCH_ASSOC);
  39.             return $val;
  40.         } else
  41.             return false;
  42.     }
  43.  
  44. }
Advertisement
Add Comment
Please, Sign In to add comment