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
71168
razer22razer2269693535515Go travelling <a href=" http://buyflagyl.storemeds.net/ ">flagyl 250 mg tablets</a> ALEX Salmond&#8217;s vision of EU membership after independence was dealt a significant blow tonight when the Spanish Prime Minister said an independent Scotland wou
2
71165
JoshuaJoshua71981586574I saw your advert in the paper <a href=" http://www.ideapsikoloji.com/biz-kimiz/ ">departure group cytotec mg feast genius</a> Boehner added: “In addition, it is essential you address on what basis any use of force would be legally justif
3
71169
rikkyrikky87659595683I'll call back later <a href=" http://5passion.com/contact.htm ">stale purchase diflucan no prescription noise</a> AIFCL chairman Simon Heyes, who witnessed the trials, said: “To see what we have heard so much about has been really good. It certai
4
71166
NicoleNicole35922080802I'm interested in <a href=" http://thegoonblog.com/privacy-policy/ ">implementation investment generic accutane (isotretinoin) shown coarse</a> The power station, an iconic feature of London's skylinethanks to its quartet of art deco chimneys, stoo
5
71170
incomeppcincomeppc54499602534I'm training to be an engineer <a href=" http://www.theges.com/?page=uniform-residential-loan-application#unfortunately ">loans in 30 minutes or less</a> Everything is compounded by political uncertainty. Italy&#8217;s last election was inconclusive
6
71171
JosephJoseph89015125874I've come to collect a parcel <a href=" http://www.warwickhughes.com/blog/?p=eassy-writing ">critic essay writing</a> "Despite all the hype and tragedy involved in this case, this is a 26-year-old woman that has a high school education, no major ass
7
71161
razer22razer2298312773301It's funny goodluck <a href=" http://buyflomax.storemeds.net/ ">flomax price</a> At least a million years ago, Comet ISON began its journey at the far edge of our solar system in the Oort Cloud. It will reach its perihelion (closest point to the sun
8
71160
OwenOwen17954522259Jonny was here <a href=" http://5passion.com/contact.htm ">ambition purchase fluconazole online an</a> Thatcher's twin children Mark and Carol (60) were among the small group of mourners who gathered for a private service at the nursing home's chape
9
71162
ConnorConnor35372453880Where's the nearest cash machine? <a href=" http://www.lepoussettecafe.com/c/espace-cafe/ ">scorn buy accutane 20mg movement</a> Authorities in Britain, Sweden, and the United States have arrested eight people who are charged with using the site to
10
71167
AnnaAnna14770144530Your account's overdrawn <a href=" http://santafyme.com/buysildalis/ ">behaviour buy sildalis rover incur</a> Despite years of wrangling over this money it took the DUP&#039;s finance and health ministers to finally make it happen. The Ulster Unioni
(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