ID: 12885 Updated by: jah Reported By: [EMAIL PROTECTED] Old Status: Open Status: Analyzed Bug Type: Documentation problem Operating System: win98 PHP Version: 4.0.6 New Comment: This problem seems to stem from the fact that different databases have a different notion of a connection. Some have just a connection to the database engine and there is a possibility to change the database within a connection, like MySQL, and others think the connection to be to a specified database. Personally, I think what 'a persistent connection' means with different databases should be clarified with each case and the current implementation left as it is. Although I can think about the problems it will cause to the people writing any kind of database abstration layers... :( I'd say that there just isn't a *simple* solution to this problem. Hints about a complex solution appreciated. Previous Comments: ------------------------------------------------------------------------ [2001-08-21 17:03:13] [EMAIL PROTECTED] When I did the following: 1. handle a = pconnect to a mysql db, say user "root", no password, host=localhost 2. select database "a" 3. handle b = pconnect to same mysql db, user "root", no password, host=localhost 4. select database "b" If i run a query against the database using handle a, it will have database b selected. However, the manual says on persistent connections: <quote> An important summary. Persistent connections were designed to have one-to-one mapping to regular connections. That means that you should always be able to replace persistent connections with non-persistent connections, and it won't change the way your script behaves. It may (and probably will) change the efficiency of the script, but not its behavior! </quote> This does *not* hold true, at least for mysql persistent connections in that case. If this behaviour is not by design in 4.0.6 on Win 98, I will be happy to provide more information if required. ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=12885&edit=1
