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

More Examples:   View Source:   Simple Category Table Demo

Free Download

This is the simplest PHPLens code possible. This demo is set up in less than 2 minutes. You just have to define where the data comes from using the Grid Builder. See an animated Grid Builder demo.

To find out how easy it is to set up phpLens, check out our dynamic editing features. If you click on the red icon you can configure and change colours dynamically. Here is an animated tutorial showing how it is done.

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   ?  
 
Cancel
FieldCATEGORYID   Type: int   Change Type
Default Title
Grid Title
Edit Title 2 Fields in Row
New Title 2 Fields in Row
Edit Notes
Detail Title 2 Fields in Row
Filter Title

Power Lens
Lookup Values
Overlib Text
Search Lookup when editing
Matching above sql with fields
Minimum character length   Search mode   Hide key code
Validation
 X: 0-9 A-Z             x: 0-9 A-Z optional       Z: 0-9 A-Z _            z: 0-9 A-Z _ optional
#: 0-9 9: 0-9 optional +: positive numbers only
&: any character ?: any character optional \: escape character >: to uppercase <: to lowercase =EMAIL: email validation
Validation Error Msg
Default New Value
Prefix value with = to execute PHP code and % for SQL function
Power Edit Lens
TD Attributes   (nowrap, width=30%, align=center etc.)
Cell Color  
Color Reference opens in a new window

Section Break Title
Back color   CSS class

WYSIWYG Editor for fields that accept HTML
Must FillNo   * Must Fill Columns
Read OnlyNo   - Read Only Columns
Visible in GridYes   Grid Columns
Visible in DetailsNo   Detail Columns
Visible in New RecordYes   * New Record Columns
Visible in Edit RecordYes   * Edit Columns

Charting
Chart ImagesGIF/JPEG file:
Image for negative values (only for bar chart):
Chart DimensionsWidth:   Height:
Chart Min/Max (SQL)SQL to get Min/Max field values:
Example SQL: select min(CATEGORYID),max(CATEGORYID) from categories
Chart Min/Max (manual)Minimum field value:   Maximum field value:
Use manual entry if Chart Min/Max (SQL) left empty
Icon Chart ScaleOne icon/character represents unit(s)
  Cancel
PHPLens: 4.9.0   Data: 0.02   DB: mysql   adodb: 4.62   Compat: 2   PHP: 4.3.10   OS: Linux
License Type: Enterprise   ID: (Natsoft;John Lim;jlim@natsoft.com)   Valid Till: Never Expires

Once you are in the dynamic editor, you will find the parameters that you can configure for displaying the data below the place where you configure the colors. The most basic and primary thing you have to configure here is where the data is coming from. E.g. You will find in the SQL field: "select * from categories". Once you have configured that, you are all set to go. If you are not familiar with SQL commands, click on List Tables just below the SQL field. A list of tables will be displayed with corresponding SQL commands.

(Note: For security reasons, we have disabled updating of the phpLens setting for our demos on this site. However, these features are available in our free downloads).

That's as simple as it gets. You can display data and pictures. PhpLens handles the display for you. This includes how many records you want to display in one page. This includes also the navigation from page to page. You can even search the records by clicking on the binoculars icon . All that set is set up for you by phpLens.

To configure different parts of phpLens, click on the red , gray , and green icons.

To look at another demo that allows you to edit or update records, try example 300.

Notes

Some categories do not have pictures currently.

Don't forget to setup the session variables by calling session_start() after you include the phplens.inc.php file.

You can click on the icon in the top-right to perform a search.

 

email: info#phplens.com (change # to @)     telephone (malaysia): 60-3 7806 1216     fax (malaysia): 60-3 7806 1210