Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); $item="LTLED-ECO-U-288**"; $items[] = "LTLED-FTU-U-288CW"; $itemnames[]="18W LED U-shape Tube Light for T8 or T10 Replacement - Clear - Warm White"; $items[] = "LTLED-ECO-U-288CC"; $itemnames[]="18W LED U-shape Tube Light for T8 or T10 Replacement - Clear - Cool White"; $items[] = "LTLED-FTU-U-288CD"; $itemnames[]="18W LED-U-shape Tube Light for T8 or T10 Replacement - Clear - Daylight"; $items[] = "LTLED-FTU-U-288FW"; $itemnames[]="18W LED U-shape Tube Light for T8 or T10 Replacement - Frosted - Warm White"; $items[] = "LTLED-FTU-U-288FC"; $itemnames[]="18W LED U-shape Tube Light for T8 or T10 Replacement - Frosted - Cool White"; $items[] = "LTLED-FTU-U-288FD"; $itemnames[]="18W LED-U-shape Tube Light for T8 or T10 Replacement - Frosted - Daylight"; $countem=count($items); if($countem > 8){//go to price list $addemup=array(); $price_list="on"; foreach($items as $value ){ $result = $dbcnx->query("SELECT item,list FROM price WHERE item = '$value'"); if (!$result) { $buttonmessage="Quote Request"; //echo("ERROR:".mysql_error()."
"); }else{ $ro=mysql_fetch_array($result); $addemup[]=$ro[1]; }//got result }//4each $alladd=array_sum($addemup); if($alladd > 0){ $buttonmessage="Quote List"; $buttonprint="See Quote List"; }else{ $buttonmessage="Quote"; $buttonprint="Quoted"; }//list prices add up to not more than zero }else{ $price_list="off"; //////////////////////////edit labels for price table if presented on this page $labels[]="Cool White"; $labels[]="Daylight White"; $labels[]="Warm White"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; $codes[]="C* = Clear"; $codes[]="F* = Frosted"; $codes[]="*C = Cool White"; $codes[]="*N = Daylight White"; $codes[]="*W = Warm White"; }//pricelist is off ///////////////////////////////////////////////////// if($price_list=="off"){ 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 }//pricelist is off ?>
www.eco-smart.com


BACK

" . ""); $i=0; while($i<$countem){ echo("" . ""); $i=$i+1; }//while counting items echo("" . "" . "" . "" . "" . "" . "" . "" . "" . ""); }//print is not yes else{ echo(""); }//print is yes }//price list is on else{ foreach($labels as $value){ echo(""); }//4each echo(""); $i=0; $countem=count($items); while($i<$countem){ if($print!="yes"){ if($pay[$i]=="yes"){ echo(""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes $i=$i+1; }//while counting items ?> "); }//codes is not empty }//no price list ?>
" . "$buttonprint$value
" . " $items[$i]
$mess[$i]
" . "
" . "" . "" . "" . "" . "" . "QTY: " . " " . "
" . " $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("
Features:
  • No UV or RF interference
  • Ultra-Efficient heat sink and optical diffuser
  • Longer life than fluorescent
  • No mercury
  • No ballast required
  • Wide voltage and constant current design
  • Solid state, high shock & vibration resistant
  • 66%+ savings in energy consumption
  • Quiet, no noise, no flickering
  • Tested to CE, UL and FCC standards
  • 3 Year Warranty

Specifications:
  Base: T8, T10
  Option: Clear or Frosted Cover
  Color Temperature:
   -- Warm White: 3000K
   -- Cool White: 4200K
   -- Daylight White: 6000K
  Lighting Angle: 120°
  Lifespan: 50,000 hours
  Wattage: 18W
  Input voltage: 100-266VAC
  LEDs Superbright SMD: 288
  Lumens: C* 1800 / F* 1600
  Beam angle: DIP 60/120° SMD 120°
  Efficiency C* >100lm/W / F* >89lm/W
  CRI: 75

LED Replacement for U-shaped T8 Lamp LED Replacement for U-shaped T8 Lamp
UL Listed UL Listed
Retro-fit kits available for direct replacement of fluorescent fixture.

Existing ballasts should be removed or by-passed to ensure proper function.

" . "" . "" . "©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("" . "
" . "" . "
 
"); }//print is not yes echo("

RID: $ref_RID

"); ?>