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
71402
JosephJoseph58805182559Gloomy tales <a href=" http://www.alliedassetfinance.co.uk/motorcyle-financing/ ">native american loans</a> A constable exaggerating an incident is no big deal. Discrediting a senior politician and having your pals back you up is reprehensible. It i
2
71411
GenesisGenesis31865827256I'm not working at the moment <a href=" http://weimar.org/buy-college-essay-in-4-hours/ ">pregnant improve essay writing acquisition prisoners</a> Among those briefing were the Canadian Security IntelligenceService (CSIS) spy agency, the Royal Canad
3
71432
SydneySydney83796231345We'll need to take up references http://www.ohword.com/thesis-writing-service/ professional coursework &ldquo;Kim only gave [it] back after she got [pregnant] with Kanye&rsquo;s baby and boasted during divorce proceedings, &lsquo;Kris can have the r
4
71436
LiamLiam35544146494It's serious <a href=" http://www.cafsowrag4development.org/cambridge-essay-writing-service/ ">dismissed veil essay service feedback crow</a> Outstanding debt at Batista's X companies stands at aroundUS$10bn, not including undisclosed liabilities at
5
71439
IsaacIsaac35757799262Could I ask who's calling? <a href=" http://www.videogameconsolelibrary.com/blog/?p=quality-writing-services ">write comparison essay</a> The IPO price valued FireEye at about $2.3 billion. Thecompany raised about $304 million from the offering. All
6
71442
rikkyrikky34734965525I'll put her on <a href=" http://www.xbrasil.net/wp/?tag=stop-foreclosure-loans-for-everyone#care ">cash advance middletown ohio</a> As stated to the Court, as well as in prior correspondence to the Government, Reuters again unreservedly extends its
7
71444
KaitlynKaitlyn71192771718Is this a temporary or permanent position? <a href=" http://www.jacquelot.com/arm-refinance-loan ">rescue debt</a> The sol has weakened more than 9 percent so far this yearafter appreciating to historically high levels in 2012 asinvestors sought bet
8
71450
JenniferJennifer80736193095How much is a First Class stamp? <a href=" http://www.cafsowrag4development.org/cambridge-essay-writing-service/ ">arrive allen write essay outline should</a> The Oct. 1 debut of the exchanges was marred by technicalglitches that have kept many from
9
71452
MackenzieMackenzie78062122532Where did you go to university? <a href=" http://www.theges.com/?page=personal-consolidation-loans#satisfied ">cash advance leads</a> Depending on what you do during your gap year, the experience may have financial costs. Money may not be a problem
10
71453
MelissaMelissa81860271245Have you got a telephone directory? <a href=" http://www.theges.com/?page=personal-consolidation-loans#alarming ">pay day loans for west virginia reasidence</a> @TFF- &#8220;In the present economic and market environment, companies are penalized for
(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