TalkPHP - View Single Post

captainmerton · 11-21-2009, 09:04 AM

I want to build a mysql table to store admin settings for my website. Initially I want to store a setting for:

Website down for maintenance
Switch debug mode on
switch google analystics on
set server timezone

Basically key settings which will have a Y/N setting. As this table will be called once every time a page is built I need to structure it in the most sensible way. I'd call the table and intend to do one read on the entire table (4 rows) and then instantiate an object with 4 properties to handle the settings. Any suggestions - is this the most efficient way to do it?

11-21-2009, 09:04 AM	#1 (permalink)
captainmerton The Acquainted Join Date: May 2009 Posts: 170 Thanks: 8	Admin Settings Table I want to build a mysql table to store admin settings for my website. Initially I want to store a setting for: Website down for maintenance Switch debug mode on switch google analystics on set server timezone Basically key settings which will have a Y/N setting. As this table will be called once every time a page is built I need to structure it in the most sensible way. I'd call the table and intend to do one read on the entire table (4 rows) and then instantiate an object with 4 properties to handle the settings. Any suggestions - is this the most efficient way to do it?