Re: Getting database name from link identifier

On 2/25/2014 5:22 PM, Aziz Saleh wrote:

On Tue, Feb 25, 2014 at 5:21 PM, Larry Martell <larry.martell@gmail.com>wrote:

On Tue, Feb 25, 2014 at 5:15 PM, Larry Martell <larry.martell@gmail.com> wrote:

On Tue, Feb 25, 2014 at 5:09 PM, Aziz Saleh <azizsaleh@gmail.com> wrote:

On Tue, Feb 25, 2014 at 4:59 PM, Larry Martell <larry.martell@gmail.com wrote:

On Tue, Feb 25, 2014 at 4:53 PM, Aziz Saleh <azizsaleh@gmail.com>

wrote:

On Tue, Feb 25, 2014 at 4:47 PM, Larry Martell <

larry.martell@gmail.com>

wrote:

On Tue, Feb 25, 2014 at 4:41 PM, Aziz Saleh <azizsaleh@gmail.com> wrote:

On Tue, Feb 25, 2014 at 4:28 PM, Larry Martell <larry.martell@gmail.com> wrote:

Is there any way to find out what database I am connected to

from a

link identifier? I have some code this does this: @ $db = mysql_pconnect($dbserver, $dbuser, $dbpass); @ mysql_select_db($dbname, $db); I know at the time this is executed $dbname is what I want it to

be.

But later on when I pull data using $db, I get data from a

different

database. If I try to echo $db at the time of the query I get "Resource id #5". Can I get the database name from $db?

You won't be able to, you will need to execute a query on that DB connection handler to check the DB name currently used: SELECT DATABASE() as DB_NAME

Thanks! Indeed I am not 'using' the db that $dbname is set to when I execute the mysql_select_db command. Now I just have to figure out

why

that is.

Are you making a call to mysql_select_db besides the above during

your

code execution (even on a different DB handler)? If yes, then that would

be

the issue since.

I was simplifying the code for purposes of asking the question. Actually the app connects to 23 different databases on different servers. The link identifiers are stored in an array. Each mysql_select_db is called with a different link identifiers. I am echoing out the link identifiers and the array index when I create them and also when I use them. I see that the index is the same, the resource id # is the same, but I'm connected to a different db then the one I called mysql_select_db with.

Is it safe to assume that that all of those 23 connections have

different

host/user/password combination?

No, there are multiple connections on each server.

I ran into issues before, where changing the database using the mysql_select_db function changed the db for the connection for all

users who

are sharing that connection - PHP was running as apache module and not

cgi.

I ended up using mysql_connect with the third param as true to force a

new

connection.

I'm using mysql_pconnect, which does not have the new_link param. Sounds like you've hit the problem I'm having. I'll try changing to mysql_connect with new_link true and see if that fixes it.

That indeed was it. I changed to mysql_connect with new_link true and the issue went away. Thanks very much!

You are welcome. Glad it worked out. Also there is this:

|<?php function mysql_current_db() {

    $r=  mysql_query("SELECT DATABASE()")  or  die(mysql_error());
    return  mysql_result($r,0);

} ?>|