php database connection?

Question

i have a few question on php db connection and hoping someone can answer them all, when i create a db connection using pdo, like below

<?php
/* Connect to an ODBC database using driver invocation */
$dsn = 'mysql:dbname=testdb;host=127.0.0.1';
$user = 'dbuser';
$password = 'dbpass';

try {
    $dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

?>

is this connection always created when someone refreshes the php page?
or does it check if that connection is already open and then use that connection instead?
how would i be able to close that connection when i am done with it?

zerkms · Accepted Answer · 2012-03-27 01:03:07Z

1

yes
nope. It tries to utilize previously established connections only if you have set up permanent connections
generally you don't need to do anything special. php does that as long as your script ends

answered Mar 27, 2012 at 1:03

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

Comments

Matthew · Accepted Answer · 2012-03-27 01:05:03Z

1

I found this in the php manual. Hope it helps.

To close the connection, you need to destroy the object by ensuring that all remaining references to it are deleted--you do this by assigning NULL to the variable that holds the object. If you don't do this explicitly, PHP will automatically close the connection when your script ends.

answered Mar 27, 2012 at 1:05

Matthew

612 bronze badges

Collectives™ on Stack Overflow

php database connection?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related