How to Effectively Integrate PDO into Classes for Database Interaction in PHP?

Incorporating PDO into Classes for Database Interaction

Extending the PDO class in PHP is not the most suitable approach for incorporating PDO into classes that perform MySQL queries. Here's an elegant and widely employed solution:

Singleton Pattern with Core Class

Create a Core class that implements the Singleton pattern. This class will be responsible for establishing a single instance of the database connection and making it accessible to other objects.

<code class="php">class Core
{
    private static $instance;
    private $dbh; // Database connection handle

    private function __construct()
    {
        // Initialize database connection using PDO
    }

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

        return self::$instance;
    }

    public function getPDO()
    {
        return $this->dbh;
    }
}</code>

Using the Core Class in Your Database Classes

In your database classes, instantiate the Core class to access the PDO object.

<code class="php">class Foo
{
    public function bar()
    {
        $core = Core::getInstance();
        $dbh = $core->getPDO();

        $stmt = $dbh->prepare('SELECT * FROM table');
        $stmt->execute();
    }
}</code>

This approach ensures that all database interactions within your application use the same PDO connection, avoiding multiple connections to the database. Additionally, the Singleton pattern provides easy access to the PDO object from within any class.

The above is the detailed content of How to Effectively Integrate PDO into Classes for Database Interaction in PHP?. For more information, please follow other related articles on the PHP Chinese website!