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   ?  
FieldPICTURE   Type: blob[65535]   Change Type
Default Title
Grid Title
Edit Title 2 Fields in Row
New Title 2 Fields in Row
Edit Notes
Use {KEY} to incorporate primary key, and prefix ?EDIT? or ?NEW? to display note only in EDIT or NEW state
Detail Title 2 Fields in Row
Filter Title
Input Dimensions
(suggested size: 40 x 3)
Columns:   Rows:

Power Lens
Lookup Values
Input Type       Enter a lookup to allow check boxes and radio buttons
# check/radio columns
Overlib Text
Search Lookup when editing
Matching above sql with fields
Minimum character length   Search mode   Hide key code
 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
Optional Editable ColumnEnabled when Column   has value Enter A^B^C, or * for any non-empty value
Power Edit Lens
Grid TD Attributes   (nowrap, width=30%, align=center etc.)
Cell Color grid^title^input  
Color Reference opens in a new window

Section Break Title
Back color   CSS class

WYSIWYG Editor for fields that accept HTML
Do not convert
Special Chars
This Field supports Double-Byte (eg Chinese, Japanese) and HTML tags
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
PHPLens: 4.9.2   Data: 0.02   DB: mysql   adodb: 4.62   Compat: 2   PHP: 5.2.17   OS: Linux
License Type: Enterprise   ID: (Natsoft;John Lim;   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.


Some categories do not have pictures currently.

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

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


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