: Example Scripts

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

Free Download

We recommend that you start with the overview of the Grid Builder
which is a web-based wizard to create phpLens forms.

Live working examples

Edit with Hot Updates

Export to Excel/CSV

Editing Records & Google-style Scrolling

Charting Numeric Columns

MS Outlook UI

Calendar

Animated Tutorials

Changing Colors

Change Column Name

Get Lookup Values

Add New Column

We have many examples here. Most of these examples require almost no programming. You can create web pages to display products, student info, etc. by setting up some parameters. If you want more programming power, you can generate PHP code from phpLens and modify the code. PhpLens is a very powerful tool that saves you time, effort and help you create applications faster and more efficiently. Go through some of these examples which will help you decide whether phpLens is a tool for YOU!
Most of the following examples use the tables below. We have chosen information that you can easily identify with. Below, you will see Products supplied by different Suppliers. The Products are also categorised and grouped. The categories are stored in Categories table. The lines indicate that the Products table is linked to the Categories table by CategoryID and linked to the Suppliers table by SupplierID. Try out our simplest example now: example 100 .

Basic Version Features

Example 100 The simplest example. Just view the categories table.
Example 101 Hide specific columns.
Example 102 Hide specific columns and change column titles.
Example 103 Password protect phpLens.
Example 104 Cell background image.
Example 105 Searching using text fields and popups.
Example 150 Scrolling Multiple Pages phpLens (products table).
Example 151 Lookup Values, also known as Joins (products, categories and supplier tables).
Example 170 Grouping by Category.
Example 171 Subtotals and Totals.
Example 180 Charting 1 with bullets.
Example 181 Charting 2 with bars.
Example 200 Searching using text fields, popups and checkboxes.
Example 302 Multiple column and detail view.
Example 308 Checking for empty strings using Powerlens.
Example 900 Master-Detail relationship. Drilldown from category to product. Also shows how to manage multiple PHPLens objects in one page.
Example 901 Shopping Cart example. Enter quantity to purchase and click on the "Buy" button.
Example 902 Scan records for a particular value. Uses powerLens to do so.
Example 905 Drilldown from grid view to details of same table using frames.

Advanced/Enterprise Features
Example 300 Editing and creating records.
Example 320 Editing and creating records on same screen (child editor).
Example 301 Javascript regular expression validation.
Example 305 Registration mode. Start in New mode, and on record creation, show details. Also shows javascript and email validation, redirects after inserting new record, and use of textareaLens.
Example 306 Completed Registration. Show details registered.
Example 303 Detail templates.
Example 304 Layout template support.
Example 307 Registration mode as example 305 but with double entry of passwords and email address for extra safety.
Example 309 Data Entry example with advanced javascript validation.
Example 311 Advanced search example with filter template used.
Forums Example Makes use of Templates and Event Handlers.
Example 910 Multiple phpLens objects, nested together to created nested tables.
Example 940 phpLens with a Microsoft Outlook interface (3 frame view).
Example 919 Creating search input fields in an EDIT/NEW record form.
Example 920 Creating search input fields in an EDIT/NEW record form combined with a lookup.
Example 950 Monthly Calendar example using templates.
Example 960 Editing Records in Grid with Hot Updates. New to phpLens 2.0!

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