PHP - Manual: mysql_close

2024-11-14

mysql_connect »

« mysql_client_encoding

mysql_close

(PHP 4, PHP 5)

mysql_close — 关闭 MySQL 连接

警告

本扩展自 PHP 5.5.0 起已废弃，并在自 PHP 7.0.0 开始被移除。应使用 MySQLi 或 PDO_MySQL 扩展来替换之。参见 MySQL：选择 API 指南来获取更多信息。用以替代本函数的有：

mysqli_close()
PDO: 为 PDO 对象设置一个 null 值

说明

mysql_close(resource $link_identifier = NULL): bool

mysql_close() 关闭指定的连接标识所关联的到 MySQL 服务器的非持久连接。如果没有指定 link_identifier，则关闭上一个打开的连接。

通常不需要使用 mysql_close()，因为已打开的非持久连接会在脚本执行完毕后自动关闭。参见释放资源。

参数

link_identifier: MySQL 连接. 如果该连接标识符未给出, 将使用最近一次mysql_connect()建立的连接. 如果没有找到可使用的连接, 将产生一个 E_WARNING 错误.

返回值

成功时返回 true，或者在失败时返回 false。

范例

示例 #1 mysql_close() 例子


<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

以上例程会输出：

Connected successfully

注释

注意:
mysql_close() 不会关闭由 mysql_pconnect() 建立的持久连接。

参见

mysql_connect() - 打开一个到 MySQL 服务器的连接
mysql_free_result() - 释放结果内存

add a note

User Contributed Notes 6 notes

down

bbodelcampo at yahoo dot co dot uk ¶

16 years ago


A little note about multiple simultaneous connections to different hosts...


I work on a site that pulls content primarily from one db but uses a db on a foreign server to verify licensing.  One might expect the following to work:


<?php

// Open the connection to the primary db

$res1 = mysql_connect($host1, $user1, $pass1);

mysql_select_db($db1);


// Open connection to the license server

$res2 = mysql_connect($host2, $user2, $pass2);

mysql_select_db($db2, $res2);


// Pull license data and close when done

mysql_query($check_sql, $res2);

// ...

mysql_close($res2);


// Now pull content from the primary db

// Not specifying the resource should default to the last open db

mysql_query($query); 

// ...

?>



Turns out this last query, since it cant find an active connection, will try to connect with mysql_connect() with no paramaters.  But if instead you do it as mysql_query($query, $res1), or alternatively, run the mysql_connect for this host again then it works fine.  Thus, it doesnt seem to be possible to have code with an overarching "global" db connection interspersed with temporary connections to another host/db....

down

-4

beer_nomaed _AT_ hotmail _DOT_ com ¶

17 years ago


Be careful when using multiple links to connect to same database (with same username). Unless you specify explicitly in mysql_connect() to create a new link, it will return an already open link. If that would be closed by mysql_close(), it will also (obviously) close the other connection, since the link is the same.
Had lot of trouble figuring it out, since in <=4.3.6 there was a bug which didn't close the connection, but after the patch to >=4.3.7, all my application broke down because of a single script that did this.

down

-6

mdes[SPAM]saintes at gmail dot com ¶

11 years ago


i just came over a problem that i had with apache.

It crashs and said :

"Parent: child process exited with status 3221225477 -- Restarting."

the error came from the extesion php_mysql.dll

i didn't understand what was the reason of that crash..

Then, i debug the script that i had downloaded and i noticed that that was the function mysql_close() which caused the problem.

The solution is, to send to it the link identifier which is optionnal in the description but cause a crash with no commentary.

Thanks to agneady.

down

-7

Anonymous ¶

12 years ago


At least with PHP5.3.2 and Windows connecting by tcp, you should always use this mysql_close() function to close and free up the tcp socket being used by PHP.  Garbage collection after script execution does not close the tcp socket on its 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.

down

-8

levi at alliancesoftware dot com dot au ¶

17 years ago


As at 5.0.x and 4.3.x: This function should never be used with shared links; instead you should set your link variables to null.

(This explains red's and beer's () problems in previous comments)


  Here is how shared links work:

  - Each link is a resource. mysql_connect() by default looks for a resource with the same paramaters. If one exists, it will return the existing resource. 

  - Every assignment of that resource to a variable increases the resource's reference count.

  - When the reference is decremented to zero, the underlying TCP/socket connection is closed.

    - Every assignment of a variable away from that resource decrements the reference count. (This includes a function level variable going out of scope)

    - mysql_close() also decrements the reference count.


Note the last two points: mysql_close() _and_ reassignment of a variable decrement the link's reference count.


A common mistake is a function like:


<?php

function dothings() {

  $link = mysql_open(...);

  // .. do some queries ..

  mysql_close($link)

  $link = null;

}

?>



this will decrement the counter twice, possibly closing the underlying connection and causing errors in other parts of the program.


http://bugs.php.net/bug.php?id=30525 "this is not a bug but just how it works"

down

-10

omega99999 at gmail dot com ¶

11 years ago


The variable is definitely not optional in 5.3... Caused me a bit of a headache when I was debugging until I realized it was the close function that was causing a hang. So if using just:

<?php
mysql_connect(<...>);

mysql_close();
?>

Use:

<?php
$connection = mysql_connect(<...>);

mysql_close($connection);
?>

(where $connection is any variable of your choice)

add a note

官方地址：https://www.php.net/manual/en/function.mysql-close.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 PHP mkdir()写出来的权限与mode值不符合 Packagist / Composer 中国全量镜像 php中几种注释规范利用php soap实现web service PHP获取指定函数定义在哪个文件中及行号

略微加速

PHP官方手册 - 互联网笔记

mysql_close

说明

参数

返回值

范例

注释

参见

User Contributed Notes 6 notes