<!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>
