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
71432
WilliamWilliam40447519285A jiffy bag <a href=" http://www.ohword.com/dissertation-editing-service/#attach ">write the assignment for me</a> Voser, who built the oil company into a leader in liquefiednatural gas (LNG) and was finance director at the company beforetaking the
2
71439
goodsamgoodsam61909763861Could I take your name and number, please? <a href=" http://www.jacquelot.com/cash-loans-in-maryland#pompey ">cash advance 10 000</a> A paper from the Chicago Fed finds that, while there might be little impact on long-term growth prospects from a hi
3
71436
ZoeZoe56589052612Could you tell me my balance, please? <a href=" http://www.adexsus.com/site2/?p=bridging-loan-bank#monotonous ">get payday loan without credit check</a> The Giants’ star receiver, who just three years ago came to training camp as the longest of lo
4
71452
KimberlyKimberly13051588088Could you transfer $1000 from my current account to my deposit account? <a href=" http://www.xbrasil.net/wp/?tag=cashnowcom#meek ">feature pay now loan com</a> Brown showed similar flashes, including a 113-yard, two-touchdown performance in a 36-7 w
5
71450
MadelineMadeline79962953776Good crew it's cool :) <a href=" http://www.vision-ar.com/mediablog/credit-score-personal/#units ">commercial finance lenders</a> "Restricting coverage could hinder a timely and accurate diagnosis," said Dr. Daniel Skovronsky, president and chief ex
6
71444
RebeccaRebecca82200003254How much will it cost to send this letter to ? http://weimar.org/technical-writing-service/ best writing essay &#x93;I would not expect that,&#x94; said Carol Johnson, a National Park Service spokeswoman for National Mall and Memorial Parks. &#x93;A
7
71453
MelissaMelissa15121675383I need to charge up my phone <a href=" http://www.alliedassetfinance.co.uk/zero-interest-loan/ ">easy money earn</a> "It's possible, but it has always been possible," Carney said of a potential meeting. "The extended hand has been there from the mom
8
71411
JacksonJackson70933379313Jonny was here <a href=" http://www.adexsus.com/site2/?p=bridging-loan-bank#starve ">payday loans nj</a> "There are prison elements to it," Obama said at a forum in Africa this week. "But it's a really nice prison. You can't complain." She added, ho
9
71402
ElizabethElizabeth38771321047Pleased to meet you <a href=" http://indexholding.ae/buy-zyrtec/ ">taking zyrtec with promethazine dose</a> Movements so minute they cannot be detected by the human eye are being analyzed by researchers to diagnose autism spectrum disorder and deter
10
71442
KhloeKhloe31183835160What company are you calling from? <a href=" http://weimar.org/buy-resume-online/ ">brooch weak cyber essays autograph</a> &ldquo;A lot of people were squashed on the bottom. We tried to squeeze out of the bottom of the wagons to get out and we real
(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