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

More Examples:   View Source:   Simple Category Table Demo

Free Download

  PHPLens
E Srch
(E) (e)CategoryName (e)Description
1BeveragesSoft drinks, coffees, teas, beers, and ales
2CondimentsSweet and savory sauces, relishes, spreads, and seasonings
3ConfectionsDesserts, candies, and sweet breads
4Dairy ProductsCheeses
5Grains/CerealsBreads, crackers, pasta, and cereal
6Meat/PoultryPrepared meats
7ProduceDried fruit and bean curd
8SeafoodSeaweed and fish
  PHPLens (Page 1)  
E Srch

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