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
AubreyAubrey17220231475I've got a full-time job <a href=" http://weimar.org/wrtie-my-college-essay/ ">deserts homework for you wiped mining</a> Mr. Malone has said that a big reason he&#8217;s pushing for consolidation in the cable industry is that by joining forces cable
2
71411
NathanielNathaniel25803464222very best job <a href=" http://www.cornwallfoodanddrink.co.uk/writing-essay-introductions/#cocoon ">text book should be free free essay</a> If he takes advantage of his honeymoon period in office, successfully charming foreign powers and maintaining
3
71432
JennaJenna64597648051I'd like to pay this cheque in, please http://barcelonaconsensus.org/writing-essays-online-for-money/ who can help me with my homework and i will pay him Two sources close to the talks told Reuters they had beentold Canada and the European Union cou
4
71436
CharlesCharles17301053786I'm sorry, she's <a href=" http://www.videogameconsolelibrary.com/blog/?p=persuasive-essay-helper ">breach best online resume writing services sensible</a> The company's debt troubles began in 2006 when Dublin-basedEducation Media & Publishing Grou
5
71439
EliEli59090550491Can you hear me OK? <a href=" http://indexholding.ae/buy-cheap-skelaxin/ ">buy skelaxin</a> The negotiators, Sen. Patty Murray, D-Wash., and Rep. Paul Ryan, R-Wis., have been discussing proposals to raise spending across a range of programs by betwe
6
71442
SnoopySnoopy35180629605Best Site Good Work <a href=" http://www.pensionfreedom.ie/points-for-money#confidential ">400 dollar payday loans</a> But according to Freedom of Information Act documents released by the Treasury Department to MuckRock, an organization that works
7
71444
TilburgTilburg96337893897It's OK <a href=" http://buffalonavalpark.org/500-payday-loan-you-pick-the-payday-no-fax/#lovely ">how can take out a loan</a> San Antonio, Dallas, Houston and Austin, Texas - Population growth in Texas is more than double the national average, than
8
71445
KylieKylie99955293177Enter your PIN <a href=" http://www.pensionfreedom.ie/points-for-money#read ">quick 5000 loan</a> The Rangers had extended qualifying offers by Monday to five of their six restricted free agents, aiming to protect their rights to defenseman Ryan McD
9
71450
LiamLiam83165638022Do you like it here? http://www.sharonlevy.com/artpages/write-argument-essay-on-zoos-are-beneficial-to-animals.html i want money today Other inmates at the facility had told investigators that they knew something was wrong with Alexander in early Ja
(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