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

More Examples:   View Source:   Search Demo

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   ?  
Grid Title
FieldUNITSINSTOCK
TitleUnitsInStock
Lookup Values 
Filter Lookup
To generate a popup use:
(1) SELECT distinct SearchCol, DescriptionCol FROM TABLE to list choices.
(2) Enter a list (must begin with=). For example: =No/Yes
Multiple Choice Type
Multi-Choice Dimensions   Checkbox Columns or Multiple Select Height
Default Value
  Cancel
Fields per Row
Horz. Alignment   When this is checked, fields/row is ignored

Notes

To start with the search screen instead of the grid set $lens->firstState = "FILTER".

We also join the SupplierID and CategoryID columns using joinLens so that instead of seeing numbers, we see meaningful descriptions. This works both when filtering and viewing the grid.

We also configure the categories to show as checkboxes by setting filterParams. This filterParams setting was configured in dynamic edit mode, then generating the source code and copying the relevant line into the PHP file. Easy compared to generating it hand!

email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800