Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); $prodname="LED Tube Lamp for T8 Replacement"; $item="LTLED-ECO-DG02-*-*"; $items[] = "LTLED-ECO-A-2G3-I"; $itemnames[]="9W LED T8 Tube Replacement Lamp - A Series - Internal Power Supply - 24 Inches"; $items[] = "LTLED-ECO-A-4G3-I"; $itemnames[]="18W LED T8 Tube Replacement Lamp - A Series - Internal Power Supply - 48 Inches"; $items[] = "LTLED-ECO-A-5G3-I"; $itemnames[]="21W LED T8 Tube Replacement Lamp - A Series - Internal Power Supply - 60 Inches"; $items[] = "LTLED-ECO-A-2G3-E"; $itemnames[]="9W LED T8 Tube Replacement Lamp - A Series - External Power Supply - 24 Inches"; $items[] = "LTLED-ECO-A-4G3-E"; $itemnames[]="18W LED T8 Tube Replacement Lamp - A Series - External Power Supply - 48 Inches"; $items[] = "LTLED-ECO-A-5G3-E"; $itemnames[]="21W LED T8 Tube Replacement Lamp - A Series - External Power Supply - 60 Inches"; $items[] = "LTLED-ECO-DG02-2-I"; $itemnames[]="10W LED T8 Tube Replacement Lamp - D Series - Internal Power Supply - 24 Inches"; $items[] = "LTLED-ECO-DG02-4-I"; $itemnames[]="18W LED T8 Tube Replacement Lamp - D Series - Internal Power Supply - 48 Inches"; $items[] = "LTLED-ECO-DG02-5-I"; $itemnames[]="24W LED T8 Tube Replacement Lamp - D Series - Internal Power Supply - 60 Inches"; $items[] = "LTLED-ECO-DG02-2-E"; $itemnames[]="10W LED T8 Tube Replacement Lamp - D Series - External Power Supply - 24 Inches"; $items[] = "LTLED-ECO-DG02-4-E"; $itemnames[]="18W LED T8 Tube Replacement Lamp - D Series - External Power Supply - 48 Inches"; $items[] = "LTLED-ECO-DG02-5-E"; $itemnames[]="24W LED T8 Tube Replacement Lamp - D Series - External Power Supply - 60 Inches"; $items[] = "LTLED-ECO-23W-002"; $itemnames[]="23W LED T8 Tube Replacement Lamp - 2 Lamp External Power Supply - 48 Inches"; $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[]="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 $codes=array(); ///////////////////////////////////////////////////// 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
 Longer life than incandescent & fluorescent
 Rated 50,000 Hour Lifetime
 No mercury
 No ballast
 Wide voltage and constant current design
 Solid state, high shock & vibration resistant
 66% + savings in energy consumption
 Quiet, no noise, no flickering
 5 Year Warranty
Directly replace fluorescent tubes!
LED Replacement T8 Lamp Specification PDFs
   DG Series
  A Series   Internal Power Supply
                     External Power Supply
  ROI Calculator T8 Example XLS
UL Listed American Recovery and Reinvestment Act 2009 Eco-A Series   Replace T8 Fluorescent Tubes   Beam Angle: 120°  Voltage: 100 to 277VAC
Color Temp Options: Warm White - 3000K,  Cool White - 4200K,  Daylight - 6000K
Item ECO-A-2G3-I ECO-A-4G3-I ECO-A-5G3-I ECO-A-2G5-E ECO-A-4G5-E ECO-A-5G5-E
Length (Inches) 24" 48" 24" 48" 60"
Watts 9W 18W 21W 9W 18W 21W
Power Supply Internal Internal Internal External 1 Lamp External 1 Lamp External 1 Lamp
LED Qty. 40 SMD 80 SMD 100 SMD 32 SMD 64 SMD 80 SMD
Lumens WW
CW
DL
800
890
890
1700
1800
1800
2000
2100
2100
800
890
890
1700
1800
1800
2000
2100
2100
 
ETL Listed Eco-DG Series   Replace T8 Fluorescent Tubes   Beam Angle: 120°  Voltage: 100 to 277VAC
Color Temp Options: Warm White - 3000K,  Cool White - 4200K,  Daylight - 6000K
Item ECO-DG02-2-I ECO-DG02-4-I ECO-DG02-5-I ECO-DG02-2-E ECO-DG02-4-E ECO-DG02-5-E
Length (Inches) 24" 48" 24" 48" 60"
Watts 10W 18W 24W 10W 18W 24W
Power Supply Internal Internal Internal External 2 Lamp External 2 Lamp External 2 Lamp
LED Qty. 40 SMD 80 SMD 100 SMD 40 SMD 80 SMD 100 SMD
Lumens WW
CW
DL
900
1000
1000
1700
1800
1800
2300
2400
2400
900
1000
1000
1700
1800
1800
2300
2400
2400
UL Listed Designlights Consortium W Series   Replace T8 Fluorescent Tubes   Beam Angle: 120°  Voltage: 100 to 277VAC
Color Temp Options: Warm White - 3000K,  Cool White - 4200K,  Daylight - 6000K
Item ECO-22W-002
Length (Inches) 48"
Watts 23W
Power Supply External 2 Lamp Driver
LED Qty. 120pcs S2323 SMD LEDs (LM80)
Lumens WW
CW
DL
2100
2200
2200
" . "" . "" . "©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

"); ?>