examples installation setup usage future


pwPage Usage

pwPage logic expects table base tables to make use of uniquely keyed rows.   Unexpected results will surely result otherwise.  The underlying data base system will allow or disallow insertions of rows with duplicate table keys.   Use, in this case, mySQL table creation statements to indicate the column(s) comprising your unique key(s).

Select - Used to Select a Unique Table Row.  Only Review provides the framework for selecting multiple rows.
Insert - Used to Insert New Table Rows.
Update - Used to Update a Unique Table Row. 
Delete - Used to Delete a Unique Table Row.
Review - Used to Select 0 to All Table Rows depending on how much key qualification is used.  As written, pwPage uses right most wild card key definitions.   For example, if your table contained 5 keys:

Then entering a key field column value of 123 and hitting the Review button would select the first three rows; 12345, 12356, 12378.

As mentioned earlier, you can control which columns are reported on your Review output page(s) by providing a hidden field named "review" with a value of "column1; column2, ...", using a comma for output on the same line; semi-colon to output column values on new lines; and a period to terminate the review column series.

You can generalize this feature a bit by merely making your "review" field an enterable text value whereby you can enter which values you wish to Review processing to report.  Then you can change your output from one execution to the next.  In this instance, there should be no table column named "review"; the HTML page field is sufficient.

Note:  Additional details of usage can be found on Example 1 and/or Example 2 pages.

Home ]

Copyright 1996 - 2000 Phil Welch.  All Rights Reserved.

Last modified: September 10, 2000