henrywm
9/1/2015 - 6:02 PM

Database Connection PHP using the class PDO.

Database Connection PHP using the class PDO.

<?php
class Connection{
   public static $db;
   private static function doConnection(){
        if (!isset(self::$db)) {
            try {
                $host     = "YOUR_HOST";
                $db_name  = "YOUR_DB";
                $user     = "YOUR_USER";
                $pass     = "YOUR_PASS";
                self::$db = new PDO("mysql:host=$host;dbname=$db_name", $user, $pass);
                self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                self::$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
            }
            catch (PDOException $e) {
                echo "CONNECTION ERRO" . $e->getMessage();
            }
         }
         return self::$db;
   }
   public static function prepare($sql){
      return self::doConnection()->prepare($sql);
   }
}