Use of PDO in classes [duplicate]

by

You can instantiate your connection to the database in a class that implement the singleton pattern.
The connection will be done once and this class will be easily accessible by all of your other objects / scripts.

i use a class called “Core” in the following example;

class Core
{
    public $dbh; // handle of the db connexion
    private static $instance;

    private function __construct()
    {
        // building data source name from config
        $dsn = 'pgsql:host=" . Config::read("db.host') .
               ';dbname="    . Config::read("db.basename') .
               ';port="      . Config::read("db.port') .
               ';connect_timeout=15';
        // getting DB user from config                
        $user = Config::read('db.user');
        // getting DB password from config                
        $password = Config::read('db.password');

        $this->dbh = new PDO($dsn, $user, $password);
    }

    public static function getInstance()
    {
        if (!isset(self::$instance))
        {
            $object = __CLASS__;
            self::$instance = new $object;
        }
        return self::$instance;
    }

    // others global functions
}

this class take parameters from a static class called “Config” where you can store your configuration:

<?php
class Config
{
    static $confArray;

    public static function read($name)
    {
        return self::$confArray[$name];
    }

    public static function write($name, $value)
    {
        self::$confArray[$name] = $value;
    }

}

// db
Config::write('db.host', '127.0.0.1');
Config::write('db.port', '5432');
Config::write('db.basename', 'mydb');
Config::write('db.user', 'myuser');
Config::write('db.password', 'mypassword');

in all your scripts / objects you just have to get the instance of Core and then query the DB

$sql = "select login, email from users where id = :id";

try {
    $core = Core::getInstance();
    $stmt = $core->dbh->prepare($sql);
    $stmt->bindParam(':id', $this->id, PDO::PARAM_INT);

    if ($stmt->execute()) {
        $o = $stmt->fetch(PDO::FETCH_OBJ);
        // blablabla....

If you need more information about singleton look at the PHP doc http://php.net/manual/en/language.oop5.patterns.php

More Related Contents:

  1. PHP – Using PDO with IN clause array
  2. pdo prepared statements with wildcards
  3. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  4. Insert multiple rows with PDO prepared statements
  5. Replacing mysql_* functions with PDO and prepared statements
  6. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  7. Calling stored procedure with Out parameter using PDO
  8. When *not* to use prepared statements?
  9. PDO error: SQLSTATE[HY000]: General error: 2031
  10. Error while using PDO prepared statements and LIMIT in query [duplicate]
  11. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  12. How to apply bindValue method in LIMIT clause?
  13. PDO with INSERT INTO through prepared statements [closed]
  14. PDO::fetchAll vs. PDO::fetch in a loop
  15. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  16. Real escape string and PDO [duplicate]
  17. PDO multiple queries
  18. PHP PDO vs normal mysql_connect
  19. Can I create a database using PDO in PHP?
  20. PHP PDO::bindParam() data types.. how does it work?
  21. PHP PDO and MySQLi [duplicate]
  22. PDO fetch one column from table into 1-dimensional array
  23. Update query with PDO and MySQL
  24. Getting a PHP PDO connection from a mysql_connect()?
  25. Having issue with matching rows in the database
  26. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  27. How can I pass an array of PDO parameters yet still specify their types?
  28. PHP/SQL Insert Error when using Named Placeholders
  29. Using Prepared Statement, how I return the id of the inserted row?
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment