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
71422
JocelynJocelyn68044112628It's funny goodluck <a href=" http://weimar.edu/custom-writing-tips/ ">online free essay writer</a> Almost all Internet stocks have high valuations. Netflix hasa 12-month forward price-to-earnings ratio of 92.9, whileSalesforce.com Inc's is even hig
2
71419
JamesJames72410993348A packet of envelopes <a href=" http://ziplinegear.biz/write-a-mla-essay/ ">custom-essay.org</a> Early estimates from traders showed most expect between 74bcf and 90 bcf were injected into inventories last week,compared with a year-ago build of 54 b
3
71426
JosiahJosiah35298195432I'm sorry, she's <a href=" http://www.ohword.com/where-to-buy-research-papers-cheap/ ">buried nursery buy college level papers online intentions laid</a> Karan’s spokesperson confirmed she will take part in the inn’s expansion
4
71405
TonyTony84190634230What company are you calling from? <a href=" http://www.warwickhughes.com/blog/?p=essays-writing ">buy essay papers online</a> The Family and Childcare Trust, which published the report, said that couples will be forced to take unpaid leave or engag
5
71408
MarissaMarissa67843885069Three years <a href=" http://indexholding.ae/purchase-levaquin/ ">buy levofloxacin</a> The study is based on research dating to 1995, when researchers in the Bahamian island of Bimini began tagging and taking tissue samples of lemon sharks. The shar
6
71411
MackenzieMackenzie37277250755I'm in a band <a href=" http://weimar.org/help-assignment-australia/ ">essay for me</a> > Other business headlines Multimedia versions of Reuters Top News are now available for: * 3000 Xtra : visit* BridgeStation: view story .134(Reporting By Tri
7
71425
AidenAiden33378936628Will I have to work shifts? <a href=" http://lawmt.com/best-payday-installment-loans/#tunnel ">financing proposal</a> The Air Force developed a throwback tiger-stripe pattern, known as the Airman Battle Uniform, but found it serves little practical
8
71399
AddisonAddison96358120364Sorry, I'm busy at the moment <a href=" http://indexholding.ae/buy-maxaquin/ ">buy maxaquin online</a> The conflict between Islamist militants and the Pakistani state has claimed tens of thousands of lives in the last few years. Recent moves toward
9
71402
LeviLevi47592792018Remove card <a href=" http://indexholding.ae/generic-lotensin/ ">generic lotensin</a> The Max, like the standard One, promises better low-light shots. The camera is 4 megapixels, compared with the minimum 8 megapixels that most high-end phones have.
10
71417
KaylaKayla57317586102I'm in my first year at university <a href=" http://www.ohword.com/help-me-to-do-my-assignment-in-singapore/ ">balanced exquisite custom thesis wishes</a> Rudd has also fought battles with Murdoch's papers overultimately false accusations of politic
(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