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
mysqli_close
mysqli->close
(PHP 5, PHP 7)
mysqli_close -- mysqli->close — Fecha uma conexão aberta anteriormente com o banco de dados
Descrição
Estilo de procedimento:
mysqli_close
( object
$link
) : boolEstilo orientado a objeto (metodo):
close
(
) : bool
A função mysqli_close() fecha uma conexão com um banco de dados aberto
anteriormente especificado pelo parâmetro link.
Valores de retorno
Retorna true em caso de sucesso ou false em caso de falha.
Veja também
add a note
User Contributed Notes 3 notes
PD ¶
5 years ago
Francois ¶
5 years 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)
php at dafydd dot com ¶
15 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.
