Hi Charles, I had this problem a while ago, when you try to create the second connection to the database with the same login credentials, i.e username and password. If mysql / php detect there is a connection already established with those details it will return that specfic resouce and not create an new connection. The only way around this is to create a new username + password for this database and use those details to generate the second connection. Hth Jarratt On 9/29/05, Miguel Guirao <miguel.guirao@xxxxxxxxxxxxxxx> wrote: > > > > I agree with this solution!! > > -----Original Message----- > From: Micah Stevens [mailto:micah@xxxxxxxxxxxxxxxxxx] > Sent: Jueves, 29 de Septiembre de 2005 01:10 p.m. > To: php-db@xxxxxxxxxxxxx > Subject: Re: Connecting to two MySQL databases > > > I don't see a reason to duplicate the class code, just make it keep track > of > the $link variable, and each instance of the class can be a seperate > connection.. Then you can do what you want: > > $db1 = new dbconn; > $db2 = new dbconn; > > $db1->dbconn($host, $user, $pw); > $db2->dbconn($host2, $user2, $pw2); > > $result_from_first_db = $db1->retrieveData($sql); > $result_from_second_db = $db2->retrieveData($sql); > > > You're making the class too specific. IMHO. > -Micah > > > On Thursday 29 September 2005 10:56 am, Charles Kline wrote: > > Hi all, > > > > I am working on an application that requires me to connect to two > > MySQL databases both hosted on the same server. > > > > I have an existing set of class files I created to handle the db > > connection to the main database. To connect to the second database, I > > duplicated my db class files and renamed them, and also renamed the > > functions etc. but what is happening, is that the calls made to the > > second database connection seem to get made against the first > > database. So that I get errors like: dbname.tablename was not found > > (or something like that). > > > > What is the best practice for this? I need to have two open db > > connections for just two little things in my application. > > > > My class files are one makes the connection and the other calls the > > various get and set functions to the db. > > > > Here is what I have for the dbconnect.php class: > > > > class dbconn { > > // database setup. These should be changed accordingly. > > var $dbpath = "localhost"; > > var $dbname = "mydb"; > > var $dblogin = "test"; > > var $dbpass = "test"; > > > > > > function dbconn() { > > $link = mysql_connect($this->dbpath, $this->dblogin, $this- > > > > >dbpass) or die ('Not Connected: ' . mysql_error()); > > > > mysql_select_db($this->dbname, $link) or die ('Can\'t use this > > database: ' . mysql_error()); > > > > } > > > > function retrieveData( $sql ) { > > $rs = mysql_query( $sql ) or die("Invalid query: " . mysql_error > > ()); > > // if no result, return null > > if (($rs == null) || (mysql_num_rows($rs) == 0)) { > > return null; > > } else { > > return ( $rs ); > > } > > } > > > > function insertData( $sql ) { > > mysql_query( $sql ); > > // return new complaint id if insert is successful > > if ( mysql_affected_rows() > 0 ) { > > return ( mysql_insert_id() ); > > } else { > > return null; > > } > > } > > > > function updateData( $sql ) { > > $rs = mysql_query( $sql ); > > if (mysql_affected_rows() > 0) { > > return ( $rs ); > > } else { > > return null; // no changes were made > > } > > } > > } > > > > > > I posted this to the php-general list the other day, but never got it > > working right with the suggestions. Sorry if this is a repeat for > > anyone. > > > > - Charles > > > > -- > > RightCode, Inc. > > 900 Briggs Road #130 > > Mount Laurel, NJ 08054 > > P: 856.608.7908 > > F: 856.439.0154 > > E: ckline@xxxxxxxxxxxxx > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > Este mensaje es exclusivamente para el uso de la persona o entidad a quien > esta dirigido; contiene informacion estrictamente confidencial y legalmente > protegida, cuya divulgacion es sancionada por la ley. Si el lector de este > mensaje no es a quien esta dirigido, ni se trata del empleado o agente > responsable de esta informacion, se le notifica por medio del presente, que > su reproduccion y distribucion, esta estrictamente prohibida. Si Usted > recibio este comunicado por error, favor de notificarlo inmediatamente al > remitente y destruir el mensaje. Todas las opiniones contenidas en este mail > son propias del autor del mensaje y no necesariamente coinciden con las de > Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, > controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no > contiene acentos. > > This message is for the sole use of the person or entity to whom it is > being sent. Therefore, it contains strictly confidential and legally > protected material whose disclosure is subject to penalty by law. If the > person reading this message is not the one to whom it is being sent and/or > is not an employee or the responsible agent for this information, this > person is herein notified that any unauthorized dissemination, distribution > or copying of the materials included in this facsimile is strictly > prohibited. If you received this document by mistake please notify > immediately to the subscriber and destroy the message. Any opinions > contained in this e-mail are those of the author of the message and do not > necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any > of its control, controlled, affiliates and subsidiaries companies. No part > of this message or attachments may be used or reproduced in any manner > whatsoever. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
