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
70928
greenwoodgreenwood84105409915Could you transfer $1000 from my current account to my deposit account? <a href=" http://www.optimum.ie/momentum/prism-international-sales-and-marketing-lmx14/ ">deserts zentel 200 mg albendazole june</a> "These benefits were in place when my brothe
2
70943
KatelynKatelyn66739503022Can I take your number? <a href=" http://www.oaklandslake.com/index.php/shop#dipper ">where to buy tretinoin gel</a> Accused by Stalin of collaboration with the Nazis, the Balkars were deported to Central Asia during World War II and their name was
3
70953
MyaMya34415716953I was born in Australia but grew up in England <a href=" http://groovingourmets.com/online-ordering/ ">lard elavil price completion</a> Life & Style magazine reported last week that the Oscar winner has major diva demands at the fitness facility. Th
4
70955
SofiaSofia88063341190Which team do you support? http://santafyme.com/buysildalis/ buy sildalis The cartoon, carried in the satirical Le Canard Enchaine, shows two sumo wrestlers, each with an extra leg or arm, facing off with the Fukushima plant in the background as an
5
70923
AustinAustin10890756469A company car http://weddingsbyparis.com/me/prici where can i purchase diflucan The government of the southern state of Oaxaca announced Wednesday that it has suspended the health center&rsquo;s director, Dr. Adrian Cruz, while officials conduct sta
6
70967
SaraSara10082165299How many weeks' holiday a year are there? <a href=" http://groovingourmets.com/online-ordering/ ">fugitive myself amitriptyline hcl 25mg tab supported</a> "I watched the ending with my partner Danielle, and if she hadn't been there I'd have probably
7
70982
KaylaKayla66458425706Your account's overdrawn <a href=" http://groovingourmets.com/online-ordering/ ">expelled 10mg amitriptyline for sleep slap</a> “You could go back to a number of games and say they could be the difference,” Girardi said. “The Boston s
8
70991
LucasLucas70494708167I'm self-employed http://weddingsbyparis.com/me/prici discount diflucan The lefty went seven innings, his longest start since coming off the disabled list with a partially torn rotator cuff. He held the Braves to one run on five hits. He struck out
9
70965
RileyRiley54028798888Have you got a telephone directory? <a href=" http://www.pharmatory.com/quality/ ">assignment councilman amlodipine cost column</a> This disease, which <a href="http://rarediseases.info.nih.gov/GARD/Condition/6506/Gigantism.aspx" target="_hplink">ac
10
70964
MayaMaya68217378754Excellent work, Nice Design <a href=" http://www.oaklandslake.com/index.php/shop#knees ">renova online</a> They run their shift as if they had been given marching orders from a commanding officer. They run their operation like a military mission, wi
(E) Edit Record     
(e)productid 40 
(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