I've been working on my website for a few years now. It uses SESSION management. I am using: php4.3 version. A problem I have had for awhile now is that all session information is lost if a page does not fully load. This wouldn't be an issue, except on every page load I create a MySQL link id for that page load, and store the object in a SESSION varriable:
$db = new db("mydatabase");
$_SESSION["db"] = $db;
Then throughout the website code, I'll simply call: $q = $_SESSION["db"];
This is causing my pages to fail ( I have the queries wrapped to send users to an error page if there is a DB issue ).
The reason I attempt to store the database object in a SESSION is because there are quite a number of databases in a single page load that can be called. I don't want to spend time opening a new DB connection for every query to the database. A single page load could have up to 15 queries to output the data and use up to 10 different databases (not tables) to produce the output.
Recomendations on how to fix my problem are much appreciated. If more data is needed to assist in debugging, just let me know.
Thank you, Calvin Ellis webmaster: http://www.mudmagic.com/
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
