<?
header('Content-Type: text/plain; charset=windows-1250');
header("Content-disposition: attachment; filename=$downloadfile");
header("Content-Transfer-Encoding: binary");
date_default_timezone_set('Europe/Ljubljana');
"SELECT categories_name,categories_id FROM categories_description");
$kategorije[$row['categories_id']] = $row['categories_name'];
}
$result2 =
mysql_query("SELECT manufacturers_id,manufacturers_name FROM manufacturers");
$proizvajalci[$row['manufacturers_id']] = $row['manufacturers_name'];
}
$akcije =
mysql_query("SELECT products_id, specials_new_products_price FROM specials");
$akcije_list[$row['products_id']] = $row['specials_new_products_price'];
}
SELECT p.*, c.categories_id
FROM products p
LEFT JOIN products_to_categories c
ON p.products_id = c.products_id
WHERE p.products_status=1
");
$temp[$row['products_id']]['ID'] = $row['products_id'];
$temp[$row['products_id']]['BRAND'] = $proizvajalci[$row['manufacturers_id']];
if($akcije_list[$row['products_id']]){
$temp[$row['products_id']]['PRICE'] = $akcije_list[$row['products_id']]*1.2;
}else{
$temp[$row['products_id']]['PRICE'] = $row['products_price']*1.2;
}
$temp[$row['products_id']]['IN_STOCK'] = $row['products_quantity'];
$temp[$row['products_id']]['LINK'] = 'http://www.suvelsport.si/product_info.php?products_id='.$row['products_id'];
$temp[$row['products_id']]['SLIKAVELIKA'] = 'http://www.suvelsport.si/images/'.$row['products_image'];
$temp[$row['products_id']]['FILEUNDER'] = $kategorije[$row['categories_id']];
}
$result4 =
mysql_query("SELECT products_id,products_name,products_description FROM products_description");
$temp[$row['products_id']]['NAME'] =
str_replace('"',
'"',
$row['products_name']);
$temp[$row['products_id']]['DESCRIPTION'] =
str_replace('"',
'"',
$row['products_description']);
}
echo '"ID","BRAND","PRICE","CURCODE","NAME","DESCRIPTION","LINK","IN_STOCK","EAN","UPC","STVARTIKLA","MODARTIKLA","SLIKAVELIKA","FILEUNDER","GARANCIJA","CUIN","KUPON","DARILO" ';
foreach($temp as $key => $v){
if ($v['ID'] && $v['BRAND'] && $v['PRICE']) {?>
"<?=$v['ID']?>","<?=$v['BRAND']?>",<?=$v['PRICE']?>,"EUR","<?=$v['NAME']?>","<?=strip_tags($v['DESCRIPTION'], '<br>')?>","<?=$v['LINK']?>","<?=$v['IN_STOCK']?>","","","","","<?=$v['SLIKAVELIKA']?>","<?=$v['FILEUNDER']?>","","","",""
<?}}?>