1. <?
  2. header('Content-Type: text/plain; charset=windows-1250');
  3. header("Content-disposition: attachment; filename=$downloadfile");
  4. header("Content-Transfer-Encoding: binary");
  5. header("Pragma: no-cache");
  6. header("Expires: 0"); 
  7.  
  8. $db = mysql_connect("localhost", "suvelspo_shop", "sutrg658Nzp") or die(mysql_error()); 
  9. mysql_select_db("suvelspo_shop") or die(mysql_error());
  10. date_default_timezone_set('Europe/Ljubljana');
  11.  
  12. mysql_query('SET NAMES utf-8');
  13. mysql_query('SET CHARACTER_SET utf-8');
  14. $result = mysql_query(
  15. "SELECT categories_name,categories_id FROM categories_description");
  16. while ($row = mysql_fetch_assoc($result)){	
  17. 	$kategorije[$row['categories_id']] = $row['categories_name'];
  18. }
  19.  
  20. $result2 = mysql_query("SELECT manufacturers_id,manufacturers_name FROM manufacturers");
  21. while ($row = mysql_fetch_assoc($result2)){	
  22. 	$proizvajalci[$row['manufacturers_id']] = $row['manufacturers_name'];
  23. }
  24.  
  25. $result3 = mysql_query("
  26. 	SELECT p.*, c.categories_id
  27. 	FROM products p 
  28. 	LEFT JOIN products_to_categories c 
  29. 	ON p.products_id = c.products_id 
  30. 	WHERE p.products_status=1 
  31. ");
  32.  
  33. while ($row = mysql_fetch_assoc($result3)){	
  34. 		$temp[$row['products_id']]['ID'] = $row['products_id'];
  35. 		$temp[$row['products_id']]['BRAND'] = $proizvajalci[$row['manufacturers_id']];
  36. 		$temp[$row['products_id']]['PRICE'] = $row['products_price']*1.2;
  37. 		$temp[$row['products_id']]['IN_STOCK'] = $row['products_quantity'];
  38. 		$temp[$row['products_id']]['LINK'] = 'http://www.suvelsport.si/product_info.php?products_id='.$row['products_id'];
  39. 		$temp[$row['products_id']]['SLIKAVELIKA'] = 'http://www.suvelsport.si/images/'.$row['products_image'];
  40. 		$temp[$row['products_id']]['FILEUNDER'] = $kategorije[$row['categories_id']];
  41. }
  42.  
  43. $akcije = mysql_query("
  44. 	SELECT products_id, specials_new_products_price
  45. 	FROM specials
  46. ");
  47.  
  48. while ($row = mysql_fetch_assoc($akcije)){	
  49. 	if(in_array($row['products_id'], $temp)) {
  50. 	$temp[$row['products_id']]['PRICE'] = $row['specials_new_products_price'];
  51. 	}
  52. }
  53.  
  54. $result4 = mysql_query("SELECT products_id,products_name,products_description FROM products_description");
  55. while ($row = mysql_fetch_assoc($result4)){	
  56. 		$temp[$row['products_id']]['NAME'] = str_replace('"', '&quot;', $row['products_name']); 
  57. 		$temp[$row['products_id']]['DESCRIPTION'] = str_replace('"', '&quot;', $row['products_description']); 	
  58. }
  59. echo '"ID","BRAND","PRICE","CURCODE","NAME","DESCRIPTION","LINK","IN_STOCK","EAN","UPC","STVARTIKLA","MODARTIKLA","SLIKAVELIKA","FILEUNDER","GARANCIJA","CUIN","KUPON","DARILO"
  60. ';
  61. foreach($temp as $key => $v){
  62. if ($v['ID'] && $v['BRAND'] && $v['PRICE']) {?>
  63. "<?=$v['ID']?>","<?=$v['BRAND']?>",<?=$v['PRICE']?>,"EUR","<?=$v['NAME']?>","<?=strip_tags($v['DESCRIPTION'], '<br>')?>","<?=$v['LINK']?>","<?=$v['IN_STOCK']?>","","","","","<?=$v['SLIKAVELIKA']?>","<?=$v['FILEUNDER']?>","","","",""
  64. <?}}?>
  65.