Advertisement
Guest User

php pdo connection - singleton

a guest
Mar 30th, 2016
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.22 KB | None | 0 0
  1. <?php
  2. class DbConn {
  3.     private static $instance;
  4.     private $db;
  5.  
  6.     private $dbserver;
  7.     private $username;
  8.     private $password;
  9.     private $database;
  10.     private $error;
  11.  
  12.     public function __construct() {
  13.         $this->dbserver = 'localhost';
  14.         $this->username = 'kick';
  15.         $this->password = '1@kick';
  16.         $this->database = 'kickstartapp';
  17.  
  18.         try {
  19.             $this->db = new PDO("mysql:host=".$this->dbserver.";dbname=".$this->database, $this->username, $this->password);
  20.         } catch(PDOException $e) {
  21.             $this->error = $e->getMessage();
  22.         }
  23.     }
  24.  
  25.     public static function getInstance() {
  26.         if(!self::$instance) {
  27.             self::$instance = new self();
  28.         }
  29.         return self::$instance;
  30.     }
  31.  
  32.     public function getDb() {
  33.         return $this->db;
  34.     }
  35. }
  36.  
  37.  
  38. class Database {
  39.     public $db;
  40.  
  41.     public function __construct() {
  42.         $dbconn = DbConn::getInstance();
  43.         $this->db = $dbconn->getDb();
  44.     }
  45.  
  46.     public function dbselect($table, $select, $where=NULL) {
  47.     }
  48.  
  49.     public function dbadd($tablename, $insert, $format) {
  50.     }
  51.  
  52.     public function dbupdate($tablename, $insert, $where) {
  53.     }
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement