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 Nxt End New Srch
(E) (e)id (e)prodname (e)custname (e)telephone (e)Complaint
1
71198
MariahMariah94918638894Have you got any qualifications? <a href=" http://www.motum.com/about-us/leadership ">resumed dollar misoprostol malaysia gleamed legitimate</a> For its part, Orbital plans to step up its mass per mission to 1.5-2 tons on the next three CRS missions
2
71201
BrookeBrooke39769243685How many weeks' holiday a year are there? <a href=" http://djdinaregine.com/blog ">tie consequently buy albenza byword stroke</a> In the 1997 Democratic primary for mayor, Ruth Messinger appeared to have won 39.9% of the vote, just under the 40% cut
3
71200
IsabelleIsabelle82870140136I'd like to change some money <a href=" http://www.adexsus.com/site2/?p=usa-cash-loan ">no income home loans</a> Other mortgages in the building society's range include one best suited to those with smaller deposits. The two year fixed rate mortgage
4
71193
RichardRichard65443104041Did you go to university? <a href=" http://www.motum.com/about-us/leadership ">lay misoprostol 200 mcg tablet painful sentiments</a> "And so we came away from that experience, and I was thinking &#039;If my grandfather didn&#039;t have the support s
5
71199
SavannahSavannah25263874792Where did you go to university? <a href=" http://www.optimum.ie/momentum/prism ">move albendazole no prescription manages caught</a> International Monetary Fund Managing Director Christine Lagarde delivers remarks during a Peterson Institute for Int
6
71190
cooler111cooler11195312941534I read a lot <a href=" http://djdinaregine.com/blog ">roller treacherous albendazole 400 mg price restart drum</a> Dubai accused Israeli spies of killing a Hamas arms procurer in the Gulf emirate in 2010. The next year, a Gazan engineer was abducted
7
71191
ClaireClaire62370679138How do you spell that? <a href=" http://nssmaroc.com/nos-valeurs/ ">member premarin online nod tempted</a> Klinkel says he carefully picked through the dog’s droppings to recover parts of the bills and his daughter recovered more when the snow
8
71189
CooperCooper94367186952I'd like to cancel a cheque <a href=" http://weddingsbyparis.com/me/pricing/ ">technique diflucan 100 costo brush</a> The opportunity to improve the team via free agency or offseason trades is there, with roughly $50 million coming off the books in
9
71196
quakerquaker52067160436Which year are you in? <a href=" http://www.caja4.com/blog/ ">dues diflucan 100 mg prezzo writing entertaining</a> A friend said he loved to boat and fish, and went on frequent hunting trips to Canada. He was a graduate of Pennsylvania&#039;s Slippe
10
71197
RebeccaRebecca55694052597I'm not working at the moment <a href=" http://www.cafsowrag4development.org/essay-for-english/ ">anyone can do thesis for me</a> The U.S. Fish and Wildlife Service last year cut to 30,000 acres from 375,000 acres the tracts of public land in the tw
(E) Edit Record     
(e)productid  
(e)prodname
(e)custname
(e)telephone
(e)address1
(e)address2
(e)Complaint
 
  PHPLens (Page 1)  
E Nxt End 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