<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>Close MySQL connection</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.mysql-client-encoding.html">mysql_client_encoding</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.mysql-connect.html">mysql_connect</a></div> <div class="up"><a href="ref.mysql.html">MySQL Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="function.mysql-close" class="refentry"> <div class="refnamediv"> <h1 class="refname">mysql_close</h1> <p class="verinfo">(PHP 4, PHP 5)</p><p class="refpurpose"><span class="refname">mysql_close</span> — <span class="dc-title">Close MySQL connection</span></p> </div> <div id="function.mysql-close-refsynopsisdiv"> <div class="warning"><strong class="warning">Warning</strong> <p class="para">This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the <a href="book.mysqli.html" class="link">MySQLi</a> or <a href="ref.pdo-mysql.html" class="link">PDO_MySQL</a> extension should be used. See also <a href="mysqlinfo.api.choosing.html" class="link">MySQL: choosing an API</a> guide and <a href="faq.databases.html#faq.databases.mysql.deprecated" class="link">related FAQ</a> for more information. Alternatives to this function include:</p> <ul class="simplelist"> <li class="member"><span class="function"><a href="mysqli.close.html" class="function">mysqli_close()</a></span></li> <li class="member">PDO: Assign the value of <strong><code>NULL</code></strong> to the PDO object</li> </ul> </div> </div> <div class="refsect1 description" id="refsect1-function.mysql-close-description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><strong>mysql_close</strong></span> ([ <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link_identifier</code><span class="initializer"> = NULL</span></span> ] )</div> <p class="para rdfs-comment"> <span class="function"><strong>mysql_close()</strong></span> closes the non-persistent connection to the MySQL server that's associated with the specified link identifier. If <code class="parameter">link_identifier</code> isn't specified, the last opened link is used. </p> <p class="para"> 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 <a href="language.types.resource.html#language.types.resource.self-destruct" class="link">freeing resources</a></p> </div> <div class="refsect1 parameters" id="refsect1-function.mysql-close-parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <code class="parameter"> link_identifier</code></dt> <dd> <p class="para">The MySQL connection. If the link identifier is not specified, the last link opened by <span class="function"><a href="function.mysql-connect.html" class="function">mysql_connect()</a></span> is assumed. If no connection is found or established, an <strong><code>E_WARNING</code></strong> level error is generated.</p></dd> </dl> </p> </div> <div class="refsect1 returnvalues" id="refsect1-function.mysql-close-returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> Returns <strong><code>TRUE</code></strong> on success or <strong><code>FALSE</code></strong> on failure. </p> </div> <div class="refsect1 examples" id="refsect1-function.mysql-close-examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example" id="example-2168"> <p><strong>Example #1 <span class="function"><strong>mysql_close()</strong></span> example</strong></p> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br />$link </span><span style="color: #007700">= </span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">'localhost'</span><span style="color: #007700">, </span><span style="color: #DD0000">'mysql_user'</span><span style="color: #007700">, </span><span style="color: #DD0000">'mysql_password'</span><span style="color: #007700">);<br />if (!</span><span style="color: #0000BB">$link</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'Could not connect: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">mysql_error</span><span style="color: #007700">());<br />}<br />echo </span><span style="color: #DD0000">'Connected successfully'</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">mysql_close</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> <div class="example-contents"><p>The above example will output:</p></div> <div class="example-contents screen"> <div class="cdata"><pre> Connected successfully </pre></div> </div> </div> </p> </div> <div class="refsect1 notes" id="refsect1-function.mysql-close-notes"> <h3 class="title">Notes</h3> <blockquote class="note"><p><strong class="note">Note</strong>: <p class="para"> <span class="function"><strong>mysql_close()</strong></span> will not close persistent links created by <span class="function"><a href="function.mysql-pconnect.html" class="function">mysql_pconnect()</a></span>. For additional details, see the manual page on <a href="features.persistent-connections.html" class="link">persistent connections</a>. </p> </p></blockquote> </div> <div class="refsect1 seealso" id="refsect1-function.mysql-close-seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><span class="function"><a href="function.mysql-connect.html" class="function" rel="rdfs-seeAlso">mysql_connect()</a> - Open a connection to a MySQL Server</span></li> <li class="member"><span class="function"><a href="function.mysql-free-result.html" class="function" rel="rdfs-seeAlso">mysql_free_result()</a> - Free result memory</span></li> </ul> </p> </div> </div><hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.mysql-client-encoding.html">mysql_client_encoding</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.mysql-connect.html">mysql_connect</a></div> <div class="up"><a href="ref.mysql.html">MySQL Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>