I’d like to have constants in PHP which are retrieved from a database. Essentially, I’d like to create a page that can update this database table so the next time I load the site, it will use these newly updated constants which are again retrieved from the database.
I’m looking for things that can be changed directly by the admin without needing to go into the source code and manually changing the hardcoded constants file.
- Managing Spam via IMAP
- Computer Virus On My Computer- Never!
- How To Determine The Origin Of Spam?
- 2008: Major Concerns for Network and Systems Administrators
- Spam Filtering
- How Anti Spam Software Works
- How Bayesian Spam Filters Work
- Google’s Tag To Remove Content Spamming
- What is the Point of Do-follow Links on Blogs?
- MBR_CHECKSUM_MISMATCH Hard Drive Error and Recovery
Make a settings file and put this in it (settings.php)
< ?php
$cfg_server="serveraddress";
$cfg_database="dbname";
$cfg_username="username";
$cfg_password="dbpassword";
?>
Now just put this in any file that needs to access the database
include (“settings.php”);
$link = mysql_connect(“$cfg_server”,”$cfg_userna…
or die(“error “);
mysql_select_db (“$cfg_database”, $link)
or die(“error “);
Define a table with two columns:
CREATE TABLE IF NOT EXISTS myconfigtable
(
valueName varchar(50) collate utf8_unicode_ci NOT NULL
value varchar(50) collate utf8_unicode_ci NOT NULL
);
Then, fetch the necessary records from the database by simple SQL:
SELECT valueName, value
FROM myconfigtable
WHERE valueName = “myconfigparameter1″
ETA: The other option is to place a PHP file that is included within your web pages into a directory where it can be modified by using the fopen(), readfile(), writefile() functions already available in PHP