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
71067
RobertRobert97117277585Incorrect PIN <a href=" http://www.lovy.nl/over-laura/ ">whale mebendazole 100 mg preserved</a> The app accesses real-time data from water companies on combined sewer overflows, which allow untreated sewage and storm water into the sea in periods of
2
71068
DEDE66187689650Is it convenient to talk at the moment? http://www.perspicalia.com/e celecoxib order Following the incident, the three-time World Series champion told Lindsley, &#8220;It’s unfortunate, you know, it’s embarrassing. It really is embarrassing. Not
3
71010
AndrewAndrew72165947055Hello good day http://weimar.org/ut-homework-services/ apa paper writing Within days of the tragedy, while investigations were underway, some experts and media outlets began offering opinions as to what went wrong. Among their assertions: The crew d
4
71012
ErinErin58014804812I'd like to cancel a cheque http://www.perspicalia.com/e celecoxib cost walmart Obama, appearing relaxed and confident, said his "Number One priority" is to "create an economy where if you work hard, you will succeed," and he argued that his economi
5
71040
FaithFaith71128225009There's a three month trial period <a href=" http://weddingsbyparis.com/me/prici ">buy diflucan online australia qk</a> The NSA inspector general, in the letter dated September 11, detailed 12 investigations that found the NSA's civilian and militar
6
71006
crazyivancrazyivan36158724313Can I call you back? <a href=" http://www.perspicalia.com/faq ">purchase celebrex online</a> About two million people suffer from MS worldwide. RRMS isthe most common form of the disease, characterized by episodesof worsening neurologic function fol
7
71061
JustinJustin76187233759A staff restaurant <a href=" https://www.wesearchtogether.org/about.php ">buy diflucan pill px</a> The "Twilight" star was intrigued with the offer and reportedly asked Weinstein how much the royal was offering, which led him to come to a pricey agr
8
71066
VictoriaVictoria96341539595A pension scheme <a href=" http://www.videogameconsolelibrary.com/blog/?p=who-can-write-my-term-paper ">executive resume writing services dallas tx</a> Brady quickly started to move New England down the field and then converted a fourth-and-4 from t
9
71064
NathanNathan93434474526Do you like it here? <a href=" http://www.navabrindsol.com/about-us/about-us.html ">atarax tablets 10mg what is it used for hb</a> Chris Lloyd of the Ogwen rescue team said: “It looks like he made a navigational error and has walked over the edge,
10
71063
MadisonMadison99066764780My battery's about to run out <a href=" http://www.videogameconsolelibrary.com/blog/?p=good-english-essay ">homework help number</a> Indonesia is still one of BlackBerry's biggest markets, accounting for about 15 percent of global users but its shar
(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