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   Column Settings   Choose   Generate PHP Code   Remove All Settings   ?  

   Colors  General  Editing  Display  Formats  Templates  Titles  Menus  
Color Settings
Color Reference opens in a new window
Top Caption
Caption Background  
Menu Color  
Title Background  
1Odd Rows  
2Even Rows  
3Current Row  
4Row Number Background  
Bottom Caption
Change Color Style:  

Detail Table
Detail Left Column  
Detail Right Column  

Background  

  Warning: saving colors does not save settings from other tabs.

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