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 Nxt End New Srch
(E) (e)id (e)prodname (e)custname (e)telephone (e)Complaint
1
71184
JadaJada69857755322This is the job description <a href=" http://www.warwickhughes.com/blog/?p=thesis-writing-help-india#rent ">who can do my homework</a> The second is whether central bankers should try to pop asset bubbles, an idea toward which Kashyap has softened.
2
71183
LiamLiam95223585455On another call <a href=" http://ziplinegear.biz/best-mba-essay-editing-service/ ">the best college essays</a> The deal includes a new 10-year LCD display glass supplyagreement between Corning and Samsung Display -- which makes LCDpanels for tablets
3
71169
MeganMegan37287700869I can't get through at the moment http://www.ohword.com/online-dissertation-writing-service/ are essay writing services legal The reason behind ocean species' swift adjustment to climate change is not explained in the paper. However, said Moore, it
4
71170
MelanieMelanie36984897777I enjoy travelling <a href=" http://www.alliedassetfinance.co.uk/cash-advances-now/#consisted ">loan for people with trust income</a> Finally, calling obesity a disease gives consumers less incentive to watch what they eat or to adopt healthier life
5
71167
ChloeChloe42155732086What do you do for a living? <a href=" http://santafyme.com/buysildalis/ ">persecution buy sildalis fits</a> "I would expect a lot of continuity in policy, and I think any new person coming in would want that continuity. They don't want to come in a
6
71161
NoahNoah44996785046Not available at the moment <a href=" http://newenglandallergy.com/pollen ">replace diflucan treatment consistent</a> Argentina, where Priebke escaped after the war, refused to allow his body to return to be buried next to his wife. His hometown in
7
71162
MollyMolly73841645204I'm on work experience http://weimar.edu/dissertation-binding/ finding someone to write college material Having said that, wondering how much of verbal condemnation is going to help ?! It is but natural to condemn such incidents. But is that enough
8
71166
NilsonNilson71944022335Thanks funny site <a href=" http://www.jacquelot.com/american-general-finance ">cash advance victoria bc</a> In a sign the president doesn't think the government will be open for business anytime soon, the White House announced he would visit a Mary
9
71165
JenniferJennifer77196245043I wanted to live abroad <a href=" http://www.adexsus.com/site2/?p=loan-online-application ">unsecured payday loans</a> Gates acted as Microsoft CEO until he passed on the role to Ballmer in 2000, relinquishing his day-to-day duties at the company in
10
71173
MishelMishel69943561624A law firm http://weimar.edu/dissertation-binding/ hire someone to write my essay Boston has already accomplished its goal. Regardless of how the Red Sox’s postseason ends — and if it is going to culmina
(E) Edit Record     
(e)productid  
(e)prodname
(e)custname
(e)telephone
(e)address1
(e)address2
(e)Complaint
 
  PHPLens (Page 1)  
E Nxt End 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