Advertisement
Guest User

PHP MySQL connection class

a guest
Nov 4th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.25 KB | None | 0 0
  1. <?php
  2. class MySQL {
  3.    
  4.     private static $pdos = array();
  5.     private static $selected_server = "default";
  6.    
  7.     private static $host;
  8.     private static $user;
  9.     private static $pass;
  10.     private static $db;
  11.     private static $charset = "utf8";
  12.     private static $prepared_sqls = array();
  13.    
  14.     public static function setCharset($charset) {
  15.         self::$charset = $charset;
  16.     }
  17.    
  18.     public static function connect($host, $user, $pass, $db, $pdoName = "default") {
  19.         self::$host = $host;
  20.         self::$user = $user;
  21.         self::$pass = $pass;
  22.         self::$db = $db;
  23.         try {
  24.             self::$pdos[$pdoName] = new \PDO("mysql:host=" . self::$host . ";dbname=" . self::$db . ";charset=" . self::$charset, self::$user, self::$pass);
  25.             return true;
  26.         } catch (\PDOException $ex) {
  27.             echo "MySQL Error ! (Error code: " . $ex->getCode() . ", Message: " . $ex->getMessage() . ")";
  28.         }
  29.     }
  30.    
  31.     public static function setPdoName($name) {
  32.         self::$selected_server = $name;
  33.     }
  34.    
  35.     public static function query($query) {
  36.         $args = func_get_args();
  37.         array_shift($args);
  38.         $response = self::$pdos[self::$selected_server]->prepare($query);
  39.         $response->execute($args);
  40.         self::$selected_server = "default";
  41.         return $response;
  42.     }
  43.    
  44.     public static function getPDO() {
  45.         return self::$pdo;
  46.     }
  47.    
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement