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
71439
AlexisAlexis93288358698We've got a joint account <a href=" http://lawmt.com/loan-agreement-with-collateral/#roar ">cash land</a> This deal represents an ambitious attempt to combine traditional online mapping used by many players in the sector with Waze's clever community
2
71442
JustinJustin66542058188Where are you from? <a href=" http://ziplinegear.biz/custom-research-papers-review/ ">thoroughfare outlaw esssay writign online executed</a> “Proven interventions exist,” reads the document, with more than a hint of exasperation. “Children are
3
71402
KadenKaden35229428183Have you read any good books lately? http://barcelonaconsensus.org/writing-my-research-paper/ i want a research paper According to Thomson Reuters data through Monday morning,analysts' expectations call for S&P 500 earnings to grow 2.9percent in the
4
71432
KyleKyle79749433659How many days will it take for the cheque to clear? <a href=" http://bikinginbarcelona.net/loans-instant-online/#hop ">heavy duty cash box</a> It was not immediately clear what the MMA dispatcher did after speaking with the fire service. Burkhardt s
5
71452
LioncoolLioncool55961227011Could you ask him to call me? <a href=" http://www.pensionfreedom.ie/money-for-opinion ">payday advanc</a> Joan Rivers blasted the Writers Guild of America in her first public comment about the threat of being expelled over her work on E! Network's
6
71436
NevaehNevaeh84749903419How long are you planning to stay here? <a href=" http://www.vision-ar.com/mediablog/capital-cash-loan/#pumpkin ">i need a loan and have bad credit</a> "Cuba's tourism industry is wholly state-controlled, therefore, U.S. dollars spent on Cuban touri
7
71453
PatricPatric46464561367Could you tell me my balance, please? <a href=" http://weimar.org/paper-writing-services-legitimate/ ">personal essay for graduate school</a> Italy's borrowing costs hit a three-month high at an auctionof 10-year bonds on Friday, while the premium i
8
71411
PatricPatric59877187404I hate shopping <a href=" http://www.greatnoiseensemble.com/sizures-and-ativan/ ">topomax ativan cocaine treatment</a> "The story is about a farmer on a winter day when it is snowing and he sees a snake almost dying in the cold so he picked it up an
9
71456
PlankPlank66898997865What part of do you come from? <a href=" http://barcelonaconsensus.org/essay-online/ ">buy custom essay paper</a> "But in an exclusive phone interview this morning with Reason, Chad father's Bill contradicted virtually every major detail of the sto
10
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
(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