Singletons

[aboldock]

Hi,

I other OO languages one can use a singleton class, basically it allows you to have only one instance of a class that all other code can use, What I need to do is query a DB and retrieve a bunch of info that doesn't change (config info) that I would like to store in an array and be able to refer to this object in all pages without getting it to reload (for efficency) ie, the Object would be instatiated at startup and not change but be accessable from every PHP page.

In Java this is really easy using the singleton pattern. I understand I could instantiate one for each user and put it into their session, but again this seems ineficient when one for the whole system would be fine.

Thanks folks for any help
Alan
(A Java programmer... but I'm getting over it!)

[xmatthawkx]

Make a file called functions.php or something, and throw this function in there.

function loadconfig()
{
$mydb = mysql_pconnect($dbhost,$dbuser,$dbpass);
if (!$mydb) { die("Couldn't connect to the database."); }
mysql_select_db($dbname);

$result = mysql_query("SELECT * FROM dbname WHERE something='$thisvariable'");
if (!$result) { die("error getting stuff"); }
global $configdata
$configdata=mysql_fetch_array($result);
}

Then, include the functions.php script in all other php files and only call the function once (to read data). Once the function has been called, the $configdata array will be filled, and it can be called by any script (that has included functions.php) like this:

echo ($configdata["columnname"]);

Be sure to change all those variables and stuff.

Good luck!