mysqli::close

mysqli_close

(PHP 5, PHP 7)

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

Descrizione

Stile orientato agli oggetti

mysqli::close ( void ) : bool

Stile procedurale

mysqli_close ( mysqli $link ) : bool

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

Elenco dei parametri

link

Solo nello stile procedurale: un identificatore restituito da mysqli_connect() o mysqli_init()

Valori restituiti

Restituisce TRUE in caso di successo, FALSE in caso di fallimento.

Esempi

See mysqli_connect().

Note

Nota:

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

Vedere anche:

add a note add a note

User Contributed Notes 3 notes

up
0
PD
1 year ago
Note with Francis' example, using the function name link() will throw an error at runtime as it is already a function within the language. see: http://php.net/manual/en/function.link.php
up
-8
Francois
1 year ago
Since a lot of manual examples recommend to use a variable to initiate your connection, it is interesting to know that mysqli_close() will unset that variable, causing further connection attempts to fail.
ex:

$link = mysqli_connect($host, $user, $pw);

if ($link) {
    // Database is reachable
    mysqli_close($link);
}

if ($link) {
    // Database unreachable because $link = NULL
}

Easiest solution for me is to initiate connection through a function.
ex:

function link() {
    global $host;
    global $user;
    global $pw;
    global $link;
    $link = mysqli_connect($host, $user, $pw);
}

link();
// Database is reachable
mysqli_close($link)
link();
// Database is reachable
mysqli_close($link)
up
-27
php at dafydd dot com
11 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