<!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>Free statement memory</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.mssql-free-result.html">mssql_free_result</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.mssql-get-last-message.html">mssql_get_last_message</a></div> <div class="up"><a href="ref.mssql.html">Mssql Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="function.mssql-free-statement" class="refentry"> <div class="refnamediv"> <h1 class="refname">mssql_free_statement</h1> <p class="verinfo">(PHP 4 >= 4.3.2, PHP 5, PECL odbtp >= 1.1.1)</p><p class="refpurpose"><span class="refname">mssql_free_statement</span> — <span class="dc-title">Free statement memory</span></p> </div> <div id="function.mssql-free-statement-refsynopsisdiv"> <div class="warning"><strong class="warning">Warning</strong> <p class="para"> This function was <em class="emphasis">REMOVED</em> in PHP 7.0.0. </p> <p class="para"> Alternatives to this function include: </p> <ul class="simplelist"> <li class="member"><span class="function"><a href="function.sqlsrv-free-stmt.html" class="function">sqlsrv_free_stmt()</a></span></li> </ul> </div> </div> <div class="refsect1 description" id="refsect1-function.mssql-free-statement-description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><strong>mssql_free_statement</strong></span> ( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$stmt</code></span> )</div> <p class="para rdfs-comment"> <span class="function"><strong>mssql_free_statement()</strong></span> only needs to be called if you are worried about using too much memory while your script is running. All statement memory will automatically be freed when the script ends. You may call <span class="function"><strong>mssql_free_statement()</strong></span> with the statement identifier as an argument and the associated statement memory will be freed. </p> </div> <div class="refsect1 parameters" id="refsect1-function.mssql-free-statement-parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <code class="parameter">stmt</code></dt> <dd> <p class="para"> Statement resource, obtained with <span class="function"><a href="function.mssql-init.html" class="function">mssql_init()</a></span>. </p> </dd> </dl> </p> </div> <div class="refsect1 returnvalues" id="refsect1-function.mssql-free-statement-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.mssql-free-statement-examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example" id="example-1810"> <p><strong>Example #1 <span class="function"><strong>mssql_free_statement()</strong></span> example</strong></p> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br /></span><span style="color: #FF8000">// Create a new statement<br /></span><span style="color: #0000BB">$stmt </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_init</span><span style="color: #007700">(</span><span style="color: #DD0000">'test'</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Bind values here and execute the statement<br /><br />// once we're done, we clear it from the memory<br />// using mssql_free_statement like so:<br /></span><span style="color: #0000BB">mssql_free_statement</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> </div> </p> </div> <div class="refsect1 seealso" id="refsect1-function.mssql-free-statement-seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><span class="function"><a href="function.mssql-bind.html" class="function" rel="rdfs-seeAlso">mssql_bind()</a> - Adds a parameter to a stored procedure or a remote stored procedure</span></li> <li class="member"><span class="function"><a href="function.mssql-execute.html" class="function" rel="rdfs-seeAlso">mssql_execute()</a> - Executes a stored procedure on a MS SQL server database</span></li> <li class="member"><span class="function"><a href="function.mssql-init.html" class="function" rel="rdfs-seeAlso">mssql_init()</a> - Initializes a stored procedure or a remote stored procedure</span></li> <li class="member"><span class="function"><a href="function.mssql-free-result.html" class="function" rel="rdfs-seeAlso">mssql_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.mssql-free-result.html">mssql_free_result</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.mssql-get-last-message.html">mssql_get_last_message</a></div> <div class="up"><a href="ref.mssql.html">Mssql Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>