PHP 7.1.18 Released



(PHP 5, PHP 7)

mysqli::close -- mysqli_closeCloses a previously opened database connection


Object oriented style

bool mysqli::close ( void )

Procedural style

bool mysqli_close ( mysqli $link )

Closes a previously opened database connection.

Open non-persistent MySQL connections and result sets are automatically destroyed when a PHP script finishes its execution. So, while explicitly closing open connections and freeing result sets is optional, doing so is recommended. This will immediately return resources to PHP and MySQL, which can improve performance. For related information, see freeing resources



Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

Return Values

Returns TRUE on success or FALSE on failure.


See mysqli_connect().



mysqli_close() will not close persistent connections. For additional details, see the manual page on persistent connections.

See Also

add a note add a note

User Contributed Notes 1 note

php at dafydd dot com
9 years ago
I've had situations where database connections appeared to persist following php execution. So, now, my __destructor function explicitly contains a $cxn->close(). It hurts nothing, and helps avoid memory leaks.
To Top