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
71428
MadelineMadeline34306744029magic story very thanks <a href=" http://www.jacquelot.com/bank-loan-modification#forced ">can you get a personal loan with bad credit and behind on bills</a> It provided for autonomy for Saharawis under Moroccan sovereignty, a referendum after a fo
2
71435
JanniJanni66049085243I'd like to send this parcel to <a href=" http://ziplinegear.biz/how-to-do-a-assignment/ ">quiz bamboo money and happiness essay lilac liquid</a> If you already are a print subscriber, register now. Or sign up as a digital-only subscriber today, an
3
71429
MakaylaMakayla64375049182I've just started at <a href=" http://indexholding.ae/mircette-birth-control-buy/ ">mircette for acne</a> Impressed by Biden's global network, Baumgartner sees it as part of the former Delaware senator's approach to government service. "It's very c
4
71411
AshleyAshley67347525138The United States <a href=" http://ziplinegear.biz/papers-for-sale/ ">essay on writing skills</a> The former French finance minister has acknowledged attending sex parties in various cities but maintains he was unaware the women taking part were pai
5
71433
TylerTyler59464137247On another call <a href=" http://barcelonaconsensus.org/essay-papers-sale/#jean ">essay writing class</a> Throngs of villagers remain uncertain of their loved ones’ fate, after the June 16 flashfloods killed nearly 1,000 people and left 3,500 miss
6
71399
GabrielGabriel60737378417I'd like to transfer some money to this account <a href=" http://www.pensionfreedom.ie/best-short-term-loans-with-bad-credit#lock ">1 hour personal loans</a> Here’s the rub: What if the lack of efficacy and the fracturing of the American corporate
7
71434
NatalieNatalie53047715877Did you go to university? <a href=" http://www.sharonlevy.com/artpages/i-have-to-write-an-essay-due-tomorrow.html#postcard ">can you write my paper</a> Other highlights included Jason Marsalis, youngest scion of the New Orleans family, leading a qua
8
71402
MelanieMelanie62766924827Who do you work for? <a href=" http://www.adexsus.com/site2/?p=property-loan-abroad#rogue ">noble loan com</a> And now comes along this new mobile app, called “Facebook Camera.” In almost all aspects, it&#8217;s an inferior product to Instagram.
9
71431
SofiaSofia46712758917An accountancy practice <a href=" http://barcelonaconsensus.org/essay-papers-sale/#yellow ">essay writing help student</a> "The so-called Marketplace Fairness Act is a job-killing tax hike that hurts American small businesses and hurts American cons
10
71432
JuliaJulia48329386125I want to make a withdrawal <a href=" http://indexholding.ae/prazosin-and-ptsd/ ">prazosin hydrochloride</a> These findings reflect off of Snoeck's 2011 discovery regarding a set of chemical factors that can turn human embryonic stem cells or human
(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