mysqli::close

mysqli_close

(PHP 5)

mysqli::close -- mysqli_close — 事前にオープンしているデータベース接続を閉じる

説明

オブジェクト指向型

bool mysqli::close ( void )

手続き型

bool mysqli_close ( mysqli $link )

既に開いているデータベース接続を閉じます。

パラメータ

link: 手続き型のみ: mysqli_connect() あるいは mysqli_init() が返すリンク ID。

返り値

成功した場合に TRUE を、失敗した場合に FALSE を返します。

例

mysqli_connect() を参照ください。

参考

mysqli_connect() - mysqli::__construct のエイリアス
mysqli_init() - MySQLi を初期化し、mysqli_real_connect() で使用するリソースを返す
mysqli_real_connect() - mysql サーバーとの接続をオープンする

mysqli::commit

mysqli::$client_version

[edit] Last updated: Fri, 25 May 2012

add a note User Contributed Notes mysqli::close

Anonymous 23-Apr-2010 02:43


The mysqli_close() function and object method only remove the ability to use the mysql object again in the script, essentially on the surface only nulling out all object parameters.



At least with PHP5.3.2 and Windows connecting by tcp, this differs by the old mysql_close() function in that it does not actually close out the tcp socket being used.  You should always use mysqli_kill() function before mysqli_close() to actually close and free up the tcp socket being used by PHP.  Garbage collection after script execution nor mysqli_close() do not kill the tcp socket on their own.  The socket would otherwise remain in 'wait' state for approximately 30 seconds, and any additional page loads/connection attempts would only add to the total number of open tcp connections.  This wait time does not appear to be configurable via PHP settings.



Also as of this version, mysqli created links cannot be "deactivated", and will continue to accumulate in process memory until the PHP server or process is restarted, essentially making mysqli.max_links = -1 required.

php at dafydd dot com 07-Nov-2008 01:03


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.

win at alinto dot com 21-May-2008 02:52


There's nothing here about connexions automatically claused at the end of a script. About that, a little note from devzone.zend.com :



"Open connections (and similar resources) are automatically destroyed at the end of script execution. However, you should still close or free all connections, result sets and statement handles as soon as they are no longer required. This will help return resources to PHP and MySQL faster."

add a note