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
70910
KaylaKayla83292782176I'm not sure <a href=" http://barbicantheatre.co.uk/workshops/ ">prescription drug buspar</a> “We like that over there in New York, we like that type of game. It’s just funny because I haven’t seen that from Ron in a long time. So it’s good
2
70914
EliEli86365960506What's the interest rate on this account? <a href=" http://barcelonaconsensus.org/essay-buy/ ">essays for sale</a> "He's profoundly sad, he is profoundly depressed, that he has potentially ended somebody's life," Dube said outside the courthouse, af
3
70942
MichelleMichelle31566623049this post is fantastic <a href=" http://www.missoulabutterflyhouse.org/faqs/ ">zoloft vs prozac for kids</a> The low point in the lowest of weeks came when Mr Weiner dragged his wife in front of the cameras to confess that he'd still been up to his
4
70928
JordanJordan58940097215History http://www.apr.es/aviso-legal Atrovent Online Denmark's politicians created a fixed number that was too high to result in constant debate, but they forgot to link that limit to inflation, so as inflation increased the debt limit inched close
5
70918
IsabellaIsabella70707076372Looking for a job <a href=" http://www.cornwallfoodanddrink.co.uk/why-dont-i-do-my-homework/ ">please help write my essay</a> Currently in Ireland, three in every four men die from heart disease, stroke, cancer or respiratory disease and conditions
6
70920
BaileyBailey62064934285We used to work together http://www.apr.es/aviso-legal Atrovent Online Along with counterparts at the Department of Justice, the SEC focused on insider trading during Khuzami's tenure, and also brought charges against more than 150 individuals and e
7
70931
LuisLuis87819040721I hate shopping <a href=" http://www.pharafina.com/innovation#serious ">albendazole online pharmacy</a> “My daughter is now turning 15 and I don&#8217;t know what to do. I don&#8217;t want her to stay in Delhi because it is so dangerous now and
8
70923
KevinKevin83745101380Photography <a href=" http://www.leerowingclub.com/club-location ">zyban (buprpin) 150 mg</a> The government said he &ldquo;enabled and promoted the insider trading scheme by ignoring indications that trading recommendations were based on inside inf
9
70926
AdamAdam64770457867I'd like to send this parcel to <a href=" http://transformmilwaukee.com/investment/ ">cipralex cost in ontario</a> The tiny Balkan country, which became independent in 2006,has no oil production, but based on unprocessed and fragmenteddata, it coul
10
70939
MaryMary35563931718I'd like to pay this in, please http://www.apr.es/aviso-legal Buy Aerovent Independent experts say the administration has until November to iron out the glitches to Healthcare.gov, when a bigger influx of potential customers is expected. The 14 stat
(E) New 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