home
•
products
examples
manual
•
faq
support
forum
•
contact
news
•
login
store
More Examples
:
View Source
: Layout Template Demo
Free Download
Click
here
to see a grid that matches the original template
orig.tpl
.
This is a Demo. You can not change anything for security reasons.
Back to Grid
Column Settings
Choose
Grid Columns
Detail Columns
Filter/Search Columns
* New Record Columns
* Edit Columns
* Must Fill Columns
- Read Only Columns
- Columns to Sum
- Columns to Average
* Columns to Export
* Sortable Columns
- Graph Columns
- Filter Compulsory Columns
Generate PHP Code
Remove All Settings
?
Colors
General
Editing
Display
Formats
Templates
Titles
Menus
Color Settings
Color Reference
opens in a new window
Top Caption
Caption Background
Menu Color
Title Background
1
Odd Rows
2
Even Rows
3
Current Row
4
Row Number Background
Bottom Caption
Change Color Style:
ABCDEFGHIJKLMNOP
Detail Table
Detail Left Column
Detail Right Column
Background
Warning: saving colors does not save settings from other tabs.
State & Debugging
Start phpLens
View Grid
Search Form
Search Form showing Records
New Record (set property redirectOnInsert also)
Always Edit Record (set property redirectOnUpdate also)
First Edit Record, then switch to VIEW
Debug
-1: Show Template Skeletons
0: No Debugging
1: Show SQL
2: Show Lots of Info
On empty data
Show New Form
Hide Applet
Show Menubar, Hide Field Titles
Show Menubar, Show Field Titles
Stop Script (die)
NOTE: to edit hidden applet, set $_GET variable LENS_SHOW=1
SQL
SQL
List Tables
select * from lensusers order by userid
Table data is saved to
Primary Key of Table
Fields:
USERID
PASSWORD
FIRSTNAME
LASTNAME
EMAIL
ADDRESS1
ADDRESS2
POSTCODE
CITY
STATE
COUNTRY
AGE
CREATED
LASTMOD
Or, Compound Key Fields
(; delimited fields)
Save primary key in PHP variable
Insert key SQL
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Editing Permissions
Allow New Record Creation
Enable this feature and show
button
Allow Record Editing
Enable this feature and show
button
Edit Multiple Records
Edit Multiple Records in Grid
Allow Record Deletes
Enable this feature and show
button
Locking
Enter name of global variable holding user id
Redirect back on lock
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Display
#Rows per Page
Show Menu
Rows per Page Break
Scroll Links
Group by Field
User ID
Password
Name
Last Name
email
Address Line 1
Address Line 2
Postcode
City
State
Country
Age
Created
LASTMOD
Group Descending
Hide Group Band
Display this Field as Group
User ID
Password
Name
Last Name
email
Address Line 1
Address Line 2
Postcode
City
State
Country
Age
Created
LASTMOD
Group Rows Until Column
Show Details & RecNo
Hide Details & RecNo
Show Details, RecNo on Left
Show Details, RecNo on Right
Hide Details, Show RecNo on Left
Hide Grid, Show Details
Show Details Below
Child Editor in Detail Grid
Create and Edit records in detail grid
Edit records in detail grid only
Create records in detail grid only
Edit and Create records in detail grid
Number of Columns:
Table Width 100%
Table/Cell Borders
Normal borders
Flat style
Flat style with frames
Allow Sorting
Show Column Headers
Snaking Columns
(eg. 3^2)
Widths:
(eg. 25%^20%)
Mode:
Left
Offset
Right
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Date Formats
Display Date
Input Date
Display Timestamp
Input Timestamp
Captions
New Form Caption
Edit Form Caption
Filter Form Caption
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Store template file in applet/templates directory, and enter the file name below (leave out directory path)
Templates
Edit template
New template
Layout template
Details template
Grid Row template
Grid Title template
Filter template
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
To modify titles of individual columns,
Go Back to Grid
and click on white "e" icons next to column titles.
Title Levels (Field^ColWidth^Title^Color;)
Title Level 1
Title Level 2
Title Level 3
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Menus
Hide Menus
Hide Top and Bottom Menu
Hide Top Menu
Hide Bottom Menu
Hide Scrolling
Hide Scroll to End
Hide Filter/Search
Hide Sort Form
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Graph
Show Graph
Hide
Show Graph and Grid
Show Graph, Hide Grid
Choose columns to graph
Image Width
Height
Graph Type
Bar
Horizontal Bar
Stacked Bar
Line
Pie
Data Series
Data series is stored in individual records
Background Colors
Default
Black
Dark Cyan
Dark Blue
Blue
Light Blue
Dark Green
Light Green
Yellow
Light Yellow
Pink
Light Pink
White
Color Gradient
Show Values
Title
X-Axis
Y-Axis
Scale
Linear
Log
Image Map URL
(Only for bar charts)
Margins
Left
Right
Top
Bottom
Axis Labels
Swap because values are negative
Cancel
You can modify settings in multiple tabs
before
saving.
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;jlim@natsoft.com)
Valid Till
: Never Expires
Notes
The layout templates are
ex304.tpl
and
orig.tpl
.
email: contact#phplens.com (change # to @) telephone (malaysia): 60-3-7947 2888 fax (malaysia): 60-3-7947 2800
