how to show current database

[sfullman]

Seems to be a simple question.

mysql_select_db(whatever) will select a specific db.

However, how do I output the current db?

If this function doesn't exist let me know but surely someone has wanted to know this same thing.

Sam

[LordShryku]

Probably an easier way, but you can get it from using SHOW PROCESSLIST

[dniry]

I guess you could use sessions and do something like this:

function selectDb ($db) {
if ($select=mysql_select_db($db) or die "can't connect to $database") {
session_start();
$_SESSION['last_selected_db']=$db
}
return($select);
}

you can then call it at any time, from any other page:

if ($SESSION['last_selected_db']) {
echo $SESSION['last_selected_db'];
}

this will require you to maintain your session by calling sesion_start() on every page though.

[Sxooter]

Originally posted by sfullman
Seems to be a simple question.

mysql_select_db(whatever) will select a specific db.

However, how do I output the current db?

If this function doesn't exist let me know but surely someone has wanted to know this same thing.

Sam

$dbname="bubba";
mysql_select_db($dbname) or die("Problem selecting db $dbname");
print "now using database $dbname";

Or is this getting done in an include file and you don't know what's going on kinda thing?

[csn]

Good Lord, doesn't anybody RTFM? ;P

SELECT DATABASE();

http://www.mysql.com/doc/en/Miscellaneous_functions.html

[LordShryku]

Originally posted by csn
Good Lord, doesn't anybody RTFM? ;P

Well, it looks like you've been around long enough that you should already know the answer to that question :p

[SureFire]

If RTFM means what I think it does, then...VERY DOUBTFULL!!😃