note 62646 added to features.persistent-connections

From: Date: Mon, 06 Mar 2006 11:43:05 +0000
Subject: note 62646 added to features.persistent-connections
Groups: php.notes 
Request: Send a blank email to php-notes+get-104894@lists.php.net to get a copy of this message
If you have multiple databases on the same server AND you are using persistent connections, you MUST prefix all the table names with the specific database name. Changing the database using the xxx_select_db functions alters the database for the connection for all users who are sharing that connection (assuming PHP is running shared and not CGI/CLI). If you have 2 databases (live and archive) and your script is talking to both, you cannot use 2 persistent connections and change the database for each one. Internally, persistent connections are used even if you do not specify that you want to use persistent connections. This is why new_link was added to mysql_connect/mssql_connect (PHPV4.2.0+). ---- Server IP: 66.163.161.117 Probable Submitter: 83.104.121.66 (proxied: 1.1 BANDEXCH) ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/features.persistent-connections.php Edit -- http://master.php.net/note/edit/62646 Del: integrated -- http://master.php.net/note/delete/62646/integrated Del: useless -- http://master.php.net/note/delete/62646/useless Del: bad code -- http://master.php.net/note/delete/62646/bad+code Del: spam -- http://master.php.net/note/delete/62646/spam Del: non-english -- http://master.php.net/note/delete/62646/non-english Del: in docs -- http://master.php.net/note/delete/62646/in+docs Del: other reasons-- http://master.php.net/note/delete/62646 Reject -- http://master.php.net/note/reject/62646 Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#104894) next »