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

ProductID	ProductName	Supplier	Category	Qty/Unit
		Exotic LiquidsNew Orleans Cajun DeGrandma Kelly's HomeTokyo TradersCooperativa de QuesoMayumi'sPavlova, Ltd.Specialty Biscuits, PB Knäckebröd ABRefrescos AmericanasHeli Süßwaren GmbH &Plutzer LebensmittelNord-Ost-Fisch HandeFormaggi Fortini s.rNorske MeierierBigfoot BreweriesSvensk Sjöföda ABAux joyeux ecclésiasNew England Seafood Leka TradingLyngbysildZaanse SnoepfabriekKarkki OyG'day, MateMa MaisonPasta Buttini s.r.l.Escargots NouveauxGai pâturageForêts d'érables	BeveragesCondimentsConfectionsDairy ProductsGrains/CerealsMeat/PoultryProduceSeafood	10 boxes x 20 bags24 - 12 oz bottles12 - 550 ml bottles48 - 6 oz jars36 boxes12 - 8 oz jars12 - 1 lb pkgs.12 - 12 oz jars18 - 500 g pkgs.12 - 200 ml jars1 kg pkg.10 - 500 g pkgs.2 kg box40 - 100 g pkgs.24 - 250 ml bottles32 - 500 g boxes20 - 1 kg tins16 kg pkg.10 boxes x 12 pieces30 gift boxes24 pkgs. x 4 pieces24 - 500 g pkgs.12 - 250 g pkgs.12 - 355 ml cans20 - 450 g glasses100 - 250 g bags100 - 100 g pieces25 - 825 g cans50 bags x 30 sausgs.10 - 200 g glasses12 - 100 g pkgs24 - 200 g pkgs.500 g24 - 250 g jars12 - 500 g pkgs.12 - 75 cl bottles750 cc per bottle24 - 4 oz tins12 - 12 oz cans32 - 1 kg pkgs.16 - 500 g tins20 - 2 kg bags1k pkg.4 - 450 g glasses10 - 4 oz boxes10 pkgs.24 - 50 g pkgs.12 - 100 g bars50 - 300 g pkgs.16 - 2 kg boxes48 pieces16 pies24 boxes x 2 pies24 - 250 g pkgs.24 pieces5 kg pkg.15 - 300 g rounds24 - 500 ml bottles48 pies15 - 625 g jars20 bags x 4 pieces32 - 8 oz bottles24 - 8 oz jars10 boxes x 8 pieces10 kg pkg.24 - 355 ml bottles24 - 150 g jars24 - 0.5 l bottles500 ml12 boxes

ProductID ProductName Supplier Category Qty/Unit 11 Queso Cabrales Cooperativa de Queso Dairy Products 1 kg pkg. 30 Nord-Ost Matjeshering Nord-Ost-Fisch Hande Seafood 10 - 200 g glasses 47 Zaanse koeken Zaanse Snoepfabriek Confections 10 - 4 oz boxes 12 Queso Manchego La Pastora Cooperativa de Queso Dairy Products 10 - 500 g pkgs. 71 Fløtemysost Norske Meierier Dairy Products 10 - 500 g pkgs. 19 Teatime Chocolate Biscuits Specialty Biscuits, Confections 10 boxes x 12 pieces 1 LEO Exotic Liquids Beverages 10 boxes x 20 bags 68 Scottish Longbreads Specialty Biscuits, Confections 10 boxes x 8 pieces 69 Gudbrandsdalsost Norske Meierier Dairy Products 10 kg pkg. 48 Chocolade Zaanse Snoepfabriek Confections 10 pkgs. 27 Schoggi Schokolade Heli Süßwaren GmbH & Confections 100 - 100 g pieces 26 Gumbär Gummibärchen Heli Süßwaren GmbH & Confections 100 - 250 g bags 7 Uncle Bob's Organic Dried Pears Grandma Kelly's Home Produce 12 - 1 lb pkgs. 50 Valkoinen suklaa Karkki Oy Confections 12 - 100 g bars 31 Gorgonzola Telino Formaggi Fortini s.r Dairy Products 12 - 100 g pkgs 41 Jack's New England Clam Chowder New England Seafood Seafood 12 - 12 oz cans 8 Northwoods Cranberry Sauce Grandma Kelly's Home Condiments 12 - 12 oz jars 10 Ikuraa Tokyo Traders Seafood 12 - 200 ml jars 23 Tunnbröd PB Knäckebröd AB Grains/Cereals 12 - 250 g pkgs. 24 Guaraná Fantástica Refrescos Americanas Beverages 12 - 355 ml cans 37 Gravad lax Svensk Sjöföda AB Seafood 12 - 500 g pkgs. 3 Producto, super Exotic Liquids Condiments 12 - 550 ml bottles 38 Côte de Blaye Aux joyeux ecclésias Beverages 12 - 75 cl bottles 6 Grandma's Boysenberry Spread Grandma Kelly's Home 0 12 - 8 oz jars 77 Original Frankfurter grüne Soße Plutzer Lebensmittel Condiments 12 boxes 60 Camembert Pierrot Gai pâturage Dairy Products 15 - 300 g rounds 63 Vegie-spread Pavlova, Ltd. Condiments 15 - 625 g jars 52 Filo Mix G'day, Mate Grains/Cereals 16 - 2 kg boxes 43 Ipoh Coffee Leka Trading Beverages 16 - 500 g tins 18 Carnarvon Tigers Pavlova, Ltd. Seafood 16 kg pkg. 54 Tourtière Ma Maison Meat/Poultry 16 pies 9 Mishi Kobe Niku Tokyo Traders Meat/Poultry 18 - 500 g pkgs. 45 Røgede sild Lyngbysild Seafood 1k pkg. 13 Konbu Mayumi's Seafood 2 kg box 17 Alice Muttons Pavlova, Ltd. Meat/Poultry 20 - 1 kg tins 44 Gula Malacca Leka Trading Condiments 20 - 2 kg bags 25 NuNuCa Nuß-Nougat-Creme Heli Süßwaren GmbH & Confections 20 - 450 g glasses 64 Wimmers gute Semmelknödel Plutzer Lebensmittel Grains/Cereals 20 bags x 4 pieces 75 Rhönbräu Klosterbier Plutzer Lebensmittel Beverages 24 - 0.5 l bottles 2 Changie Grandma Kelly's Home Beverages 24 - 12 oz bottles 34 Sasquatch Ale Bigfoot Breweries Beverages 24 - 12 oz bottles 35 Steeleye Stout Bigfoot Breweries Beverages 24 - 12 oz bottles 67 Laughing Lumberjack Lager Bigfoot Breweries Beverages 24 - 12 oz bottles 73 Röd Kaviar Svensk Sjöföda AB Seafood 24 - 150 g jars 32 Mascarpone Fabioli Formaggi Fortini s.r Dairy Products 24 - 200 g pkgs. 72 Mozzarella di Giovanni Formaggi Fortini s.r Dairy Products 24 - 200 g pkgs. 36 Inlagd Sill Svensk Sjöföda AB Seafood 24 - 250 g jars 56 Gnocchi di nonna Alice Pasta Buttini s.r.l. Grains/Cereals 24 - 250 g pkgs. 57 Ravioli Angelo Pasta Buttini s.r.l. Grains/Cereals 24 - 250 g pkgs. 15 Genen Shouyu Mayumi's Condiments 24 - 250 ml bottles

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';