Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTLED-A19-10A-*"; $items[]="LTLED-A19-10A-D"; $itemnames[]="9.5 Watt A-19 LED Interior Bulb - Daylight White"; $items[]="LTLED-A19-10A-N"; $itemnames[]="9.5 Watt A-19 LED Interior Bulb - Natural White"; $items[]="LTLED-A19-10A-W"; $itemnames[]="9.5 Watt A-19 LED Interior Bulb - Warm White"; $items[]="LTLED-A19-10A-Amber"; $itemnames[]="9 Watt A-19 LED Turtle-friendly Bulb - Amber"; ///////////////////////////////////////////////////////////// $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); foreach($items as $value){ $result = $dbcnx->query("SELECT list,retail,special,dealer,unit,cs FROM price WHERE item = '$value'"); if (!$result) { //echo("ERROR:".mysql_error()."
"); $mess[]="Eco-\$mart Price: Quoted*"; $pay[] = "no"; }else{ $row = $result->fetch_row(); $list = $row['list']; $retail = $row['retail']; $special = $row['special']; $dealer = $row['dealer']; $unit = $row['unit']; $units[]=$unit; $cs = $row['cs']*1; if($unit == "CS" and $cs > 0){ $unit = "CS*".$cs; $caseit = "on"; }else{ $caseit = "off"; } if($special>0 or $dealer>0){ $qoks[]=$value; } if($status == 'wholesale'){$charge=$special; $bergen = 'Special';} elseif($status == 'dealer'){$charge=$dealer; $bergen = 'Wholesale';} else{$charge=$retail; $bergen = "";} if($retail == "0.00" and $list == "0.00" or $retail="" or $list==""){ $mess[]="Eco-\$mart Price: Quoted"; $pay[] = "no"; }else{ if($retail != "0.00" and $list == "0.00"){ $pay[] = "yes"; if($bergen != ""){ $mess[]="Regular Price: \$".$retail."" . "
Eco-\$mart ".$bergen." Price: \$".$charge.""; }else{ $mess[]="Eco-\$mart Price: \$".$charge." ".$unit.""; }//no special pricing }//retail is not 0 and list is else{//all present $pay[] = "yes"; if($bergen != ""){ $mess[]="List Price: \$".$list."". "
Regular Price: \$".$retail."" . "
Eco-\$mart ".$bergen." Price: \$".$charge." ".$unit.""; }else{//list but no special pricing $mess[]="List Price: \$".$list."". "
Eco-\$mart Price: \$".$charge." ".$unit.""; } }//allpresent }//retail and list are 0.00 if($caseit == "on"){ $cso[] = $cs.":".$charge; $casecharge = $charge * $cs; $price[] = sprintf("%01.2f", $casecharge); }else{ $price[] = $charge; $cso[] = ""; }//no cases }//got result }//4eachitem //////////////////////////divide table cells for quote request $labels[]="Daylight White"; $labels[]="Natural White"; $labels[]="Warm White"; $labels[]="Amber"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="D = Daylight"; //$codes[]="W = Warm White"; $codes=array(); ?>
www.eco-smart.com

LED Replacement Lamps
BACK

$value"); } ?> " . " $items[$i]
$mess[$i]
" . "" . "" . "" . "" . "" . "" . "QTY: " . " " . ""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes $i=$i+1; }//while counting items ?> "); }//codes is not empty ?>
" . " $items[$i]
$mess[$i]"); if($print!="yes"){ echo("

" . "" . "Quote

"); }//print is not yes echo("
" . " $items[$i] 
$mess[$i]
"); $codcount=count($codes); $a=0; foreach($codes as $value){ $a=$a+1; if($codcount!=$a){ $sp=","; }else{ $sp=""; } echo("$value$sp "); }//4each echo("

Description: Fully encapsulated, 120 Volt, 9.5 Watt, A19 medium base LED interior light bulb replaces a 60W incandescent bulb. Saving real energy over a longer life is just the beginning. These bulbs are returnable, reducing landfill and pollution.

  • Long lifespan, over 50,000 hours. Little to no maintenance for 7 years.
  • Dimmable.
  • Low electricity consumption. Save 70 - 80% electric energy over incandescent lamps.
  • Safe low heat light.
  • Environment friendly, no UV and infrared, no hazardous substance.
  • Vibration-resistant, easy for transportation.

Applications:  The Eco-$mart A-19 9.5 Watt LED Household Bulb is dimmable, with wide application and is very suitable for low light areas and decorative lighting in:

 House Lights    Offices    Clubs    Stores    Hotels    Restaurants    Gyms    Airports    Office Buildings    Factories

