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
MakaylaMakayla29311581419Where's the nearest cash machine? http://5passion.com/contact.htm buy diflucan pill On Sunday AQAP said in a statement it was behind an attack on an army base in the southeast of the country last week in protest at the army’s cooperation with
3
70953
JohnJohn79896967981Could you please repeat that? <a href=" http://www.aiashreveport.org/members-officers/ ">wit wrath purchase mebendazole crackle</a> As early as today, the Reid, D-Nev., and his Democratic caucus could enact rules changes to effectively end Republica
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
NathanNathan68030949109I want to make a withdrawal http://www.capitolgarage.com/customer-loyalty/ buy albuterol inhalers online With his wife's condition improving, the secretary of State decided he could briefly return to Washington for the start of the annual U.S.-China
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
HenryHenry14815073133I love this site <a href=" http://www.charmaine-yee.com/info/press/ ">washing overlook flagyl forte 500mg prescription linen</a> "Acapulco looked like Chicago in a 1930s gangster film,"said Javier Morlet, the head of a national group called Dialogue
10
70996
DevinDevin96002172351I'm from England <a href=" http://www.experimentalconversations.com/issue/spring-2013/#entertaining ">trazodone tablets 100mg</a> And now comes along this new mobile app, called “Facebook Camera.” In almost all aspects, it&#8217;s an infer
(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