Database Record Selector and Editor

DB-RSE - HISTORY and VERSIONS

Display Layout:

• Table Display = Initial display, and bottom-most portion of results page
• Record Display = Section showing resulting records right above Table Display
• Fields Display - Section showing fields for selected record at top of page

Currently on list of things to do...

• Add "Copy Record" function from Record display (save as new)
• Add "Copy Record" function from Field display
• Add "Add Record" function from Initial display
• Add "Delete Record" function (and confirm) from Field display

v1.33

• 07/19/2007 - Added str_replace for text and textarea fields. Changes quotes to "
• 07/19/2007 - Added htmlspecialchars on UPDATE query. Changes < and > to < and > so images and other html tags aren't parsed. Also converts quotes, so removed reference to previously added "addAslash" function from UPDATE query (but left function in the case someone needs to reference it).

v1.32

• 06/24/2007 - Added "addAslash" function for text and textarea fields
  Users with magic-quotes turned off experienced errors updating records with apostrophes and quotes. This function will now escape apostrophes and quotes prior to updating into record whether magic-quotes are on or off.

v1.31

• 05/02/2007 - Added show/hide toggle for $tableFilter in dbconnect
  Allows to either show or not show tables that contain the $tableFilter filter string

v1.30

• 04/15/2007 - Added $tableFilter in dbconnect for filtering table list
• 04/15/2007 - Added $tableDefHgt in dbconnect for table list height (default is 0 to show all tables)
• 04/15/2007 - Cleaned up table list field selectors so they're all together at the top of the table list

v1.20

• 05/07/2006 - Can now preset initial table (added $tableDefSet variable in dbconnect.php file)
• 04/25/2006 - Added Fields Total alongside Number of Fields for reference
• 03/22/2006 - Made Fields Showing Red if showing less than there are Fields Total
• 03/22/2006 - Added "Delete Record" function (and confirm) from Record display

v1.10

• 03/12/2006 - Added option to specify row number start and number of rows to display
• 03/13/2006 - Table view: Added column for row numbers (sequential, not record number or record ID)
• 03/13/2006 - Table view header: Added total number of rows (records)
• 03/13/2006 - Fixed record save success display - displayed query, but not success note
• 03/13/2006 - Clean up (tweaked) display a little bit

v1.01

• 06/20/2005 - Moved "mysql_select_db" function to the dbconnect.php file
• 06/29/2005 - Removed version number from comments in both .php files
• 06/29/2005 - Added version as variable in main db-rse.php file for easy reference
• 06/29/2005 - Added version variable to document 'Title' tag and to 'H2' heading tag
• 06/29/2005 - Changed H2 tag to small font and maroon
• 06/29/2005 - Added db-rse_versions-log.html (this file) to distribution zip file
• 06/30/2005 - Cleaned and prettied up db-rse_versions-log.html (this file)

v1.00

• Initial release of application