Hi David,
I have not found a PDO equivalent to mysqli_select_db().
We do not have an equivalent in the MySQL PDO adapter.
http://php.net/pdo
The new ZF mysqli DB adapter by Eugene Panaitov
found in the incubator/ of the developer release could
be extended to provide what you seek.
http://framework.zend.com/issues/browse/ZF-381
Cheers,
Gavin
P.S. We should be posting DB stuff to [EMAIL PROTECTED]
David Brännlund wrote:
I'm afraid that this solution isn't possible in our case. We use
replication (in MySQL) for one of the databases but not the other. If
we use the prefix method, the records won't be replicated correctly.
We need to do an actual database change in order for it to work.
It would be nice to be able to change database with something like
$db->setParam("dbname", "somename") on the Zend_Db_Adapter. I tried
changing the dbname directly with $db->_config["dbname"], but the
config property is set as protected.
I have set up one adapter for each database for now, and it works
fine. I'm not sure if it's the best way to do it, though. Will doing
so result in two concurrent database connections?
Thanks for your help,
David Brännlund
Web & Database Development
COMSOL AB, Sweden
Mislav Marohnić wrote:
You don't even need to switch databases. Put a database prefix to the
tables:
UPDATE other_db.mytable SET blah blah ...
It should work.
-M
On 10/9/06, * David Brännlund* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi everyone,
I have a class extending Zend_Db_Table with a bunch of methods
doing all
kinds of things. In one of the methods I need to update data in a
different database. That database exists on the same server, so
normally
I would call mysql_select_db(dbname).
How would I do this in ZF using Zend_Db?
David Brännlund
Web & Database Development
COMSOL AB, Sweden
