PHP error closing a mysql connection

Question

I'm using a very simple function:

function closeConn(){
    mysql_close($conn);
}

$conn is the connection variable - it connects ok but i get this error if i try and call it:

Warning: mysql_close() expects parameter 1 to be resource, null given in

What is the reason for this?

always been a bit hazy on when to close connection, so no, not a real reason :) — benhowdle89
– benhowdle89, Commented Jan 21, 2011 at 13:28
why are people emphasising real :) but not any particular reason, is mysqli better? — benhowdle89
– benhowdle89, Commented Jan 21, 2011 at 13:28

Mchl · Accepted Answer · 2011-01-21 13:25:23Z

6

The reason is, $conn variable is empty.

Either pass it as an argument to your function:

function closeConn($conn){
    mysql_close($conn);
}

closeConn($conn);

or just don't use it at all and let PHP decide which connection to close (by default, tha last one that was opened)

function closeConn(){
    mysql_close();
}

or just don't close the connection at all. PHP does it for you anyway, when the script's execution ends.

answered Jan 21, 2011 at 13:25

Mchl

62.4k9 gold badges121 silver badges121 bronze badges

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

1 Answer 1