Simple Read/Modify/Write lock using a DateTime column ModifyLocked is our lock column, defined as datetime, default Null.
Category: EXAMPLES
HTML Forms Update Database
INSERT from and HTML form
Text field used to store limited number of old events
Event Logging Table
A table used to store recent special events so db admins can see whats happening for instance. Add event to table
Universal Settings Table
Table Design RecordId Auto Increment int (unisigned) Primary Key SettingName varchar SettingValue text Is A Setting Enabled? //—– CHECK IF UPLOADS ARE ENABLED CURRENTLY —– $QueryString = @mysql_query("SELECT SettingValue FROM tblApiSettings WHERE SettingName = 'ArchiveDataUploadsEnabled'"); $result = @mysql_fetch_array($QueryString); $UploadsEnabled = $result[‘SettingValue’]; $UploadsEnabled = filter_var($UploadsEnabled, FILTER_VALIDATE_BOOLEAN); if (!$UploadsEnabled) die("Quitting – Uploads import is currently disabled"); Is […]