[clug] PHP gurus? How can I find an "anonymous" mysql resource?

Tony and Robyn Lewis beakysnugger at yahoo.co.uk
Sat Jun 17 14:31:06 GMT 2006


Pardon being OT, but I'm hoping someone on list can help with a PHP problem.

We've got lots of hand-crafted PHP pages, and there is typically one DB 
connection per page.  Now we want to insert ("include") a common set of 
pages that, amongst other things, makes a different DB connection.

Unfortunately, once our included code finishes, the existing MySQL 
connection is a goner, because it was never saved (as in, at 
mysql_connect() time), and up to now it worked, because mysql_query() 
will use the resource of the last mysql_connect().

Is there a way I can essentially put the current MySQL resource (the 
variable associated with the connection) onto a stack (or just save it 
in a var), let the inserted code do its bit, and then restore / pop the 
old resource to be the current resource?

Or is there a better way, other than rewriting the existing code to 
properly save and use the resource?

Please, no sermons - this is inherited code, and I dislike PHP enough 
already.  I especially disrelish the idea of hand-editing scores of PHP 
pages looking for mysql calls.

TIA,

Tony



More information about the linux mailing list