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
72551
VidaVida78293778837Not in at the moment <a href=" http://www.fivepointsnacks.com/site/blog/ ">is it safe to buy antabuse online </a> Penn says, going forward, she hopes to be "reaching out to other women and girls, empowering them, letting them know, you know, whateve
2
72537
ShirleyShirley18991885226It's OK <a href=" http://www.fivepointsnacks.com/site/blog/ ">antabuse overnight shipping </a> Today, Alexander Blackman, a man who devoted his life to serving his country, sits behind bars. &ldquo;He&rsquo;s not feeling sorry for himself. He&rsquo;
3
72554
NathanielNathaniel46182295344Some First Class stamps <a href=" http://www.fivepointsnacks.com/site/blog/ ">antabuse without prescription </a> Recent Forest Service studies on high-elevation climate trends in the Pacific Northwest United States show that streamflow declines tie
4
72544
RandallRandall19148072844Not available at the moment <a href=" http://www.healthynh.com/publications.html ">should you buy clomid online</a> Research continues to demonstrate that repetitive concussions significantly increase the risk of permanent neurologic dysfunction, su
5
72556
CarrollCarroll37694168175Have you got a current driving licence? <a href=" http://www.healthcmi.com/sitemap ">hatch cunning where can i buy bimatoprost over the counter retain smack</a> “I don’t know. I didn’t play very well the last two weeks,” he said before he bo
6
72558
BrooklynBrooklyn35516922776Why did you come to ? <a href=" http://www.fivepointsnacks.com/site/blog/ ">antabuse from india no prescription </a> "He had a remarkable capacity to put everyone he met at ease and his diplomacy, patience and influence led to the initiation of peac
7
72541
MarcelinoMarcelino70551675348Hold the line, please <a href=" http://www.fivepointsnacks.com/site/blog/ ">doctors who prescribe antabuse in ct </a> With India and China planning lunar surface missions, privately-funded space entrepreneurs competing for the US$40 million Google L
8
72553
WarrenWarren50398874500This is your employment contract <a href=" http://www.fivepointsnacks.com/site/blog/ ">order disulfiram online </a> Avila and the others were whisked off to the hospital immediately after the ceremony. But Ciara Taylor, who took the cross from Avila
(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