Code-Bin #881

untitled PHP Code
Posted by: sdf | October 7, 2010 @ 4:37am

PHP Code

<?
header('Content-Type: text/plain; charset=windows-1250');
header("Content-disposition: attachment; filename=$downloadfile");
header("Content-Transfer-Encoding: binary");
header("Pragma: no-cache");
header("Expires: 0");

$db = mysql_connect("localhost", "suvelspo_shop", "sutrg658Nzp") or die(mysql_error()); 
mysql_select_db("suvelspo_shop") or die(mysql_error());
date_default_timezone_set('Europe/Ljubljana');

mysql_query('SET NAMES utf-8');
mysql_query('SET CHARACTER_SET utf-8');
$result = mysql_query(
"SELECT categories_name,categories_id FROM categories_description");
while ($row = mysql_fetch_assoc($result)){	
	$kategorije[$row['categories_id']] = $row['categories_name'];
}

$result2 = mysql_query("SELECT manufacturers_id,manufacturers_name FROM manufacturers");
while ($row = mysql_fetch_assoc($result2)){	
	$proizvajalci[$row['manufacturers_id']] = $row['manufacturers_name'];
}

$akcije = mysql_query("SELECT products_id, specials_new_products_price FROM specials");
while ($row = mysql_fetch_assoc($akcije)){	
	$akcije_list[$row['products_id']] = $row['specials_new_products_price'];
}

$result3 = mysql_query("
	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 
");

while ($row = mysql_fetch_assoc($result3)){	
		$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");
while ($row = mysql_fetch_assoc($result4)){	
		$temp[$row['products_id']]['NAME'] = str_replace('"', '&quot;', $row['products_name']); 
		$temp[$row['products_id']]['DESCRIPTION'] = str_replace('"', '&quot;', $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']?>","","","",""
<?}}?>

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.52 / 8
58 Votes