Reuse DB connection instead of creating new instances for each request

Question

I have the following code that works, but I am wondering what would be a better approach to this technique? I would like to start reusing connections instead of creating new instances for each query. Any practical advise and solution to my code?

<?php
class dbc {
    function openDb() {

        $dbserver = '';
        $dbusername = '';
        $dbpassword = '';
        $dbname = '';

        try {
            $db = new PDO('mysql:host=' . $dbserver . ';port=3306;dbname=' . $dbname . ';charset=utf8', '' . $dbusername . '', '' . $dbpassword . '', array(PDO::MYSQL_ATTR_INIT_COMMAND =>"SET SESSION time_zone = 'America/Chicago'"));
            $timezone = "America/Chicago";
            $db->exec("SET time_zone = '{$timezone}'");  

        } catch (PDOException $e) {
            print "Error!: " . $e->getMessage() . "<br/>";
            die("error, please try again");
        }
        return $db;
    }
}

<?php    
require 'dbc.php';

function getDailyProfitability() {
    $db = new dbc();
    $query = "SELECT 1 FROM DUAL";
    $stmt = $db->openDb()->prepare($query);
    $stmt->execute();
    return $stmt->fetchAll();
}    
?>

binary-idiot · Accepted Answer · 2016-03-19 02:42:45Z

1

Not sure if this is exactly what you're looking for but I found this article that talks about using a static variable to store your database connection.

answered Mar 19, 2016 at 2:42

binary-idiot

1191 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reuse DB connection instead of creating new instances for each request

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related