PHP : Using variable functions

Question

I have a class that allows a PDO connection which sets itself up. When I want to use the connection I can use:

$db = $factory->create('db');

However, I wanted to just be able to do:

global $db;

Anytime I want to use the database.

Would this work?

$db = function(){
        $con = $factory->create('db');
        return $con;
    };

global $db;

This way, I can close the connection and then open it again at any point. Example:

global $db;
$db->close();
// Re-open
global $db;

Or how could I possibly do this? References would be so appreciated as I have searched a lot.

Thanks in advance.

if you make $db global then whats the point for the factory pattern ?? just curious — Andrew
– Andrew, Commented Feb 17, 2016 at 14:19
I am new to protected, global and private :( I want to just be able to global $db; every time I want to use the database and just be able to close it and re-open it the way it says. Can anyone link me any references to achieve this? — Jaquarh
– Jaquarh, Commented Feb 17, 2016 at 14:20
While I don't know what $db->close() does, the connection is not going to magically reopen when you change the variable scope, which is all the global keyword is doing. — Devon Bessemer
– Devon Bessemer, Commented Feb 17, 2016 at 14:21
Then $db->close() probably isn't doing anything. You should focus your learning on the proper usage and separation of variable scopes, not trying to adapt the code to how MyBB works. — Devon Bessemer
– Devon Bessemer, Commented Feb 17, 2016 at 14:22

Jaquarh · Accepted Answer · 2016-02-17 14:29:51Z

0

@Devon explained in the comments section about Scopes and how this couldn't be achieved.

In order for this to work you'd just do:

$db = $factory->create('db');
// close it
$db = null;
// re-open it
$db = $factory->create('db');

Or this:

function db(){
    $db = $factory->create('db');
    global $db;
}

db();
$db->.....

answered Feb 17, 2016 at 14:29

Jaquarh

6,7498 gold badges48 silver badges119 bronze badges

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

1 Answer 1