Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); $prodname="LED Tube Lamp for T10 Replacement"; $item="LTLED-ECO-DG02-*-*"; $items[] = "LTLED-ECO-Tube10-2FT"; $itemnames[]="2FT LED Tube Lamp for T10 Replacement"; $items[] = "LTLED-ECO-Tube10-3FT"; $itemnames[]="3FT LED Tube Lamp for T10 Replacement"; $items[] = "LTLED-ECO-Tube10-4FT"; $itemnames[]="4FT LED Tube Lamp for T10 Replacement"; $items[] = "LTLED-ECO-Tube10-4FT-DIM"; $itemnames[]="4FT LED Tube Lamp for T10 Replacement - Dimmable"; $items[] = "LTLED-ECO-Tube10-5FT"; $itemnames[]="5FT LED Tube Lamp for T10 Replacement"; $items[] = "LTLED-ECO-Tube10-6FT"; $itemnames[]="6FT LED Tube Lamp for T10 Replacement"; $items[] = "LTLED-ECO-Tube10-8FT"; $itemnames[]="8FT LED Tube Lamp for T10 Replacement"; $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[]="2’"; $labels[]="3’"; $labels[]="4’"; $labels[]="4’ DIM"; $labels[]="5’"; $labels[]="6’"; $labels[]="8’"; $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"; $codes=array(); }//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:
 50,000 hours rated life.
 Rotating end cap and standard cap available.
 Choice of SMD and DIP LED.
 Color Temp Options: Warm White, Cool White & Daylight.
 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, no UV or RF interference.
 3 Year Warranty UL Listed

Specifications Specifications PDF"); } ?>

Voltage: 100-277VAC 50/60Hz
Power Factor: >0.9
CRI: >75
Lifespan: 5 years
Beam Angle: DIP:60°/120°, SMD:120°
LED Replacement T10 Lamp Directly replace fluorescent tubes with energy saving LED!

4 FT Tube has Dimmable Option

Item ECO-Tube10-2FT ECO-Tube10-3FT ECO-Tube10-4FT ECO-Tube10-4FT-DIM ECO-Tube10-5FT ECO-Tube10-6FT ECO-Tube10-8FT
Length (L) 2’ 3’ 4’ 4’ 5’ 6’ 8’
Watts 10W 12W 18W 18W 22W 26W 36W
LEDs 160 DIP
120 SMD
220 DIP
220 SMD
280 DIP
290 SMD
290 3528 SMD 320 DIP
350 SMD
390 DIP
410 SMD
560 DIP
580 SMD
Lumens WW
CW
DL
800
900
900
1200
1300
1300
1600
1800
1800
1650
1800
1800
2000
2100
2100
2400
2600
2600
3200
3400
3400
Replace Fluorescent 18W 30W 36W 36W 58W 70W 90W

 

" . "" . "" . "©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

"); ?>