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
72442
MaynardMaynard57284704345I quite like cooking <a href=" http://greenwoodsstatebank.com/personal-loans/ ">cash advance jacksonville nc</a> "By collecting these energetic neutral atoms, IBEX provides maps of the original charged particles," said IBEX principal investigator Da
2
72438
ManuelManuel95718742622I'm about to run out of credit <a href=" http://www.afceco.org/tamsulosin-4mg#myth ">tamsulosin 400 mcg</a> Brown showed similar flashes, including a 113-yard, two-touchdown performance in a 36-7 win over Carolina in Week 3. The former member of the
3
72445
OliverOliver21288835553I'm at Liverpool University http://www.alamotravel.com/bimatoprost-ophthalmic bimatoprost ophthalmic solution 0.03 buy But there are unintended consequences. My conversations with some in the industry indicate that many in what&rsquo;s left of the a
4
72439
SylvesterSylvester69838651823I've got a full-time job https://badgesforvets.org/tetracycline-250-mg-capsules-buy-online.html oxytetracycline 250mg oxytetracycline 250mg BART had also sought to have employees contribute to theirpensions, starting at 1 percent in the first year o
5
72409
CarloCarlo68662901642magic story very thanks <a href=" http://www.afceco.org/benicar-generic-equivalent ">sneer scholar benicar hcl gates freight</a> Sosa's lawyer, Shashi Kewalramani, said the government knew Sosa was in the military because he told officials about his
6
72404
WoodrowWoodrow88971005951Pleased to meet you <a href=" http://caribbean-airlines.com/index.php/erythromycin-stearate-tablets-bp-250-mg#refuse ">erythromycin eye ointment price</a> Greece outperformed the rest of the euro zone debt marketafter finance ministers approved a 6.
7
72431
WaldoWaldo95898056262Very interesting tale <a href=" http://artsandaging.org/index.php?s=buy-ambien-overnight-delivery ">ambien cr dosage 20 mg</a> "Is it parliamentary for the prime minister to respond by accusing (me) of sounding as if (I) had been taking mind-alterin
8
72441
MelvinMelvin70186828359What's the exchange rate for euros? http://www.eden-patio.com/index.php/discount-silagra silagra tablet “They are New Yorkers now,” Ielpi said of the city’s ballplayers. “They are, in essence, teachers. You have a choice when you
9
72440
SterlingSterling54903325744When do you want me to start? http://www.elatt.org.uk/courses purchase tretinoin In July, Wood Group Mustang and Wood Group PSN jointly secured a detailed engineering and procurement scope for an offshore development in Canada, and are working more
10
72414
MarkusMarkus97000967503Who do you work for? http://www.mekoowebdesign.com.au/payment clomipramine 20 mg The virus is carried by tiny biting flies that hatch near bodies of water. It mostly affects whitetail deer and is often fatal to them, causing hemorrhaging of such org
(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