PHP Multi Form Generator (MFG) for use with phpMyEdit, PHP, and MySQL

Select your options below, then click the Submit button

25 May 2008 - Upon request, buyers will receive a complimentary copy of the Alternate MFG Project
via email, usually within 24 hours of purchase. Feedback from recipients of the alternate project are appreciated.

The default options set in this PHP/HTML form will work for most users.

Certain configurable options are now hard-coded in the database connection script (initial setup required).

The Sample Script may help to give you a better idea as to how the following variables are applied.

Primary key column (usually MySQL column number 0)		0
Target filename prefix (restricted for demo purposes)		my_
Include a Field Options "cheat sheet" in scripts, commented out		No Yes
Post-initialize additional code below certain field option arrays using an include file		No Yes
Global Form Options
$opts['sort_field']	Sorting (default column)	0 (1st column) 1 (2nd column) 2 (3rd column)
$opts['inc']	Records per page in list mode	All  1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 20 25 30 35 40 45 50 60 70 80 90 95 100
$opts['options']	Permission options	ACPVDFL ACPVFL VFL
$opts['language']	Language labels	$HTTP_ACCEPT_LANGUAGE Czech German Danish Greek - Hellenic English English - US Spanish Spanish - Argentina Spanish - Mexico Basque French Italian Dutch Polish Portuguese Portuguese - Brazil Russian Swedish Slovak Turkey Chinese - traditional Chinese - Singapore
Field-Specific Options
Field options consist of an array of column attributes. Attributes may be applied to specific page modes (Add, Change, coPy, View, Delete, List, Filter). Attributes are configured individually for each type of MySQL column. With the possible exception of date formatting, the default field options appearing below should meet the needs of most users.
CSS can apply right justification to these fields using 'css' => array('postfix' => 'right-justify'),		Yes
'colattrs' => '',	Output control: Column attributes for CSS/HTML (commented out)	No Yes
'datemask' => 'Y-m-d H:i:s',	TIMESTAMP & DATETIME fields: Y-m-d H:i:s m-d-Y H:i:s d-m-Y H:i:s Y/m/d H:i:s m/d/Y H:i:s d/m/Y H:i:s	No Yes
Basic Options: Guidance help. Optionally add a 3rd cell (Help cell) to Add, coPy, and Change forms. Standard help columns insert basic field info such as "Limit x characters" or "Limit x digits" or date format help. MFG optionally installs a link to a Help popup that fetches "help text" from `mfg_help_data` (help text for the configured table and column). See Help System.
'help|ACP' => '',		omit help standard help column link to Help popup
'input' => 'R',	Apply read-only status to auto_increment and/or TIMESTAMP columns	Yes No
'options' => 'ACPVDFL', Display options are column specific and can be enabled or disabled in various page modes (Add, Change, coPy, View, Delete, Filter, List). "L" is assumed and does not have to be specified. Display "n" columns in List mode. Select 999 to display all in List mode.	auto_increment columns
	TIMESTAMP columns
	All other columns ...
	Except, if the MySQL column number is > 5 6 7 8 9 10 999 suppress the display of the remaining columns from List & Filter modes.
'php' => 'filename.inc',	PHP expressions can be manually configured by advanced users. The effect is to suppress the display of a field value, and run an include file in it's place. Works like Triggers. Consult the documentation.
'required' fields	JavaScript validation	first 3 columns all columns
'size|ACP' => n,	Field size (HTML INPUT tags)	Yes No
'sort' => false,	Sorting disabled for BLOB column titles	Yes No
SQL expressions can be manually configured in the options array, for example: 'sql|LFV' => 'if(FirstName <> "", CONCAT(LastName, ", ", FirstName), LastName)'
'sqlw' => 'TRIM("$val_as")',	Write SQL expressions (e.g. trim, insert null, MD5(), etc.)	Yes
'strip_tags|LF' => true,	Booleans: Stripping tags from displayed BLOB fields in List/Filter mode	omit set true set false
'tabs' => 'col_name',  (Note)	TABs feature (column 0 active, all others commented out)	No Yes
Output control: TEXTAREA sizes 'textarea' => array('rows' => x, 'cols' => y), (cols=58 works well since maximum INPUT size=60)		5  6  7  8  9 10 15 20 25 rows
		58  60  65  70  75  80  85  90  95 100 110 120 130 140 cols
'trimlen|LF' => n, Output control: Character length limit applied to BLOB columns		Omit trimlen  10 characters  15 characters  20 characters  25 characters  30 characters  40 characters  50 characters 100 characters 150 characters 200 characters
Forms will be generated for all tables unless only 1 table is selected below. Take care not to over-write files that you customized by hand after they were originally generated.		Display Only Over-Write Existing
Selecting only one table is useful when you want to quickly create one form.		Output All Tables mfg_change_log mfg_colors mfg_content mfg_customers mfg_employees mfg_help_data mfg_order_details mfg_orders mfg_outlook mfg_products mfg_sql_col_types mfg_streets mfg_suppliers mfg_to_do mfg_user_log
Click the Submit button ONCE, then wait 15-30 seconds

Please install the `change_log` table schema

Execution time: 0.016 seconds

phpMyEdit Documentation
(included with MFG)

	7-day money back guarantee. Within 7 days of the date of purchase, refunds may be granted to any MFG buyer who is dissatisfied with MFG and who communicates valid reasons for requesting a refund. Allow 2-3 days for refund processing, typically via swreg.org, PayPal, or alternative payment method.
Tip: remove the Extended Download Service from the cart at swreg.org
Allow 24 hours for delivery via email when selecting Google Checkout. Payment via SWREG.ORG or PayPal should result in a download link being emailed as soon as the sale is confirmed.