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

More Examples:   View Source:   Advanced Filtering

Free Download

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

  (E)
(e)ProductID (e)ProductName (e)Supplier (e)Category (e)Qty/Unit
 
E Nxt End Excel
(e)ProductID (e)ProductName (e)Supplier (e)Category (e)Qty/Unit
17
Alice MuttonsPavlova, Ltd.Meat/Poultry20 - 1 kg tins
40
Boston Crab MeatNew England SeafoodSeafood24 - 4 oz tins
60
Camembert PierrotGai pâturageDairy Products15 - 300 g rounds
18
Carnarvon TigersPavlova, Ltd.Seafood16 kg pkg.
2
ChangieGrandma Kelly's HomeBeverages24 - 12 oz bottles
39
Chartreuse verteAux joyeux ecclésiasBeverages750 cc per bottle
4
Chef Anton's Cajun SeasoningNew Orleans Cajun DeCondiments48 - 6 oz jars
5
Chef Anton's Gumbo MixNew Orleans Cajun DeCondiments36 boxes
48
ChocoladeZaanse SnoepfabriekConfections10 pkgs.
38
Côte de BlayeAux joyeux ecclésiasBeverages12 - 75 cl bottles
58
Escargots de BourgogneEscargots NouveauxSeafood24 pieces
52
Filo MixG'day, MateGrains/Cereals16 - 2 kg boxes
71
FløtemysostNorske MeierierDairy Products10 - 500 g pkgs.
33
GeitostNorske MeierierDairy Products500 g
15
Genen ShouyuMayumi'sCondiments24 - 250 ml bottles
56
Gnocchi di nonna AlicePasta Buttini s.r.l.Grains/Cereals24 - 250 g pkgs.
31
Gorgonzola TelinoFormaggi Fortini s.rDairy Products12 - 100 g pkgs
6
Grandma's Boysenberry SpreadGrandma Kelly's Home012 - 8 oz jars
37
Gravad laxSvensk Sjöföda ABSeafood12 - 500 g pkgs.
24
Guaraná FantásticaRefrescos AmericanasBeverages12 - 355 ml cans
69
GudbrandsdalsostNorske MeierierDairy Products10 kg pkg.
44
Gula MalaccaLeka TradingCondiments20 - 2 kg bags
26
Gumbär GummibärchenHeli Süßwaren GmbH &Confections100 - 250 g bags
22
Gustaf's KnäckebrödPB Knäckebröd ABGrains/Cereals24 - 500 g pkgs.
10
IkuraaTokyo TradersSeafood12 - 200 ml jars
36
Inlagd SillSvensk Sjöföda ABSeafood24 - 250 g jars
43
Ipoh CoffeeLeka TradingBeverages16 - 500 g tins
41
Jack's New England Clam ChowderNew England SeafoodSeafood12 - 12 oz cans
13
KonbuMayumi'sSeafood2 kg box
76
LakkalikööriKarkki OyBeverages500 ml
67
Laughing Lumberjack LagerBigfoot BreweriesBeverages24 - 12 oz bottles
1
LEOExotic LiquidsBeverages10 boxes x 20 bags
74
Longlife TofuTokyo TradersProduce5 kg pkg.
65
Louisiana Fiery Hot Pepper SauceNew Orleans Cajun DeCondiments32 - 8 oz bottles
66
Louisiana Hot Spiced OkraNew Orleans Cajun DeCondiments24 - 8 oz jars
51
Manjimup Dried ApplesG'day, MateProduce50 - 300 g pkgs.
32
Mascarpone FabioliFormaggi Fortini s.rDairy Products24 - 200 g pkgs.
49
MaxilakuKarkki OyConfections24 - 50 g pkgs.
9
Mishi Kobe NikuTokyo TradersMeat/Poultry18 - 500 g pkgs.
72
Mozzarella di GiovanniFormaggi Fortini s.rDairy Products24 - 200 g pkgs.
30
Nord-Ost MatjesheringNord-Ost-Fisch HandeSeafood10 - 200 g glasses
8
Northwoods Cranberry SauceGrandma Kelly's HomeCondiments12 - 12 oz jars
25
NuNuCa Nuß-Nougat-CremeHeli Süßwaren GmbH &Confections20 - 450 g glasses
77
Original Frankfurter grüne SoßePlutzer LebensmittelCondiments12 boxes
70
Outback LagerPavlova, Ltd.Beverages24 - 355 ml bottles
55
Pâté chinoisMa MaisonMeat/Poultry24 boxes x 2 pies
16
PavlovaPavlova, Ltd.Confections32 - 500 g boxes
53
Perth PastiesG'day, MateMeat/Poultry48 pieces
3
Producto, superExotic LiquidsCondiments12 - 550 ml bottles
11
Queso CabralesCooperativa de QuesoDairy Products1 kg pkg.
 
E Nxt End Excel

Notes

This example demonstrates using a template to change the search screen:
 $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';
email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800