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

More Examples:   View Source:   Scan Data as it is Displayed

Free Download

The list of items below need to be reordered and are scanned by the readprodstock() function (View Source):

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
FieldCATEGORYID   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
Input Dimensions
(suggested size: 16)
Columns:

Power Lens
Lookup Values
Input Type      
   
# 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 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
Do not convert
Special Chars
This Field supports Double-Byte (eg Chinese, Japanese) and HTML tags
Must FillNo   * Must Fill Columns
Read OnlyNo   - Read Only Columns
Visible in GridNo   Grid 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(CATEGORYID),max(CATEGORYID) 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

The powerLens is called everytime we want to display information. This feature can be used to scan the database for particular values. The only issue is that powerLens checks only visible records. To check all records, see [to be done...]
email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800