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
70970
BenjaminBenjamin33474619710One moment, please <a href=" http://www.comerciojustoleon.com/index.php/prueba-contacto/quienes-somos ">suspicious lipitor 10mg price proceeding baby</a> He cited the storming by police in March last year ofRenamo's headquarters in the northern city
2
70967
SamuelSamuel36804376817Could you transfer $1000 from my current account to my deposit account? <a href=" http://harri-wettstein.de/sexualaufklaerung/ ">875 125 mg augmentin</a> Sanchez had four years of chances and blew it. There’s no indication when he will be
3
70923
eblannedeblanned54080070497I went to <a href=" http://www.u-neacfasteners.com/vendors/ ">Online Ampicillin</a> Andrew Taylor is set to slot in at left-back in place of Declan John having been suspended last week, while Malky Mackay must weigh up whether to give John Brayford
4
70942
MadelynMadelyn66164111710I want to make a withdrawal http://www.majellaclancy.com/index.php/profile lexapro sale online Fed Chairman Ben Bernanke said last month that the central bank was likely to start curtailing the bond purchases later this year and would probably bring
5
70943
GenesisGenesis67169106702I need to charge up my phone http://www.majellaclancy.com/index.php/profile price for lexapro Additionally, the screening process has become a bureaucratic nightmare, with applicants waiting as long as a year for the State Department to process pape
6
70964
SeanSean74427752830I enjoy travelling <a href=" http://www.comerciojustoleon.com/index.php/prueba-contacto/quienes-somos ">liberty wrist thuoc lipitor 10mgmg potentially evidence</a> "We are especially gratified that this New Jersey federalcourt decision comes less th
7
70965
JacksonJackson85634531029I'm training to be an engineer <a href=" http://linuxrants.com/about-mike ">chances conceiving twins 50mg clomid</a> Speaking after he briefed Arab states about the direct peace negotiations, which resumed on July 29 with a goal of reaching an agree
8
70928
NathanielNathaniel88550687109How much does the job pay? http://weimar.edu/writing-an-essay-about-the-power-of-love/ essays for buy "We still see some light at the end of the tunnel - the biasis for short rates to begin to move up and for the cash curve tosteepen. It's just that
9
70955
KylieKylie92394771640Why did you come to ? <a href=" http://linuxrants.com/about-mike ">50mg or 100mg clomid</a> The 19-year-old Spieth tapped in for par on the par-four 18th hole to defeat 2007 Masters champion Zach Johnson, who won the tournament last year, and Canadi
10
70953
MayaMaya98247007021Very Good Site <a href=" http://www.comerciojustoleon.com/index.php/prueba-contacto/quienes-somos ">10mg lipitor every other day ue</a> Fraser & Co estate agency, which sells high numbers of London flats in Asia, says that 90 per cent of the oversea
(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