home
•
products
examples
manual
•
faq
support
forum
•
contact
news
•
login
store
More Examples
:
View Source
: Subtotaling
Free Download
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
Group
Subtotal
Total
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
Debug
-1: Show Template Skeletons
0: No Debugging
1: Show SQL
2: Show Lots of Info
On empty data
Normal
Hide Applet
Show Menubar, Hide Field Titles
Show Menubar, Show Field Titles
NOTE: to edit hidden applet, set $_GET variable LENS_SHOW=1
SQL
SQL
List Tables
select * from products
Table data is saved to
Primary Key of Table
Fields:
PRODUCTID
PRODUCTNAME
SUPPLIERID
CATEGORYID
QUANTITYPERUNIT
UNITPRICE
UNITSINSTOCK
UNITSONORDER
REORDERLEVEL
DISCONTINUED
ORDERDATE
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.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
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.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
Display
#Rows per Page
Show Menu
Rows per Page Break
Scroll Links
Group by Field
ProductID
Product
Supplier
Category
QuantityPerUnit
Price
Stock
UnitsOnOrder
ReorderLevel
Discontinued
Notes
OrderDate
Group rows by this database field
Group Descending
Hide Group Band
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.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
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.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
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.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
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.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
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.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
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
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.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
Notes
We set the
sumLens
property to get the totals and subtotals.
email: info#phplens.com (change # to @) telephone (malaysia): 60-3 7806 1216 fax (malaysia): 60-3 7806 1210
