php δημιουργία xml feed(rss) για ένα ηλεκτρονικό κατάστημα

[nikosvas]

Γειά σας , θέλω να κάνω ένα product feed για το os commerce( os commerce είναι ένα ηλεκτρονικό κατάστημα). Ο κώδικας που έχω κάνει εμφανίζει τα προιόντα αλλά σε html. Πως μπορώ να κάνω ένα xml feed με τα πριόντα? thanks.

 

 

 

 

<? header("Content-type: text/xml"); ?>

 

 

<?php

 

$dbhost = "localhost"; // almost always localhost.

$dbname = "katastima"; // Database Name, In our case, its news

$dbuser = "root"; // Database Username

$dbpass = ""; // Databse Password

 

$connect = mysql_connect("$dbhost","$dbuser","$dbpass");// Connecting to Database

mysql_select_db($dbname) or die (mysql_error()); // Selecting Database

 

 

echo "<?xml version='1.0' encoding='UTF-8'?>

<rss version='2.0'>

<channel>

<title>Products feed</title>

<description></description>

<link>http://localhost/oscommerce-2.3.1/catalog/</link>

 

<ProdId>ProductID </ProdId>

<ProdQ>ProductQuantity</ProdQ>

<ProdP>Product Price</ProdP>

<CategoryId>CategoryId</CategoryId>

<CategoryName>CategoryName</CategoryName>";

$sql="select products_id,products_quantity, products_price,categories_id,categories_name FROM products,categories_description";

 

$result = mysql_query($sql);

 

while($row = mysql_fetch_array($result))

{

$prodID=$row['products_id'];

$prodQuantity=$row['products_quantity'];

$prodP=$row['products_price'];

$categoriesId=$row['categories_id'];

$categoriesName=$row['categories_name'];

 

echo "<item>

<br>

 

<prodID>$prodID</prodID>

<prodquantity>$prodQuantity</prodquantity>

<prodP>$prodP</prodP>

<CategoriesID>$categoriesId</CategoriesID>

<CategoriesName>$categoriesName</CategoriesName> <hr>

 

</item>";

}

echo "</channel></rss>";

?>