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
KimberlyKimberly82907144140I'm doing a masters in law http://santafyme.com/buysildalis/ buy sildalis What are you talking about? Rockstar is known for the stiffest mechanics in the industry. Their specialty is building huge worlds with tons of content, which means they can&#0
2
70943
NevaehNevaeh50121915046Where's the nearest cash machine? http://5passion.com/contact.htm purchase fluconazole The retail element of the IPO plan is rare for Britain, andonly usually considered for well known companies. In Octoberlast year insurer Direct Line sold around 1
3
70953
PaytonPayton35220617600I do some voluntary work <a href=" http://www.experimentalconversations.com/issue/spring-2013/#valid ">street price trazodone 50 mg</a> In his admiring, well-researched documentary with a strong sense of place, director Greg Camalier traces the stor
4
70955
IsabelIsabel27017837247I can't get a dialling tone <a href=" http://gbxemu.com/emulator/ ">purchase dostinex br</a> The NSA broke privacy rules or overstepped its legal authority thousands of times each year since Congress granted it broad new powers in 2008, according to
5
70923
ChristianChristian87052796088How many would you like? <a href=" http://www.perspicalia.com/fuckowski ">wage apart generic celebrex 200mg price utter brutally</a> During the 40-minute question-and-answer session, Mr Bercow said he enjoyed listening to MPs “whose use o
6
70967
KadenKaden50735413804Where's the postbox? <a href=" http://gbxemu.com/emulator/ ">dostinex online rs</a> Two years after the National Football League and its players’ union hammered out a new labor agreement, which included both sides agreeing in principle to test pla
7
70982
PaigePaige83440015439I'm happy very good site http://santafyme.com/buysildalis/ buy sildalis Almost 70 years since the end of World War Two, Italy's wartime past is still deeply divisive in a country which came close to civil war when the fascist dictatorship of Benito
8
70965
LillianLillian85552692761I'm doing a masters in law http://weddingsbyparis.com/me/prici cheap generic diflucan Refinancing activity was hit much harder and the index tumbled 15.6 percent last week. The refinance share of total mortgage activity slumped to 64 percent of appl
9
70964
CurtCurt93949257104I don't like pubs <a href=" http://www.experimentalconversations.com/issue/spring-2013/#seeing ">trazodone usage</a> How many times have I seen a lion lie like this before, in the shade of a tree gazing out lazily over the plains? Or, waiting expect
10
70996
BobBob68325312261A few months http://www.warwickhughes.com/blog/?p=business-research-papers purchase cheap essays Digital expert Phil Dearson, head of strategy for Tribal Worldwide, said the black-out had cost Google an estimated loss of $500,000 (Rs 3 crore) in the
(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