phpLens
 home • products examples manual • faq support forum • contact news • login store

More Examples:   View Source:   Group by Category

Free Download
This is a Demo. You can not change anything for security reasons.
Back to Grid     phpLens Settings  Column Settings   Choose   Generate PHP Code   Remove All Settings   ?  
 
Cancel
FieldPRODUCTID   Type: int   Change Type
Default Title
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

Power Lens
Lookup Values
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 ColumnEnabled 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
Must FillNo   * Must Fill Columns
Read OnlyNo   - Read Only Columns
Visible in GridNo   Grid Columns
Visible in DetailsYes   Detail Columns
Visible in New RecordYes   * New Record Columns
Visible in Edit RecordYes   * Edit Columns

Charting
Chart ImagesGIF/JPEG file:
Image for negative values (only for bar chart):
Chart DimensionsWidth:   Height:
Chart Min/Max (SQL)SQL to get Min/Max field values:
Example SQL: select min(PRODUCTID),max(PRODUCTID) from products
Chart Min/Max (manual)Minimum field value:   Maximum field value:
Use manual entry if Chart Min/Max (SQL) left empty
Icon Chart ScaleOne icon/character represents unit(s)
  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

We set the groupLens property here to group by CategoryID.
email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800