postgresql connection management
| From: | jim white | Date: | Thu, 28 Feb 2008 18:41:14 +0000 |
| Subject: | postgresql connection management | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44689@lists.php.net to get a copy of this message | ||
I am running several web sites on one server, each of which connects to a different Postgresql database. I use some include files to load functions and classes. If I put pg_connect at the start of the include file, then sometimes I do not connect to the correct database from functions in a class. If I run echo pg_dbname(); in these functions I see that I am connected to the wrong database. Here are some possible fixes:
1:
$swdbcon = pg_connect("host=localhost dbname=swgap user=postgres"); //at start of file
global $swdbcon; // inside function
$result = pg_query($swdbcon, $query);
2:
if (pg_dbname() != "swgap") { //inside function
pg_connect("host=localhost dbname=swgap user=postgres");
}
3:
pg_connect("host=localhost dbname=swgap user=postgres"); inside function
I have already written code that does not explicitly set the connection in each function and it worked fine. However, I find the problem occasionally as I change the code. What is the best way to get the proper connection inside functions?
Jim
--
James (Jim) B. White