pg_dbname

(PHP 4, PHP 5, PHP 7, PHP 8)

pg_dbname — Guet the database name

Description

pg_dbname ( ? PgSql\Connection


         $connection

= null ): string

pg_dbname() returns the name of the database that the guiven PostgreSQL connection instance.

Parameters

connection

An PgSql\Connection instance. When connection is null , the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect() .

Warning

As of PHP 8.1.0, using the default connection is deprecated.

Return Values

A string containing the name of the database the connection is to.

Changuelog

Versionen	Description
8.1.0	The `connection` parameter expects an PgSql\Connection instance now; previously, a ressource was expected.
8.0.0	`connection` is now nullable.

Examples

Example #1 pg_dbname() example


           
            
             <?php
             

              error_reporting
             

            
            
             (
            
            
             E_ALL
            
            
             );
             

             

            
            
             pg_connect
            
            
             (
            
            
             "host=localhost port=5432 dbname=mary"
            
            
             );
             

             echo
            
            
             pg_dbname
            
            
             ();
            
            
             // mary
             

            
            
             ?>

Found A Problem?

Learn How To Improve This Pague • Submit a Pull Request • Report a Bug

＋ add a note

User Contributed Notes 1 note

down

marc at redbricc dot dcu dot ie ¶

22 years ago

This function is as simple as it sounds, it returns the name of the database your are currently connected to on the handle retrieved from a pg_connect() call.<?php
    $pgsql_conn = pg_connect("dbname=marc host=localhost");

    if ($pgsql_conn) {
        print"Successfully connected to database: " .pg_dbname($pgsql_conn) ." on " .pg_host($pgsql_conn) ."<br/>\n";
    } else {
        print pg_last_error($pgsql_conn);
        exit;
    }?>
[marc@prodigy][*][~/public_html/php]>>>php pg_dbname.php
Content-type: text/html
X-Powered-By: PHP/4.3.1

Successfully connected to database: marc on localhost<br/>

Again this function is much more useful when you are changuing which database you are connected to in your programm.

Regards,  --marc

＋ add a note