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

More Examples:   View Source:   Live Demo - Charting UnitsInStock

Free Download

The following example displays a list of products, with bar charts of units in stock.

This is a Demo. You can not change anything for security reasons.
Back to Grid     phpLens Settings   Choose   Generate PHP Code   Remove All Settings   ?  
 
IndexColumn NameActual TypePHPLens Type
1PRODUCTID int[11]R: Autonumber
2PRODUCTNAME string[120]C: Character
3SUPPLIERID int[11]I: Integer
4CATEGORYID int[11]I: Integer
5QUANTITYPERUNIT string[60]C: Character
6UNITPRICE real[22]N: Numeric
7UNITSINSTOCK int[11]I: Integer
8UNITSONORDER int[11]I: Integer
9REORDERLEVEL int[11]I: Integer
10DISCONTINUED int[1]I: Integer
11NOTES blob[196605]X: Text
12ORDERDATE date[10]D: Date
 

Notes

We did it in a couple of minutes by generating it with the Grid Builder and then configuring it in our Web browser.

The charting is configured in Column Settings: Stocks. Then we Generated PHP Code, and pasted the code (chartLens and chartParams properties) into ex180.php.

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