Re: Getting database name from link identifier

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. Thanks!