07-Feb-02
Added support for $fdd['field']['values']['db']
Replace call to mysql_fetch_assoc with mysql_fetch_array in PME Setup
05-Feb-02
Tore explicit date support from PME out of frustration--will tackle this later
timestamps are still read-only
04-Feb-02
Fixed logtable schema in PHPMyEditSetup.php
30-Jan-02
Changed filters to use strings instead of arrays
29-Jan-02
Added support for $fdd[col][values]['filters'] when selecting values from another table
Added support for 'graphic' links
28-Jan-02
Added ability to turn off displaying current sort and/or filters in generated include file
Added nowrap to action (first) column if 'link' style is used
25-Jan-02
Added support for MySQL enum type
Added support for MySQL set type
Fixed bug with sort field number zero
Fixed bug in PME Setup w/ wrong name to support language labels in generated .inc file
Fixed bug in PME Setup where generated file was including non-existent header/footer files
Added support in PME Setup for default values MySQL derived from MySQL table description
Fixed date edit form display bug
Added another action--Display Detail. In $opts['options'], it's an 'E' and is on by default
24-Jan-02 - 4.001b1 Many Changes
Added support for a calculated column requires:
$fdd['other']['name']='Col Header';
$fdd['other']['expression']='onHand-ordered';
$fdd['other']['sort']='T:!';
$fdd['other']['select']='T';
$fdd['other']['type']='int';
'other' can be anything, but multiple ones in a single file need to be unique
'expression' can be any valid MySQL expression
'type' should reflect the results of the expression, e.g. 'int' or 'string'
all other options work as with other, normal columns
this kind of column is always read-only
Most of these changes were motivated by using PME in two
medium sized projects.
Setup renamed to PHPMyEditSetup.php
Setup Added functionality:
Ascertains field type from mysql database
Setup displays and attempts to write two files.
These files are written to a configurable directory.
PHPMyEdit.inc Added functionality:
Date and Number filter fields now have in/equality operators
Major date handling changes:
Dates now handled with multiple input fields
Specifiable date ranges (within year ranges only) see 'daterange' option
Can set listing limit to -1 (all rows on page)
Can have multiple initial sort fields which are retained as secondary/tertiary/quaternary/etc. sort fields during normal usage
'format' option is deprecated in favor of two new options:
'datemask' is a PHP date style date format that supports a few of the date macros
'mask' is processed by printf() before displaying
'daterange' accepts a range of years
'maxwidth' is a new option that limits the width of filter fields
'URL' options have been expanded, maybe too far for security comfort
'options' have been expanded to recognize additional params
R -- read-only
P -- password field
H -- hidden field
Not for the faint of heart, trigger support has been added, see discussion in home page docs.
Initial filters capability has been added, also not for the faint of heart. Flexibility was chosen at the cost of ease of use
Default field values are now supported
Updates to a table can now be logged to another table
Call to $MyForm -> execute() moved to end of the PME class initializer because it always gets executed then anyway
Previously unidentified bug fixed where if the coder had referred to the same ['values']['table'] for two different fields would pull (and update) based on the last use of the referenced table. Changed all implicit joins to LEFT OUTER JOINs.
Bug fix where addslashes() wasn't complimented by strip
Bug fix where filtering didn't work where there were slashes in the data
Started moving towards single function which generates SELECT statements
+-+-+-+-+
06-May-01 - 3.5 multilingual version - you can now change all the displayed text
to your local language.
Limited ability to customise the format used for displaying and
entering dates (d/m/y, m/d/y, d.m.y etc). However, dates in filters
must still be entered in MySQL format.
Fixed some bugs introduced when support of column names containing
special characters or reserved words was added (e.g. using 'Date' as
a column name). Note - database and table names may not contain
special characters or reserved words.
Changed handling of 'Cancel' button - thanks Bret (mogul@gealtinous.com)
23-Apr-01 - 3.4 added 'More' button to 'Add' screen to make it easier to enter
multiple records.
23-Apr-01 - 3.3 fixed bug which prevented 'Next' button working when filter had
been activated (oops).
18-Apr-01 - 3.2 added ['select'] = 'M' to allow Multiple values to be selected in
a drop-down list in a filter. The number of values displayed is set
by $multiple (default = 4).
NOTE - $multiple has been added to the call to PHPMyEdit, so this
release is not compatible with calling programs produced by earlier
releases of SETUP.PHP (sorry).
20-Mar-01 - 3.1 added ['options'] to provide full control over which fields appear
on the List, Add, Change, and Delete screens. This replaces 'listview',
which no longer works with this release - i.e.
['options']='ACD' has the same effect as ['listview']=true.
27-Feb-01 - 3.0 PHPMyEdit converted to PHP classes by Pau Aliagas (pau@newtral.com).
This new version will not work with calling programs created by older
versions of SETUP.PHP - you will need to run SETUP.PHP again (sorry).
Added $options='I' - to display records from the table with the
Initial sort suppressed (useful if you have a very large table with
no indexes).
+-+-+-+-+
14-Feb-01 - 2.3 added ['description'] option to ['values']. This considerably
enhances PHPMyEdit's ability to handle multiple tables in a
seamless manner. It also involved a lot of new code, so 2.3
should be considered as more risky than the well-tested 2.2.
10-Feb-01 - 2.2 generate javascript to ensure user enters values for fields
marked as 'required'. SETUP.PHP now marks 'not_null' fields as
'required' by default. By Yusuf Kursat Tuncel (kursat@ttnet.net.tr).
PHPMyEdit.PHP now no longer requires 'sort_open_tag' to be set to
false.
NOTE - to use the filter functionality, you must now have 'F' in
$OPTIONS in your calling program. This is set automatically by
SETUP.PHP in version 2.2, BUT IS NOT BACKWARDS COMPATIBLE (sorry).
02-Feb-01 - 2.1 suppress display of selected fields from the list display but
still allow editing with "listview" property. By Linas Jakucionis
(linas@rl.lt).
12-Jan-01 - 2.0 added filter functionality based on an idea from Chris.
+-+-+-+-+
02-Jan-00 - 1.9 fixed minor bug in display of blank fields as textareas
21-Dec-00 - 1.8 clicking a second time on a column heading causes the sort order
to be reversed - thanks to Paolo Petrini (paolo.petrini@gib.it).
Support multi-line textareas - thanks (again) to Chris Navas.
19-Dec-00 - 1.7 removed restriction that key field must be numeric with $key_type
parameter. Also fixed that not all browsers let you get away with
.
17-Dec-00 - 1.6 split out php and php3 versions.
SETUP.PHP now prompts for the field to be used as a key.
PHPMyEdit can now populate drop down lists from a field in a table.
11-Dec-00 - 1.5 included a local version of an in_array function so PHP Version 3 users
can use the program (thanks to ivo@ibuildings.nl for the code).
10-Dec-00 - 1.4 Added support for textareas to SETUP.PHP and PHPMyEdit. Merci beaucoup
à Chris Navas (mailto:chris@arbo.com) pour ce petit truc.
08-Dec-00 - 1.3 SETUP is now a bit prettier to look at. PHPMyEdit.PHP now allows
you to store HTML etc inside a table (previously it stripped out anything
that looked like code). Note that it displays HTML as HTML - e.g. if
you store this in a table, that's how it will appear on the
screen - not 'this' in bold type.
03-Dec-00 - 1.2 rather more elegant solution to SETUP.PHP problem already fixed
temporarily in 1.1.
Added warning to SETUP.PHP if PHP is not configured correctly for XML.
Added support for "URL" parameter to SETP.PHP and PHPMyEdit.PHP,
to allow 'clickable' links to email, web, ftp, etc. addresses.
Improved handling of magic_quotes within PHPMyEdit.PHP.
29-Nov-00 - 1.1 temporary fix to glaring bug which prevented SETUP.PHP working
with protected MySQL databases