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

More Examples:   View Source:   Simple Category Table 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   ?  

Select New Record Columns

 Hide Cols

    >>    

    <<

Show Cols
Up   Down
 
    Cancel
   

Notes

Now we hide the CategoryID and Picture columns by using the gridLens property. Only columns we want to display are listed here.

$lens->gridLens = "CategoryName;Description";

You can also hide the columns dynamicly by clicking on the [pict here] button and selecting the columns you want to see in the grid [picture here]

For best performance, instead of hiding columns, only retrieve the columns you need. In SQL, use:
SELECT categoryname, description FROM categories

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