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
71439
CamilaCamila69357955881Are you a student? <a href=" http://barcelonaconsensus.org/best-website-to-buy-an-essay/ ">writing custom</a> Yavuz was working as a vaccine researcher in Tanzania for the Clinton Foundation, but she and Langdon headed north into Kenya as the Octobe
2
71411
JackJack76216585194I'm in my first year at university <a href=" http://indexholding.ae/buy-xalatan/ ">xalatan</a> Profits from sales at the Community Shop will be re-invested in the supermarket itself, and in "support services" on the premises. These include advice on
3
71442
LillianLillian25376218875Could I have an application form? <a href=" http://www.theges.com/?page=bank-of-scotland-loans#whereupon ">buy computer bad credit</a> &#8220;I see the difference in the kids&#8217; faces,&#8221; said Garner, who is an artist ambassador for the chil
4
71452
LoganLogan99910435826US dollars <a href=" http://www.sharonlevy.com/artpages/essays-written-by-professionals.html#humble ">do my algebra homework</a> Surging interest rates &ndash; and all indications are they aren't going back down &ndash; will likely give us the answe
5
71432
LuisLuis46682076474I'm not interested in football <a href=" http://www.warwickhughes.com/blog/?p=purchase-compare-and-contrast-essay#appearance ">ghostwriting service page</a> Some negative news in June's report is that part-time work -- because of "slack work or busi
6
71450
MadelineMadeline79962953776Good crew it's cool :) <a href=" http://www.vision-ar.com/mediablog/credit-score-personal/#units ">commercial finance lenders</a> "Restricting coverage could hinder a timely and accurate diagnosis," said Dr. Daniel Skovronsky, president and chief ex
7
71453
MollyMolly74968736726I'd like to change some money <a href=" http://buffalonavalpark.org/personal-guarantee/ ">payday loans in va</a> This comes from our ad serving technology and is used to track how many times you have seen a particular ad on our sites, so that you do
8
71402
razer22razer2246567702534I'd like to speak to someone about a mortgage http://www.warwickhughes.com/blog/?p=literature-based-dissertation personal college essay help At the moment, however, Obama is scheduled to round off his tour with a stopover in Manila, which is seen as
9
71444
RebeccaRebecca82200003254How much will it cost to send this letter to ? http://weimar.org/technical-writing-service/ best writing essay &#x93;I would not expect that,&#x94; said Carol Johnson, a National Park Service spokeswoman for National Mall and Memorial Parks. &#x93;A
10
71436
VictoriaVictoria84328676249Could you please repeat that? <a href=" http://indexholding.ae/order-yagara-online/ ">yagara for men</a> Having made such a mess of Mourinho's succession (Luigi Delneri was fired before taking charge of an official match, leading to Fernández's app
(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