Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.98 KB | None | 0 0
  1. <?php
  2.  
  3. class DB {
  4.  
  5.     const DB_USER = 'root';
  6.     const DB_PASS = 'password';
  7.     const DB_HOST = 'localhost';
  8.    
  9.     protected static $dbh_hash = array();
  10.  
  11.     public static function Get ($db_name) {
  12.         if(isset(self::$dbh_hash[$db_name])) {
  13.             return self::$dbh_hash[$db_name];
  14.         } else {
  15.             try {
  16.                 // Open the database
  17.                 $pdo = new PDO
  18.                 (
  19.                 // If host is localhost, leave out and connect via socket
  20.                 'mysql:' . (self::DB_HOST == 'localhost' ? '' : 'host=' . self::DB_HOST . ';') . 'dbname=' . $db_name . ';',
  21.                 self::DB_USER,
  22.                 self::DB_PASS
  23.                 );
  24.                
  25.                 // Put PDO into exception error mode
  26.                 $pdo->setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  27.                
  28.                 // Allow buffered queries in  MySQL
  29.                 $pdo->setAttribute (PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
  30.             } catch (PDOException $Ex) {
  31.                 throw new Exception ('Could not connect to database');
  32.             }
  33.             $dbh_hash[$db_name] = $pdo;
  34.             return $pdo;
  35.         }
  36.     }
  37. }
  38.  
  39. $db = DB::Get('database_name');
  40.  
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement