• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • pg_close()

    (PHP 4, PHP 5, PHP 7)

    关闭一个 PostgreSQL 连接

    说明

    pg_close([resource $connection]): bool

    pg_close()关闭由所给资源$connection指定的到 PostgreSQL 数据库的非持久连接。

    Note:

    使用pg_close()并不很必要,因为非持久连接在本脚本执行结束后会自动关闭。

    如果在此连接中打开了 large object 资源,则在关闭所有 large object 资源之前不要关闭连接。

    参数

    $connection

    PostgreSQL database connection resource. When$connectionis not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().

    返回值

    成功时返回TRUE,或者在失败时返回FALSE

    范例

    Example #1 pg_close()例子

    <?php
    $dbconn = pg_connect("host=localhost port=5432 dbname=mary")
       or die("Could not connect");
    echo "Connected successfully";
    pg_close($dbconn);
    ?>
    

    以上例程会输出:

    Connected successfully
    

    参见

    pg_close(...) will not technically close a persistent connection but instead returns it back to the connection pool thus giving you the desired effect of having the connection closed within your script.
    http://www.sitepoint.com/article/accessing-postgresql-php/3
    best wishes to all.
    This function closes the current database connection specified by a handle returned from a pg_connect() call.
    <?php
      $pgsql_conn = pg_connect("dbname=mark host=localhost");
      if ($pgsql_conn) {
        print "Successfully connected to: " . pg_host($pgsql_conn) . "<br/>\n";
      } else {
        print pg_last_error($pgsql_conn);
        exit;
      }
      // Do database stuff here.
      if(!pg_close($pgsql_conn)) {
        print "Failed to close connection to " . pg_host($pgsql_conn) . ": " .
        pg_last_error($pgsql_conn) . "<br/>\n";
      } else {
        print "Successfully disconnected from database";
      }
    ?>
    Of course you normally wouldn't print a message. 
    Regards, --mark