#35993 [Opn->Bgs]: mysql_query doesnt honor database resource id

ID: 35993 Updated by: tony2001@php.net Reported By: andreas at fink dot org -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: MacOS X & Linux PHP Version: 5.1.2 New Comment: $db1_handle=mysql_pconnect("127.0.0.1","test","test"); $db2_handle=mysql_pconnect("127.0.0.1","test","test"); These two calls effectively return THE SAME connection identifier (because connect details are the same). Use mysql_connect() with 4th parameter set to TRUE to force creation of new connection. No bug here. Previous Comments: ------------------------------------------------------------------------ [2006-01-13 12:14:49] andreas at fink dot org used configure statement: export CC="gcc" export CFLAGS="-DBIND_8_COMPAT=1 -DEAPI -O3 -fno-omit-frame-pointer" ./configure --mandir=/usr/share/man --with-mysql=/usr/local/mysql \ --enable-dba --enable-track-vars --with-sockets \ -enable-libxml --enable-calendar --enable-ftp \ --with-apxs=/usr/sbin/apxs --enable-cli --disable-cgi \ --disable-dependency-tracking ------------------------------------------------------------------------ [2006-01-13 12:08:46] andreas at fink dot org Description: ------------ When you use multiple connections to mysql databases, you should use a resource id in your query which you got back at the time of connection. However this doesnt work anymore. The queries always go to one database. Reproduce code: --------------- mysqladmin create test1 mysqladmin create test2 mysql << --EOF-- use test1 CREATE TABLE \testdata\ (\id\ int(20) NOT NULL auto_increment,\data\ varchar(255) NOT NULL default '', PRIMARY KEY (\id\) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; grant all on test1.* to 'test'@'localhost' identified by 'test'; insert into test1.testdata(id,data) values (1,'This is DB named test1'); use test2 CREATE TABLE \testdata\ (\id\ int(20) NOT NULL auto_increment,\data\ varchar(255) NOT NULL default '', PRIMARY KEY (\id\) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; grant all on test2.* to 'test'@'localhost' identified by 'test'; insert into test2.testdata(id,data) values (1,'This is DB named test2'); --EOF-- now launch php on this: <? $db1_handle=mysql_pconnect("127.0.0.1","test","test"); mysql_select_db("test1",$db1_handle); $db2_handle=mysql_pconnect("127.0.0.1","test","test"); mysql_select_db("test2",$db2_handle); $query = "select data from testdata where id=1"; $result1 = mysql_query($query,$db1_handle); $line = mysql_fetch_row ( $result1 ); echo "This query was executed on db1_handle:" .$line[0] ."\n"; $query = "select data from testdata where id=1"; $result2 = mysql_query($query,$db2_handle); $line = mysql_fetch_row ( $result2 ); echo "This query was executed on db2_handle:" .$line[0] ."\n"; ?> Expected result: ---------------- This query was executed on db1_handle:This is DB named test1 This query was executed on db2_handle:This is DB named test2 Actual result: -------------- On Linux i386: This query was executed on db1_handle:This is DB named test2 This query was executed on db2_handle:This is DB named test2 On MacOS X PPC: This query was executed on db1_handle:This is DB named test1 This query was executed on db2_handle:This is DB named test1 Interesting enough that i386 and ppc are exactly reversed. This might hint to a location which is endian sensitive. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35993&edit=1