This uses a filter template to reformat the search form vertically. The phpLens search form is very flexible. Try the following:

- Search for all product id's greater than 30:	>30
- All product id's between 10 to 30:	10 (to) 30
- All product names beginning with V:	V

This is a Demo. You can not change anything for security reasons.

Back to Grid   Column Settings   Choose Grid ColumnsDetail ColumnsFilter/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 GridSearch FormSearch Form showing Records
Debug	-1: Show Template Skeletons0: No Debugging1: Show SQL2: Show Lots of Info
On empty data	Normal 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 products order by 1
Table data is saved to
Primary Key of Table	Fields:PRODUCTIDPRODUCTNAMESUPPLIERIDCATEGORYIDQUANTITYPERUNITUNITPRICEUNITSINSTOCKUNITSONORDERREORDERLEVELDISCONTINUEDORDERDATE
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	ProductID ProductName Supplier Category Qty/Unit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued Notes OrderDate       Group Descending     Hide Group Band     Display this Field as Group ProductID ProductName Supplier Category Qty/Unit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued Notes OrderDate
Group Rows Until Column
Show Details & RecNo	Hide Details & RecNoShow Details, RecNo on LeftShow Details, RecNo on RightHide Details, Show RecNo on LeftHide Grid, Show DetailsShow Details Below
Child Editor in Detail Grid	Create and Edit records in detail gridEdit records in detail grid onlyCreate records in detail grid onlyEdit 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: LeftOffsetRight
	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	HideShow Graph and GridShow 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	DefaultBlackDark CyanDark BlueBlueLight BlueDark GreenLight GreenYellowLight YellowPinkLight PinkWhite   Color Gradient
Show Values
Title
X-Axis	Y-Axis
Scale	LinearLog
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

 $lens->templateFilter = 'ex311.tpl';

The contents of the template:

{$_FORMBEGIN_}
<table width="100%" border="1">
<tr bgcolor="#333333">
  <td colspan=5 align=right><font color="#FFFFFF">
{$_SUBMIT_}</font> {$_DYNEDIT_} &nbsp; </td>
</tr>
<tr bgcolor="#666666">
  <td><b><font color="#FFFFFF">{$PRODUCTID_T}</font></b></td>
  <td><b><font color="#FFFFFF">{$PRODUCTNAME_T} </font></b></td>
  <td><b><font color="#FFFFFF">{$SUPPLIERID_T}</font></b></td>
  <td><b><font color="#FFFFFF">{$CATEGORYID_T}</font></b></td>
  <td><b><font color="#FFFFFF">{$QUANTITYPERUNIT_T}</font></b></td>
</tr>
<tr>
  <td>{$PRODUCTID}</td>
  <td>{$PRODUCTNAME}</td>
  <td>{$SUPPLIERID}</td>
  <td>{$CATEGORYID}</td>
  <td>{$QUANTITYPERUNIT}
</td>
</tr>
</table>
{$_FORMEND_}


The template consists of the fields ,eg {$PRODUCTID}, and the captions {$PRODUCTID_T}. And we also have the buttons {$_SUBMIT_} and {$_CANCEL_}, though the cancel button has been removed. The {$_DYNEDIT_} tag holds the green "e" editor button. Finally we have the form management tags {$_FORMBEGIN_} and {$_FORMEND_}.

Other features include exporting to Excel [which requires the ob_start() call at the beginning of the page)] and setting the firstState to FILTERVIEW, so the search screen appears on startup.

$lens->exportLens = 'PRODUCTID;PRODUCTNAME;SUPPLIERID;CATEGORYID;QUANTITYPERUNIT';
$lens->firstState = 'FILTERVIEW';