ID: 16495
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: Feature/Change Request
Operating System: FreeBSD
PHP Version: 4.1.2
New Comment:
I think you can't accurately implement the tracking of which database
you're currently using. As long as you are using mysql_select_db() it's
possible to track it with the current mysql resource context. But if
you issue a mysql_query() like "use another_db" you're getting out of
sync.
Previous Comments:
------------------------------------------------------------------------
[2002-04-26 09:27:54] [EMAIL PROTECTED]
Would it be possible to add a flag to the end of the function call to
specify that you want it to return the name of the previously selected
db? eg:
$old_db_name = mysql_select_db('somedb', RETURN_OLD_DBNAME);
?
------------------------------------------------------------------------
[2002-04-08 11:55:20] [EMAIL PROTECTED]
True, but given that currently the only possible values the function
can return are TRUE or FALSE, it seems unlikely that anyone would
actually do that. Is there any other way to get the name of the current
db inside a function without using global?
------------------------------------------------------------------------
[2002-04-08 11:45:32] [EMAIL PROTECTED]
Well, I can see.
If someone wrote
if (true === mysql_select_db( ...
it's broken (and the API has been long this way).
------------------------------------------------------------------------
[2002-04-08 11:37:30] [EMAIL PROTECTED]
Would it be possible for mysql_select_db() to return the previously
selected db on success, and false (as it does already) on failure? That
would make it more useful for times when you want to use another db
temporarily, eg:
function auth() {
// choose the auth db
$old_db_name = mysql_select_db('authdb');
// ... code to authenticate a user here ...
// change back to whatever was being used before
mysql_select_db($old_db_name);
}
I can't see how adding this would break any existing scripts, either,
as the returned value would still have to be true (you can't create
databases called '' in mysql, can you?).
regards,
Peter Lowe.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=16495&edit=1
