: Search Demo

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

Index Column Name Actual Type PHPLens Type

1 PRODUCTID int[11] R: Autonumber

2 PRODUCTNAME string[120] C: Character

3 SUPPLIERID int[11] I: Integer

4 CATEGORYID int[11] I: Integer

5 QUANTITYPERUNIT string[60] C: Character

6 UNITPRICE real[22] N: Numeric

7 UNITSINSTOCK int[11] I: Integer

8 UNITSONORDER int[11] I: Integer

9 REORDERLEVEL int[11] I: Integer

10 DISCONTINUED int[1] I: Integer

11 NOTES blob[196605] X: Text

12 ORDERDATE date[10] D: Date

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!

More Examples: View Source: Search Demo

Free Download

Notes