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
70939
KatelynKatelyn12711714525Looking for a job <a href=" http://aparecidospoliticos.com.br/intervencoes-realizadas/ ">trazodone 100 mg for sleep</a> As is increasingly common, the sensor is back-side illuminated. Most imaging sensors use front-side illumination: like the human
2
70918
VanessaVanessa23192930432I don't know what I want to do after university <a href=" http://transformmilwaukee.com/investment/ ">cipralex usa</a> The Tories claimed Labour’s new policies were “unravelling”, as business leaders attacked Mr Miliband’s announcement that
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
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
6
70926
BrooklynBrooklyn73671358344I want to make a withdrawal <a href=" http://transformmilwaukee.com/investment/ ">cipralex mg 10</a> A report published by pressure group Bankwatch last yearlisted Barclays, Deutsche Bank, Royal Bankof Scotland, BNP Paribas and Credit Suisse asthe m
7
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
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
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
10
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
(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