[Resolved] accesing database name within php script

[chintupintu03]

hello all,

I have a file, say, "connection.php". In this file following lines are stored.

$hostname = "myhost" ;
$username = "me";
$userpass = "mine";
$dbname = "my_database" ;
$con=mysql_connect($hostname, $username, $userpass) ;
mysql_select_db($dbname,$con) or die("couldn't open database " .mysql_error());

XXXXX

I am including this file in every script file.

How do I verify the database name within any of the script.

This is for testing purpose. I would like to fetch the database name I am accessing and display the name by, say, by usning "ECHO" command.

Anybody will help me out?

[zhabala]

you mean ???

echo $dbname;

[zhabala]

Or you can use SQL statement:

SELECT DATABASE();

this statement

Returns the default (current) database name.
mysql> SELECT DATABASE();
-> 'test'
If there is no default database, DATABASE() returns NULL as of MySQL 4.1.1,
and the empty string before that.