PHP5 PDO Singleton Class

sickcat2004 发表于 2011-12-21 08:44

http://tonylandis.com/php/php5-pdo-singleton-class/ <div id="codeText" class="codeText"><ol style="margin:0 1px 0 0;padding:5px 0;" start="1" class="dp-css"><li>$dbObj =& new sdb("mysql:host=localhost;dbname=testdb", 'username', 'password');</li></ol></div> <div id="codeText" class="codeText"><ol style="margin:0 1px 0 0;padding:5px 0;" start="1" class="dp-css"><li><?php </li><li>
 </li><li>
/** </li><li>
 * PDO SINGLETON CLASS </li><li>
 * </li><li>
 * @author Tony Landis </li><li>
 * @link http://www.tonylandis.com </li><li>
 * @license Use how you like it, just please don't remove or alter this PHPDoc </li><li>
 */ </li><li>
class sdb </li><li>
{ </li><li>
    /** </li><li>
     * The singleton instance </li><li>
     * </li><li>
     */ </li><li>
    static private $PDOInstance; </li><li>
      </li><li>
      /** </li><li>
       * Creates a PDO instance representing a connection to a database and makes the instance available as a singleton </li><li>
       * </li><li>
       * @param string $dsn The full DSN, eg: mysql:host=localhost;dbname=testdb </li><li>
       * @param string $username The user name for the DSN string. This parameter is optional for some PDO drivers. </li><li>
       * @param string $password The password for the DSN string. This parameter is optional for some PDO drivers. </li><li>
       * @param array $driver_options A key=>value array of driver-specific connection options </li><li>
       * </li><li>
       * @return PDO </li><li>
       */ </li><li>
    public function __construct($dsn, $username=false, $password=false, $driver_options=false) </li><li>
    { </li><li>
        if(!self::$PDOInstance) { </li><li>
     try { </li><li>
             self::$PDOInstance = new PDO($dsn, $username, $password, $driver_options); </li><li>
            } catch (PDOException $e) { </li><li>
             die("PDO CONNECTION ERROR: " . $e->getMessage() . " "); </li><li>
            } </li><li>
        } </li><li>
          return self::$PDOInstance;           </li><li>
    } </li><li>
     </li><li>
      /** </li><li>
       * Initiates a transaction </li><li>
       * </li><li>
       * @return bool </li><li>
       */ </li><li>
    public function beginTransaction() { </li><li>
        return self::$PDOInstance->beginTransaction(); </li><li>
    } </li><li>
         </li><li>
    /** </li><li>
     * Commits a transaction </li><li>
     * </li><li>
     * @return bool </li><li>
     */ </li><li>
    public function commit() { </li><li>
        return self::$PDOInstance->commit(); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Fetch the SQLSTATE associated with the last operation on the database handle </li><li>
     * </li><li>
     * @return string </li><li>
     */ </li><li>
    public function errorCode() { </li><li>
        return self::$PDOInstance->errorCode(); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Fetch extended error information associated with the last operation on the database handle </li><li>
     * </li><li>
     * @return array </li><li>
     */ </li><li>
    public function errorInfo() { </li><li>
        return self::$PDOInstance->errorInfo(); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Execute an SQL statement and return the number of affected rows </li><li>
     * </li><li>
     * @param string $statement </li><li>
     */ </li><li>
    public function exec($statement) { </li><li>
        return self::$PDOInstance->exec($statement); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Retrieve a database connection attribute </li><li>
     * </li><li>
     * @param int $attribute </li><li>
     * @return mixed </li><li>
     */ </li><li>
    public function getAttribute($attribute) { </li><li>
        return self::$PDOInstance->getAttribute($attribute); </li><li>
    } </li><li>
 </li><li>
    /** </li><li>
     * Return an array of available PDO drivers </li><li>
     * </li><li>
     * @return array </li><li>
     */ </li><li>
    public function getAvailableDrivers(){ </li><li>
        return Self::$PDOInstance->getAvailableDrivers(); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Returns the ID of the last inserted row or sequence value </li><li>
     * </li><li>
     * @param string $name Name of the sequence object from which the ID should be returned. </li><li>
     * @return string </li><li>
     */ </li><li>
    public function lastInsertId($name) { </li><li>
        return self::$PDOInstance->lastInsertId($name); </li><li>
    } </li><li>
         </li><li>
       /** </li><li>
     * Prepares a statement for execution and returns a statement object </li><li>
     * </li><li>
     * @param string $statement A valid SQL statement for the target database server </li><li>
     * @param array $driver_options Array of one or more key=>value pairs to set attribute values for the PDOStatement obj </li><li>
returned </li><li>
     * @return PDOStatement </li><li>
     */ </li><li>
    public function prepare ($statement, $driver_options=false) { </li><li>
        if(!$driver_options) $driver_options=array(); </li><li>
        return self::$PDOInstance->prepare($statement, $driver_options); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Executes an SQL statement, returning a result set as a PDOStatement object </li><li>
     * </li><li>
     * @param string $statement </li><li>
     * @return PDOStatement </li><li>
     */ </li><li>
    public function query($statement) { </li><li>
        return self::$PDOInstance->query($statement); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Execute query and return all rows in assoc array </li><li>
     * </li><li>
     * @param string $statement </li><li>
     * @return array </li><li>
     */ </li><li>
    public function queryFetchAllAssoc($statement) { </li><li>
        return self::$PDOInstance->query($statement)->fetchAll(PDO::FETCH_ASSOC); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Execute query and return one row in assoc array </li><li>
     * </li><li>
     * @param string $statement </li><li>
     * @return array </li><li>
     */ </li><li>
    public function queryFetchRowAssoc($statement) { </li><li>
        return self::$PDOInstance->query($statement)->fetch(PDO::FETCH_ASSOC);      </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Execute query and select one column only </li><li>
     * </li><li>
     * @param string $statement </li><li>
     * @return mixed </li><li>
     */ </li><li>
    public function queryFetchColAssoc($statement) { </li><li>
        return self::$PDOInstance->query($statement)->fetchColumn();      </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Quotes a string for use in a query </li><li>
     * </li><li>
     * @param string $input </li><li>
     * @param int $parameter_type </li><li>
     * @return string </li><li>
     */ </li><li>
    public function quote ($input, $parameter_type=0) { </li><li>
        return self::$PDOInstance->quote($input, $parameter_type); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Rolls back a transaction </li><li>
     * </li><li>
     * @return bool </li><li>
     */ </li><li>
    public function rollBack() { </li><li>
        return self::$PDOInstance->rollBack(); </li><li>
    } </li><li>
     </li><li>
    /** </li><li>
     * Set an attribute </li><li>
     * </li><li>
     * @param int $attribute </li><li>
     * @param mixed $value </li><li>
     * @return bool </li><li>
     */ </li><li>
    public function setAttribute($attribute, $value) { </li><li>
        return self::$PDOInstance->setAttribute($attribute, $value); </li><li>
    } </li><li>
} </li><li>
?></li></ol></div>

页: [1]

Chinaunix's Archiver

PHP5 PDO Singleton Class