What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.

mysql_close
Prev	XLI. MySQL Functions	Next

mysql_close

Name

mysql_close — Closes a MySQL connection.

Synopsis

bool mysql_close(connection); mysql link connection: Connection handle returned by mysql_connect()

Returns

TRUE on success; FALSE on failure

Description

mysql_close() closes a MySQL connection opened by mysql_connect() . The connection to close is specified with the connection argument. If no argument is specified, the last opened connection is closed.

Use of this function is not required. Connections opened by mysql_connect() close automatically on script exit.

Note

mysql_close() cannot close the persistent connections that are opened by mysql_pconnect() . These connections last beyond the life of the script that opened them. PHP closes them as needed.

Version

PHP 3+, PHP 4+

Example

Example 788. Close the last connection opened

mysql_close ()
    or die ("The last MySQL connection opened could not be closed.");

Example 789. Close a specific connection

<?php
$logger_connection = mysql_connect ('localhost', 'logger', '')
    or die ("Could not connect to database as user 'logger'.");

$anon_connection = mysql_connect ('localhost', 'anon', '')
    or die ("Could not connect to database as user 'anon'.");

if (mysql_close ($logger_connection))
    echo "The connection for user 'logger' was closed.";
else
    echo "The connection for user 'logger' could not be closed.";
?>

Prev	Home	Next
mysql_change_user	Up	mysql_connect

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.