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
GraceGrace18776710443Languages <a href=" http://buffalonavalpark.org/state-bank-of-india-personal-loan/#philip ">cash advance benbrook texas</a> Sometimes they resort to disguises in order to escape from the White House and move around without drawing attention. Both Mi
2
71432
JacksonJackson70358296697I sing in a choir <a href=" http://www.warwickhughes.com/blog/?p=writing-stories-online#escort ">writing a business report</a> Or international corporations. It actually has more of an impact to the city economy when someone stays in someone’s
3
71442
JuanJuan87960786754I'm on work experience http://www.warwickhughes.com/blog/?p=do-my-thesis content writing service Of course, the Giants aren't the only disappointing team. They're joined at 0-3 by the Steelers and Vikings, who both began the year with legitimate pla
4
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
5
71452
LaurenLauren69547119138Best Site good looking <a href=" http://www.warwickhughes.com/blog/?p=business-research-papers ">dance writings papers stadium</a> Twenty-four years after Communist rule ended in Poland, itscompanies now have the scale, knowledge and self-belief toe
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
71436
MadelynMadelyn65434076202I can't get a dialling tone <a href=" http://bikinginbarcelona.net/707-on-main/#greeted ">instant loans in az</a> With the recent Supreme Court ruling, the gay marriage issue becomes moot.  The Full Faith and Credit clause of the Constitution
8
71402
MiguelMiguel96867758921How much is a First Class stamp? <a href=" http://indexholding.ae/labetalol-trandate/ ">buy trandate</a> Additional methods recommended by the researchers include banning the sale of flavoured cigarettes (such as menthol), encouraging TV and film-ma
9
71411
NathanielNathaniel97691203674This site is crazy :) http://www.sharonlevy.com/artpages/write-check-for-students.html write me a report There is hardly a leader anywhere in the world that is not guilty of either war crimes or of colluding with nations that have committed war crim
10
71453
RachelRachel76805353940Not available at the moment <a href=" http://www.xbrasil.net/wp/?tag=next-pay-day-loan ">unsecured medical loans</a> "The same people-power movements that have stalled otherill-conceived tar sands pipeline projects will rise up to tellour government
(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