CE Logo  RoHS Compliant
Model A19 - 9.5 Watt
Technical Specifications:
Item:  LTLED-A19-10A Dimming: Dimmable Power: 9.5 Watts
Base: E27, E26, GU10, B22 Dimensions: 2.4" x 4.7" Beam Angle: 120°
LEDs: Samsung LEDs Input voltage: 120-240VAC  
Color Color Temperature Lumens
Warm White 2600-3500K 600 Lumens
Natural White 4000-4500K 650 Lumens
Daylight White 5800-6300K 690 Lumens
Amber Turtle-friendly Lamp (588 NM)       UL Listed     Submitted for FFWCC Approval
Item:  LTLED-A19-10A-Amber Dimming: Non-Dimmable Power: 9 Watts Turtle Safe Light in Household Bulb Configuration
Base: Medium Dimensions: 2.4" x 4.7" Beam Angle: 120°
LEDs: Samsung LEDs Input voltage: 90-130VAC Lumens: 590 LM
Note: All specification information falls within a ± 2% range
" . "" . "" . "©2012 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

" . "  << Return to $subcat" . "
" . "" . " ©2012 Eco-\$mart, Inc." . "   (888) 329-2705" . "   info@eco-smart.com" . "   www.eco-smart.com" . "" . " QUOTE " . "" . " PRINT " . "
"); echo("
" . "
" . "
" . "" . "
" . "" . "
"); $getcats = $dbcnx->query("SELECT cat_name,catpage FROM cats ORDER BY cat_name"); if(!$getcats){ $air[]="Could not get categories for menu. Error: "; }else{ while ($row = $getcats->fetch_row()) { echo("" . "
"); }//while fetching cats }//got cats echo("" . "
" . "" . "
 
"); if($repped==""){ $skip="on"; }else{ $show="on"; $dnum=date(Ymd)*4; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $checkrep=mysql_query("SELECT ID FROM psw WHERE usrn='$repped'"); if(!$checkrep){ $air[]="Could not verify rep. Error: ".mysql_error(); $show="off"; }else{ $row=mysql_fetch_array($checkrep); $uID=$row[0]; if($uID==""){ $air[]="Representative does not match records."; $show="off"; }else{ echo("

" . " Eco-\$mart Representative $repped Logged In. 

"); mysql_select_db('ecosmar_inv', $dbcnx); $getquote = $dbcnx->query("SELECT ID,CID FROM quotes WHERE usrn='$repped'"); if(!$getquote){ $air[]="Could not get quotes for ".$repped.". Error: ".mysql_error(); $show="off"; }else{ $numquos=mysql_num_rows($getquote); if($numquos < 1){ $show="off"; $air[]="No Quotes Started."; }else{//there are quotes while($rowq=mysql_fetch_array($getquote)){ $QIDs[]=$rowq['ID']; $CIDs[]=$rowq['CID']; }//while getting and filling arrays mysql_select_db('ecosmar_contacts', $dbcnx); foreach($CIDs as $value){ $getcon=mysql_query("SELECT first_Name,Name,Company FROM con_main WHERE ID='$value'"); if(!$getcon){ $air[]="Could not get contact info for contact. Error: ".mysql_error(); $show="off"; }else{ $rowc=mysql_fetch_array($getcon); $first_Name=$rowc[0]; $Name=$rowc[1]; $Company=$rowc[2]; if($Company!=""){ $quocos[]=$Company; }else{ $quocos[]=$first_Name." ".$Name; } }//got contact }//4each quote/contact ID }//there are quotes }//got quote $i=0; $countem=count($items); while($i<$countem){ if(in_array($items[$i],$qoks)){ $ast[]=$items[$i]; $astname[]=$itemnames[$i]; }//in array with dealer prices $i=$i+1; }//while counting items if(empty($ast)){ $air[]="No Quotes. No qualifying prices."; $show="off"; } if($show=="on"){ echo("
" . "
" . "" . "
" . "Eco-\$mart Quotes" . "  Add Products:" . "
"); if(!empty($ast)){ $i=0; $countast=count($ast); while($i<$countast){ if(in_array($ast[$i],$qoks)){ echo("QTY: " . "  ITEM: $ast[$i] ¦ $astname[$i]
"); }//in array with dealer prices $i=$i+1; }//while counting assepted items }//accepted items echo("TO:   " . "" . "" . "" . "" . "
" . "
"); }//show is on }//repped matches usrn in psw }//chekd rep }//rep is present if(!empty($air)){ echo("
"); foreach($air as $value){ echo("
$value"); }//4each echo("
"); }//air is not empty }//print is not yes if($ref_RID!=""){ echo("

RID: $ref_RID

"); } ?>