Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); $prodname="LED Tube Light for T8"; $item="LTLED-ECO-*-**"; $items[] = "LTLED-ECO-8W-001C"; $itemnames[]="8W LED Tube Light for T8 - 2ft. - Cool White"; $items[] = "LTLED-ECO-8W-001D"; $itemnames[]="8W LED Tube Light for T8 - 2ft. - Daylight"; $items[] = "LTLED-ECO-8W-001W"; $itemnames[]="8W LED Tube Light for T8 - 2ft. - Warm White"; $items[] = "LTLED-ECO-4CUL-002C"; $itemnames[]="17W LED Tube Light for T8 - 4ft. - Cool White"; $items[] = "LTLED-ECO-4CUL-002D"; $itemnames[]="17W LED Tube Light for T8 - 4ft. - Daylight"; $items[] = "LTLED-ECO-4CUL-002W"; $itemnames[]="17W LED Tube Light for T8 - 4ft. - Warm White"; $items[] = "LTLED-ECO-19W-001C"; $itemnames[]="19W LED Tube Light for T8 - 5ft. - Cool White"; $items[] = "LTLED-ECO-19W-001D"; $itemnames[]="19W LED Tube Light for T8 - 5ft. - Daylight"; $items[] = "LTLED-ECO-19W-001W"; $itemnames[]="19W LED Tube Light for T8 - 5ft. - Warm White"; $items[] = "LTLED-ECO-22W-001C"; $itemnames[]="22W LED Tube Light for T8 - 6ft. - Cool White"; $items[] = "LTLED-ECO-22W-001D"; $itemnames[]="22W LED Tube Light for T8 - 6ft. - Daylight"; $items[] = "LTLED-ECO-22W-001W"; $itemnames[]="22W LED Tube Light for T8 - 6ft. - Warm White"; $items[] = "LTLED-ECO-22W-001C"; $items[] = "LTLED-ECO-30W-C"; $itemnames[]="30W LED Tube Light for T8 - 8ft. - Cool White"; $items[] = "LTLED-ECO-30W-D"; $itemnames[]="30W LED Tube Light for T8 - 8ft. - Daylight"; $items[] = "LTLED-ECO-30W-W"; $itemnames[]="30W LED Tube Light for T8 - 8ft. - Warm White"; $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="Price List"; $buttonprint="See Price 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[]="7.68W (96 LEDs)"; $labels[]="14.4W (180 LEDs)"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; $codes[]="*CW = Cool White"; $codes[]="*PW = Pure White"; $codes[]="*WW = Warm White"; $codes[]="*B = Blue"; $codes[]="*G = Green"; $codes[]="*R = Red"; $codes[]="*Y = Yellow"; }//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:
  • Aluminum heat sink
  • No UV or RF interference
  • Patented heat sink and optical diffuser
  • 2 & 4’ Models dimmable with Triac Dimmer
  • Longer life than incandescent & 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

Specifications: " . "Specifications PDF"); } ?>
  Base: T8, T10
  Option: Clear or Frosted Cover
  Color Temperature:
   -- Warm White: 3000-3500K
   -- Cool White: 4000-4500K
   -- Daylight White: 5000-6300K
  Lighting Angle: 60, 90, 120°
  Housing temperature: < 35°C
  Ambient Temperature: 20~45°C
  Lifespan: 5 years

Wattage 8W 17W 19W 22W 30W
Length A 2’
(60cm) 		4’
(120cm) 		5’
(150cm) 		6’
(180cm) 		8’
(240cm)
Voltage 85-265
VAC
12V ACDC 		110-277
VAC 		110-277
VAC 		24V
DC 		Tube 37VDC
Driver 90-300VAC
Lumens: 800 1600-1800 1800-2000 2400 3000
*Dimmable: Yes Yes NA NA NA
LED Qty: 180 300 360 408 480
Replaces: 25W 45W 60W 40-48W 100W
*uses Triac dimmer 		LED Replacement T8 Lamp
Retro-fit kits available for direct replacement of fluorescent fixture.

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

" . "" . "" . "©2010 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

" . "  << Return to $subcat" . "
" . "" . "©2010 Eco-\$mart, Inc." . "   (888) 329-2705" . "   info@eco-smart.com" . "   www.eco-smart.com" . "" . " QUOTE " . "" . " PRINT " . "
"); echo("
" . "
" . "
" . "" . "
" . " ECO-\$MART Home " . "
" . "" . "
" . " Catalog Home " . "
"); $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("" . "
" . " $row[0] " . "
"); }//while fetching cats }//got cats echo("" . "
" . " TOP " . "
" . "" . "
 
"); }//print is not yes ?>