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
71075
ParkerParker16133897567I'll text you later <a href=" http://www.gsi-net.com/order-lasuna-online.html ">buy lasuna online</a> For seven generations, the Crane family and its eponymous company have been the sole supplier of the special blend of linen-and-cotton paper that g
2
71076
HaydenHayden79383330211I study here <a href=" http://www.pensionfreedom.ie/get-cash-in-minutes-bad-credit-approved-online ">advance cash settlement funding corp</a> Yellen is now the front-runner to succeed Ben Bernanke,whose second four-year term will end in January. Yel
3
71010
LoganLogan46662678044Have you got any experience? <a href=" http://www.perspicalia.com/faq#studious ">what is the cost of celebrex</a> FALFURRIAS, Texas &ndash; Just before sundown, a group of men cloaked in camouflage from the Texas Border Volunteers halts their all te
4
71012
ZoeZoe81031140764Looking for work <a href=" http://www.perspicalia.com/faq#alignment ">celebrex mg</a> The government&#039;s urban slum demolition drive in 2005 drew more international condemnation. The president said it was an effort to boost law and order and deve
5
71074
MayaMaya81535317643Where are you calling from? http://www.volunteerglasgow.org/about-us/ remeron rd 15 mg Sandy struck the state's 127-mile (204-km) coastline last October 29. It destroyed or damaged hundreds of thousands of homes, leveled or washed away boardwalks an
6
71006
SebastianSebastian51477356625Are you a student? http://www.volunteerglasgow.org/about-us/ remeron 15 mg Around the globe, there are nine monumental LOVE sculptures, all original, in different colors and some slightly different in size. They are in New York, Philadelphia, Indian
7
71061
MadelineMadeline86578146891I'll put her on <a href=" http://philippinespeculativefiction.com/intro.html ">luncheon so propranolol 10 mg price institute</a> “I don’t think he’s going to be moving up to 160,” Schaefer said of Mayweather. “I just don’t see it happeni
8
71073
LiamLiam76512823743I'm from England <a href=" http://www.kestenbergmovementprofile.org/trainings.html ">manufacturing venture robaxin 500mg tablets does</a> There is a lot of advice about how to reduce the amount of TV that children watch. But does it really work? Acc
9
71066
RyanRyan47299727339I'm sorry, I didn't catch your name <a href=" http://www.videogameconsolelibrary.com/blog/?p=online-personal-statement ">personal narrative essays online</a> “Tickets are $20 with all proceeds to benefit The Lymphoma and Leukemia Society. Doors op
10
71064
RachelRachel45238285883I came here to work http://www.volunteerglasgow.org/about-us/ remeron 15 mg vs 30 mg Abdulaziz al-Ghurair, chairman of the authority overseeingDubai's financial centre, said the emirate would also focus onIslamic re-insurance. In conventional insura
(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