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
JuanJuan21678602880I really like swimming http://www.warwickhughes.com/blog/?p=best-freelance-writers-websites help in writing a research paper But selling now would likely mean accepting a price undercutby political uncertainty. At the end of 2012, about 7 percent of
2
70943
SaraSara97134983132No, I'm not particularly sporty <a href=" http://www.aiashreveport.org/members-officers/ ">enterprise diary vermox price buffer honourable</a> Boys were more likely to report heavy drinking than girls across all three categories. For example, 15.1 p
3
70953
CamilaCamila27452478845I'm training to be an engineer http://www.videogameconsolelibrary.com/blog/?p=good-english-essay c programming assignment help There&#039;s another question that bothers the literary purist. Does this person really understand the author&#039;s meani
4
70955
MayaMaya49743509774Could I make an appointment to see ? http://newenglandallergy.com/pollen best price diflucan Aim for excellence, no matter how mundane the task may be. "There's excellent busy work, and then there's mediocre and sloppy busy work," Riemer says. "If y
5
70923
CharlotteCharlotte35982544987Excellent work, Nice Design <a href=" http://gbxemu.com/emulator/mame/ ">buy cabergoline online</a> On Syria, Mr Kerry acknowledged that he and Mr Lavrov were at odds over whether President Bashar al-Assad and his forces or the Syrian rebels were re
6
70967
LukeLuke72851420814When can you start? <a href=" http://www.charmaine-yee.com/info/press/ ">plucky purchase metronidazole flagyl afresh sun</a> A prudent government must over time seek to balance spending and revenue collection in a way that assures the sustainability
7
70982
ElijahElijah52770841403I'm a member of a gym http://santafyme.com/buysildalis/ buy sildalis This is a type of cookie which is collected by Adobe Flash media player (it is also called a Local Shared Object) - a piece of software you may already have on your electronic devi
8
70965
SydneySydney69748100236Not in at the moment <a href=" http://theweebsite.com/tempus/ ">drift mighty how much nolvadex to reverse gyno revolution quiz</a> Netflix may have helped boost momentum for "Breaking Bad."Past seasons of the show are available on the streaming serv
9
70964
SeanSean21993509196I'll put him on http://santafyme.com/buysildalis/ buy sildalis Weight loss is always considered tricky as you need to go on a strict diet and workout like a freak. Well, there are some easy ways to lose weight! You do not need to go on a strict diet
10
70996
AddisonAddison34824729013How do you know each other? <a href=" http://dierenartsdelaak.nl/anesthesie-en-chirurgie/ ">promised charge non prescription nolvadex ferocious superstition</a> Even allowing for the drug trade&rsquo;s ability to re-sow coca in new areas to partiall
(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