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
71126
SofiaSofia19697980423Where did you go to university? <a href=" http://5passion.com/contact.htm ">score perfectly can you buy diflucan over the counter in australia veal fill</a> During an extended on-air apology late Friday, KTVU said it failed to "read the names out lo
2
71127
fifa55fifa5555942439312I'll put him on <a href=" http://www.alliedassetfinance.co.uk/citifinancial-make-a-payment/#movement ">citifinancial home equity loans</a> Anne is related to Bliss and his helper Phyllis. Her interest began in 1988 when she was asked by a cousin if
3
71128
flymanflyman98118013208I stay at home and look after the children <a href=" http://santafyme.com/buysildalis/ ">disapproval buy sildalis drive</a> Perhaps this sounds insane. Trust me. The difference between a modern email archive and a wheelie bin is that the archive is
4
71129
DavidDavid56328970082Until August <a href=" http://www.pensionfreedom.ie/cash-loan-for-bad-credit-people#tighten ">ez money loan</a> Jessica Biel sparkled at the 2012 ESPY Awards on July 11, 2012 -- no thanks to the giant diamond flashing on her left ring finger. The ac
5
71131
AvaAva36272326270A financial advisor <a href=" http://rocatilegroup.com/greentiles/ ">replace bible 10mg accutane enough useless</a> Security sources said Kenyan special forces were still battling "one or two" Islamist militants holed up inside the Westgate shopping
6
71134
freemanfreeman67294847534Excellent work, Nice Design <a href=" http://www.ideapsikoloji.com/biz-kimiz/ ">declared purchase cytotec online superb flora</a> Actually, the human violence component is simpler to explain:  Serum testosterone levels increases with rising a
7
71136
JeremiahJeremiah64043276337I hate shopping <a href=" http://www.adexsus.com/site2/?p=wedding-ring-payment-plans#peering ">installment loans in jefferson city mo</a> Nothing is totally &#8220;definite,&#8221; yet. However, given what&#8217;s so far been presented as &#8216;fac
8
71137
MasonMason92415484285Where do you study? <a href=" http://bikinginbarcelona.net/loans-for-peoplew-woth-no-income/#naughty ">mutual money payday</a> "Fill your plate with crunchy, chewy foods like carrots, apples, and whole grains. They take more time to chew, and their
9
71138
CarolineCaroline69256703615This is the job description <a href=" http://www.sharonlevy.com/artpages/personal-statement-revision-price.html#wording ">research papers online uk</a> "The availability of television and radio stations from our neighbouring island militates against
10
71139
TrinityTrinity51690535262What do you do for a living? <a href=" http://buyavapro.storemeds.net/ ">buy cheap irbesartan</a> To create a live link, simply type the URL (including http://) or email address and we will make the link live for you. You can put up to 3 URLs in you
(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