<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$TOC_DEPRECATED = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/ref.pgsql.inc";
$setup = array (
  'home' => 
  array (
    0 => 'index.php',
    1 => 'PHP Manual',
  ),
  'head' => 
  array (
    0 => 'UTF-8',
    1 => 'uk',
  ),
  'this' => 
  array (
    0 => 'function.pg-close-stmt.php',
    1 => 'pg_close_stmt',
    2 => 'Closes a prepared statement',
  ),
  'up' => 
  array (
    0 => 'ref.pgsql.php',
    1 => 'PostgreSQL Функції',
  ),
  'prev' => 
  array (
    0 => 'function.pg-close.php',
    1 => 'pg_close',
  ),
  'next' => 
  array (
    0 => 'function.pg-connect.php',
    1 => 'pg_connect',
  ),
  'alternatives' => 
  array (
  ),
  'source' => 
  array (
    'lang' => 'en',
    'path' => 'reference/pgsql/functions/pg-close-stmt.xml',
  ),
  'history' => 
  array (
  ),
);
$setup["toc"] = $TOC;
$setup["toc_deprecated"] = $TOC_DEPRECATED;
$setup["parents"] = $PARENTS;
manual_setup($setup);

contributors($setup);

?>
<div id="function.pg-close-stmt" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">pg_close_stmt</h1>
  <p class="verinfo">(PHP 8 &gt;= 8.5.0)</p><p class="refpurpose"><span class="refname">pg_close_stmt</span> &mdash; <span class="dc-title">Closes a prepared statement</span></p>

 </div>

 <div class="refsect1 description" id="refsect1-function.pg-close-stmt-description">
  <h3 class="title">Опис</h3>
  <div class="methodsynopsis dc-description">
   <span class="modifier">function</span> <span class="methodname"><strong>pg_close_stmt</strong></span>(<span class="methodparam"><span class="type"><a href="class.pgsql-connection.php" class="type PgSql\Connection">PgSql\Connection</a></span> <code class="parameter">$connection</code></span>, <span class="methodparam"><span class="type"><a href="language.types.string.php" class="type string">string</a></span> <code class="parameter">$statement_name</code></span>): <span class="type"><span class="type"><a href="class.pgsql-result.php" class="type PgSql\Result">PgSql\Result</a></span>|<span class="type"><a href="language.types.singleton.php" class="type false">false</a></span></span></div>

  <p class="simpara">
   Closes a prepared statement on the server, freeing its resources and making
   its name available for reuse. It is an alternative to issuing a
   <code class="literal">DEALLOCATE</code> SQL command, which does not allow the statement
   name to be reused afterwards.
  </p>
  <p class="simpara">
   This function is only available if PHP has been built against libpq 17 or
   later.
  </p>
 </div>


 <div class="refsect1 parameters" id="refsect1-function.pg-close-stmt-parameters">
  <h3 class="title">Параметри</h3>
  <dl>
   
    <dt><code class="parameter">connection</code></dt>
    <dd>
     <p class="para">Примірник
<span class="classname"><a href="class.pgsql-connection.php" class="classname">PgSql\Connection</a></span>.</p>
    </dd>
   
   
    <dt><code class="parameter">statement_name</code></dt>
    <dd>
     <p class="simpara">
      The name of the prepared statement to close.
     </p>
    </dd>
   
  </dl>
 </div>


 <div class="refsect1 returnvalues" id="refsect1-function.pg-close-stmt-returnvalues">
  <h3 class="title">Значення, що повертаються</h3>
  <p class="simpara">
   A <span class="classname"><a href="class.pgsql-result.php" class="classname">PgSql\Result</a></span> instance on success, or <strong><code><a href="reserved.constants.php#constant.false">false</a></code></strong> on
   failure.
  </p>
 </div>


 <div class="refsect1 errors" id="refsect1-function.pg-close-stmt-errors">
  <h3 class="title">Помилки/виключення</h3>
  <p class="simpara">
   Throws a <span class="exceptionname"><a href="class.valueerror.php" class="exceptionname">ValueError</a></span> if
   <code class="parameter">statement_name</code> is empty or contains any null bytes.
  </p>
 </div>


 <div class="refsect1 seealso" id="refsect1-function.pg-close-stmt-seealso">
  <h3 class="title">Прогляньте також</h3>
  <ul class="simplelist">
   <li><span class="function"><a href="function.pg-prepare.php" class="function" rel="rdfs-seeAlso">pg_prepare()</a> - Submits a request to the server to create a prepared statement with the
   given parameters, and waits for completion</span></li>
   <li><span class="function"><a href="function.pg-execute.php" class="function" rel="rdfs-seeAlso">pg_execute()</a> - Sends a request to execute a prepared statement with given parameters, and waits for the result</span></li>
  </ul>
 </div>


</div><?php manual_footer($setup); ?>