Specialised xml feed

Code: Select all

<?php
 
header('Content-type: text/xml');
 
// It will be called digitalsushiitems.xml
header('Content-Disposition: attachment; filename="digitalsushiitems.xml"');
 
// connect to database
$db_name = "database";
$connection = mysql_connect("localhost", "username", "password") or die("Could not connect.");
 
// querying mysql
$db = mysql_select_db($db_name, $connection) or die("Could not connect.");;
 
$result = mysql_query("SELECT * FROM product_selection NATURAL JOIN product");
 
// XML File Creation
$buf ='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ROOT>
<Products>
';
 
while($row=mysql_fetch_array($result)) {
 
      $buf .=  "<Product>
   <ProductCode><![CDATA[ ".htmlentities($row[2]) ." ]]></ProductCode>
   <Title><![CDATA[ ". htmlentities($row2[26]) ." ]]></Title>
   <Category><![CDATA[ ". htmlentities($row[5]) ." ]]></Category>
   <Price>no</Price>
   <Quantity>". htmlentities($row[5]) ."</Quantity>
   <Condition>New</Condition>
   <Location></Location>
   <ShippingOption>Speed Services</ShippingOption>
   <ImageURL><![ CDATA[ http://www.digitalsushi.co.za/image/". htmlentities($row[6]) ." ]]></ImageURL>
   <Description><![CDATA[ ". htmlentities($row2[27]) ." ]]></Description>
 </Product>
 ";
}
 
$buf .= "</Products>
</ROOT>";
 
echo $buf;
 
mysql_close($connection);;
$buf="";
 
?>