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
72472
EzekielEzekiel54178864218Will I get travelling expenses? <a href=" http://artsandaging.org/index.php?s=soma-500mg-side-effects ">soma 350 mg overdose</a> "We have about 200 events we've done in Traverse City," Porter says. "You'll see Mario Batali, you'll see microbrew fest
2
72467
RamonRamon54900480463I stay at home and look after the children <a href=" http://www.contravision.de/en/dostinex-025.html ">dostinex 0.25 mg</a> The economy is recovering from the Great Recession and employers are hiring more workers every month. But, like most economis
3
72470
VanessaVanessa62306418137Looking for work <a href=" http://www.healthcmi.com/sitemap#manage ">us bimatoprost cod sales</a> They also ate less after the very high intensity workout than after the moderate exercise, while the difference between the high intensity workout and
4
72461
FelipeFelipe68181055647What university do you go to? <a href=" http://www.afceco.org/purchase-acetazolamide#suffer ">acetazolamide diamox</a> Mizruchi hopes America will be saved by “a group of corporate officials, speaking with one voice, able to bring together poli
5
72460
MohammadMohammad95087513382Please wait <a href=" http://www.healthcmi.com/sitemap#formula ">bimatoprost online purchase</a> Former communists dominated politics until 1996 when a centrist government came to power. It became involved in prolonged political feuding which did li
6
72462
MerlinMerlin70851191455I'm training to be an engineer <a href=" http://www.afceco.org/buy-macrobid ">macrobid online</a> Renamo has lost every election to Frelimo since the peacedeal, and has challenged these vote outcomes as fraudulent. Itaccuses Guebuza and his ruling p
7
72465
QuintonQuinton42379082527How many more years do you have to go? <a href=" http://www.aitvm.org/aitvm.org/index.php/cheap-neurontin-gabapentin#hobby ">neurontin generic cost</a> “That’s frightening,” he says. “By the time I was 10 years old, and I’m not exaggeratin
8
72471
TitusTitus37279830131Could I have an application form? <a href=" http://artsandaging.org/index.php?s=strongest-soma-pill-mg ">soma construction jobs</a> In 1995, at the age of 43, Bauby suffered a major stroke and slipped into a coma. He regained consciousness two days
9
72469
BarrettBarrett85825458424In tens, please (ten pound notes) <a href=" http://www.contravision.de/en/cd25-clomid-symptoms.html#irresponsibility ">clomid mg 25</a> Texas has become ground zero of the nation's abortion debate after state senator Wendy Davis led a filibuster of
10
72466
RooseveltRoosevelt78541403979magic story very thanks http://www.hungarianbiotech.org/index.php/purchase-avanafil purchase avandia The following will outline how you can fine tune your iOS 7 experience, taking advantage of the features you like and turning off the features you d
(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