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

More Examples:   View Source:   searchInEditNew

Free Download

This demo allows you to enter complaint records for products you are supporting. You can perform a search in the both the EDIT/NEW record forms for the product the customer is complaining about. Hint: search on R in the "prodname" field below.

  PHPLens
E New Srch
(E) (e)id (e)prodname (e)custname (e)telephone (e)Complaint
1
70943
MollyMolly31116906334Have you got any qualifications? <a href=" http://www.manidistrega.it/moda ">narrow maud amitriptyline cost canada temporary</a> The board of the Scottish Professional Football League are in the process of amending and updating the rulebooks of thei
2
70931
IsaacIsaac31150635032I work for a publishers <a href=" http://www.studioforty9.com/products ">where can i purchase bimatoprost no rx</a> The fungicide development presents a crucial dilemma, because bee colony collapse touches all aspects of American agriculture. The US
3
70923
AntonioAntonio39359520366I'm a member of a gym <a href=" http://www.metalcolor.ch/de/ ">clear denote elavil generic amitriptyline mineral pigeon</a> P.J. and I have had several discussions already and he knows he has made serious mistakes and there will be serious consequen
4
70928
KevinKevin39743077535I'm unemployed http://www.cornwallfoodanddrink.co.uk/college-term-papers/ writing a lab report help The Fed is likely to announce measures to rein in itsmassive economic stimulus. Fears of an expected policy taperinghave already sparked an emerging
5
70910
WyattWyatt53622690882A pension scheme <a href=" http://transformmilwaukee.com/investment/ ">where to buy cipralex</a> We contacted Microsoft for a comment regarding the matter, but it wasn't available at the time of publication. Ormandy isn't mentioned in the advisory a
6
70920
NatalieNatalie54775667322Could I have , please? <a href=" http://www.studioforty9.com/products ">purchase bimatoprost no visa without prescription</a> Its deployment in the Campos and Espirito Santo pre-salt basins reflects the burgeoning scale and increasing remoteness of
7
70942
GenesisGenesis61099695053Good crew it's cool :) http://www.studioforty9.com/products to bye bimatoprost in uk with out prescription OMG, anyone who works for the federal government and didn&#8217;t see this coming should be institutionalized. Being a public servent means ju
8
70926
DevinDevin62420628516How do you spell that? <a href=" http://transformmilwaukee.com/investment/ ">buy cipralex</a> Mihaloliakos has denied the charges against him. He was arrested on Saturday alongside other party members as part of the governmentâ€ÂÂÂ
9
70914
MariaMaria64596051426Nice to meet you <a href=" http://www.studioforty9.com/products ">buy bimatoprost ophthalmic solution uk</a> In the wake of the Kellner matter becoming public, Silver said Collins would retire. He left his job at the end of last month, though he wil
10
70939
TonyTony66346992704Can you hear me OK? <a href=" http://aparecidospoliticos.com.br/intervencoes-realizadas/ ">desyrel for insomnia</a> Even if the BOJ succeeds, Japan risks sinking back into alow-growth rut unless Prime Minister Shinzo Abe - now thatSunday's Upper Hou
(E) Edit Record     
(e)productid  
(e)prodname
(e)custname
(e)telephone
(e)address1
(e)address2
(e)Complaint
 
  PHPLens (Page 1)  
E New Srch

Notes

This feature is available since 3.1.

This demo show to create complaint records, retrieving the product id and product name using a search form built into the NEW/EDIT record form. This is particularly useful when we have a 100,000 product table and we don't want to pull every product record in a normal lookup, but allow the user to enter the first few characters of the product name, then we perform a search.

The key property is:

$lens->searchInEditNew = 
"PRODNAME^select concat(productname,' (',productid,')'),productname,productid,productid 
	from products where productname like '{#}%'^prodname^productid^>1";
		

There are two modes for searchInEditNew. The first is when no lookupLens is defined as in this example. The second is discussed in ex920.

The searchInEditNew generates the search field. The key to understanding this is the prodname^productid list above, which defines the fields that receive searched values.

Now look at the SQL SELECT statement. The {#} in the SQL is substituted with what the user entered in the input field.

The SQL statement retrieves 3 fields, the first being what we show the end-user in the popup.

The 2nd is what we store in the prodname, the first field of the list prodname^productid.

The 3rd field of the SQL is stored in productlist, the second field of the list prodname^productid.

Now if 3 items were defined in the above list, say prodname^productid^more3 then the SQL statement would have had 4 fields, the 4th field storing into more3.

The >1 in the property means the field requires at least 1 character before a search can occur.

Lastly, this example has the details being displayed below the grid, using $lens->showRecNo = 5;

email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800