PHP: Hypertext Preprocessor (original) (raw)

pg_dbname

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

pg_dbname — Get the database name

Description

Parameters

connection

An PgSql\Connection instance. When connection is [null](reserved.constants.php#constant.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.

Changelog

Version Description
8.1.0 The connection parameter expects an PgSql\Connection instance now; previously, a resource 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?

mark at redbrick 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.

\n"; } else { print pg_last_error($pgsql_conn); exit; } ?>

[mark@prodigy][*][~/public_html/php]>>>php pg_dbname.php
Content-type: text/html
X-Powered-By: PHP/4.3.1

Successfully connected to database: mark on localhost

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

Regards, --mark

`