How to close Mysql connection

Question

This is mysql Connection code.

$db_host = "localhost";
$db_name = "propstor_image";
$db_user = "root";
$db_pass = "";

try{

    $db_con = new PDO("mysql:host={$db_host};dbname={$db_name}",$db_user,$db_pass);
    $db_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e){
    echo $e->getMessage();
}?>

When I try to Close mysql connection by using mysql_close($db_con); It shows following error

" mysql_close() expects parameter 1 to be resource, object given in C:\wamp\www\property\member\include\login.php on line 57" .Please can you help me how to close mysql connection.

you are using `PDO` not `mysql` so that function call is totally incorrect - you can simply do `$db_con=null;` — Professor Abronsius, Sep 28 '16 at 07:06
Here is the answer to close PDO connection: http://stackoverflow.com/questions/18277233/pdo-closing-connection — Ravi Sachaniya, Sep 28 '16 at 07:08

score 1 · Answer 1 · answered Sep 28 '16 at 07:10

For PDO

The connection remains active for the lifetime of that PDO object. 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.

reference link : Link

score 1 · Answer 2 · answered Sep 28 '16 at 07:15

1

You could try this:

<Connection variable>.Close();

Example:

conn.Close();

I hope this helps!

answered Sep 28 '16 at 07:15

LittleProgrammer

31
3

If it works, please flag this post as answered :) – LittleProgrammer Sep 28 '16 at 07:56

How to close Mysql connection

2 Answers2