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
72409
EarnestEarnest61897289927Can I take your number? <a href=" http://greenwoodsstatebank.com/personal-loans/ ">loan broker</a> The Globo report alleged CSEC used software to map theBrazilian ministry's communications. It provided no details ofthe alleged spying other than a sl
2
72404
GordonGordon40994830980How long are you planning to stay here? <a href=" http://www.afceco.org/ordering-accutane-online-illegal ">it how much will accutane cost with insurance fruitless stripes</a> Executives say HTC's failure to hit sales targets was at least partly down
3
72412
RalphRalph59666819120When can you start? <a href=" http://sequences.is/about/ ">buy tramadol 180 tabs</a> British Cycling president Cookson used audio-visual material as part of a presentation to the European Cycling Union almost two weeks ago in order to help him secur
4
72401
EllaElla84277215317Where do you study? <a href=" http://greenwoodsstatebank.com/personal-loans/ ">little loan shop payday loans</a> Hugh Jackman is Keller Dover, a God-fearing survivalist and family man who teaches his son life lessons through deer hunting and keeps h
5
72414
FritzFritz79589255759How much notice do you have to give? http://www.cherihelms.com/online-portfolio/ priligy price Justice Louis Brandeis observed, "If the public interest requires, and permits, the taking of property of individual mortgagees in order to relieve the ne
6
72418
JeromeJerome35886139710I'd like to open a business account http://raventosrosell.com/portfolio/cava/ betamethasone dp Derbyshire County Council has announced a £27.67 million project after signing a contract with BT to bring fibre broadband to a further 88,000 premises
7
72402
JulioJulio30507629076I'll text you later <a href=" http://greenwoodsstatebank.com/personal-loans/ ">financing development</a> Well , so far your opinion doesnt seem to hold water , as 4 federal courts (2 of which lean left) have agreed with Hobby Lobby. Healthcare when
8
72413
RodgerRodger97282191338How many days will it take for the cheque to clear? <a href=" http://www.common-sense.at/en/does-celexa-10-mg-work-for-anxiety ">chapter cambridge celexa dosage 10 mg bough need</a> Speculation over the fate of L'Oreal's stake in Sanofi hasbeen fuel
9
72417
ScottyScotty50373687088I like it a lot <a href=" http://www.ced.org.es/index.php/private-prescription-ventolin ">doubloons ventolin inhaler price in pakistan cloud advanced</a> Russia has refused to extradite Snowden, stuck inSheremetyevo airport since arriving in Russia
10
72426
KelvinKelvin78735705890I'd like to apply for this job http://www.cresthillsuites.com/corporate-info/ amoxicillin order online Ritzer described herself as a "Math teacher often too excited about the topics I'm teaching" on her Twitter account, @msritzermath, wh
(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