The Code-Bin
Links
Home
Add your code!
All Listings
About
Latest Entry
Featured Scripts
Author's Website
Latest Entries
FFMPEG Thumbnail Scr...
PHP, 0.8KB
Jul. 29, 10:24pm
John
Z80 Assembler, 190 bytes
Feb. 17, 3:36am
John
Z80 Assembler, 176 bytes
Sep. 13, 2:19am
John
Z80 Assembler, 77 bytes
Sep. 13, 2:18am
John
Z80 Assembler, 209 bytes
Sep. 13, 2:17am
untitled PHP Code
Posted by: Simon | October 7, 2010 @ 4:27am
PHP Code
[
Download
]
<? 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']; } $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']]; $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']]; } $akcije = mysql_query(" SELECT products_id, specials_new_products_price FROM specials "); while ($row = mysql_fetch_assoc($akcije)){ if(in_array($row['products_id'], $temp)) { $temp[$row['products_id']]['PRICE'] = $row['specials_new_products_price']; } } $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('"', '"', $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']?>","","","","" <?}}?>
Syntax Highlighting
[
Open in new window
]
Author Comments
none
Rating
4.49 / 8
65 Votes
http://codebin.yi.org/880
page generated in 0.00 seconds