: Nested Table Demo

This is a Demo. You can not change anything for security reasons.

	Cancel
Field	CATEGORYNAME Type: `string[45]` Change Type
Default Title	From category table
Grid Title
Edit Title	2 Fields in Row
New Title	2 Fields in Row
Edit Notes	Use {KEY} to incorporate primary key, and prefix ?EDIT? or ?NEW? to display note only in EDIT or NEW state
Detail Title	2 Fields in Row
Filter Title
Input Dimensions (suggested size: 45 x 1)	Columns: Rows:

Power Lens	<font size=4><b>{CategoryName}</b></font>
Lookup Values
Input Type	Text/Popup ReadOnly Enter a lookup to allow check boxes and radio buttons
# check/radio columns
Overlib Text
Search Lookup when editing
Matching above sql with fields
Minimum character length	Search mode Hide key code
Validation	X: 0-9 A-Z x: 0-9 A-Z optional Z: 0-9 A-Z _ z: 0-9 A-Z _ optional #: 0-9 9: 0-9 optional +: positive numbers only &: any character ?: any character optional \: escape character >: to uppercase <: to lowercase =EMAIL: email validation
Validation Error Msg
Default New Value	Prefix value with = to execute PHP code and % for SQL function
Optional Editable Column	Enabled when Column has value Enter A^B^C, or for any non-empty value*
Power Edit Lens
Grid TD Attributes	(nowrap, width=30%, align=center etc.)
Cell Color	grid^title^input Color Reference opens in a new window

Section Break Title

Back color CSS class

WYSIWYG Editor

for fields that accept HTML

Do not convert
Special Chars

This Field supports Double-Byte (eg Chinese, Japanese) and HTML tags

Must Fill

No * Must Fill Columns

Read Only

No - Read Only Columns

Visible in Grid

Yes Grid Columns

Visible in New Record

Yes * New Record Columns

Visible in Edit Record

Yes * Edit Columns

Cancel

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Notes

This demo shows the use of nested phplens objects. We use a powerLens in the main $lens object to call the ChildLens() function that displays the embedded phpLens object.

Note how we use output buffering to store the child lens. This example requires the commercial version of phpLens as output buffering is disabled in the demo version.

More Examples: View Source: Nested Table Demo

Free Download

Notes