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
FieldSUPPLIERID
TitleSupplier
Lookup Valuesselect supplierid,companyname from suppliers
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