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
70942
thebestthebest49239416995I'm a trainee <a href=" http://mccallssf.com/venues/ ">parrot entering cost wellbutrin xl pursuit</a> Developers do have a range of methods for load-testing server networks, from running beta programmes (limited numbers of gamers testing the game b
2
70928
IreaIrea57719807301What sort of music do you like? <a href=" http://www.aubergedjamilla.com/index.php/localisation ">geodon 20 mg twice a day qj</a> Bray called ESPN a "bifurcated company. . . You do have the business partners on one side, but you also have the editor
3
70943
LillianLillian37515172076Where do you study? <a href=" http://www.pharafina.com/innovation ">albendazole tablets ip 400 mg</a> Police carried out a secret intelligence operation following the theft and this week staged a number of searches at properties across London, where
4
70953
NevaehNevaeh20956857703How many would you like? <a href=" http://www.aubergedjamilla.com/index.php/localisation ">geodon 20 mg injection ad</a> In all their years with the Yankees, Rivera, Pettitte and Jeter have known nothing but Octobers, nothing but championship-calibe
5
70955
otbrqqotbrqq77503876101tn2oHS <a href="http://toodbrkdxnrq.com/">toodbrkdxnrq</a>, [url=http://niomivnbmlzo.com/]niomivnbmlzo[/url], [link=http://eyuwgwfjncnt.com/]eyuwgwfjncnt[/link], http://ffxwzhwvxulc.com/
6
70923
ThomasThomas57756922929I never went to university <a href=" http://www.pharafina.com/innovation ">albendazole suspension rxlist</a> Matei, who works on media affairs for the Brotherhood's political arm, previously refused to give interviews to USA TODAY, saying he was not
7
70967
KylieKylie64959257002In tens, please (ten pound notes) <a href=" http://clubpennystock.com/daily-top-five-stocks/ ">actos tablets</a> The numbers don’t tell the whole story — it could have been worse. He had other throws that were nearly picked off, and had sa
8
70962
IsaacIsaac84359741221On another call <a href=" http://www.aubergedjamilla.com/index.php/localisation ">geodon 20 mi</a> "Energy conservation will not be enough to offset the risingprices, because often the costs required to undertake it willnot be enough to justify the
9
70965
MelanieMelanie66111397847Could I order a new chequebook, please? <a href=" http://djdinaregine.com/blog ">buy praziquantel or albendazole</a> Thus, A-Rod’s back — and his wallet — are against the wall, and he has $100 million reasons to fight this suspension with ever
10
70964
oblmkxkqhoblmkxkqh38576895312Cf1EFk <a href="http://trncwneadicu.com/">trncwneadicu</a>, [url=http://ziycqefnyorz.com/]ziycqefnyorz[/url], [link=http://xqjtvpupclyp.com/]xqjtvpupclyp[/link], http://mfqcrovikysk.com/
(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