Creating an XML (or RSS) File for Products

Writing simple xml from a recordset is easy in PHP, and easy in Cartweaver PHP. For example, a simple XML file with product tags:

<?php require_once("application.php");
$query_rsCWProductsSearch = "SELECT
p.product_ID,
p.product_Name,
p.product_OnWeb,
p.product_MerchantProductID
FROM tbl_products p
WHERE
p.product_Archive = 0";
$query_rsCWProductsSearch .= " ORDER BY p.product_Name, p.product_MerchantProductID";
$rsCWProductsSearch = $cartweaver->db->executeQuery($query_rsCWProductsSearch);
$rsCWProductsSearch_recordCount = $cartweaver->db->recordCount;
$row_rsCWProductsSearch = $cartweaver->db->db_fetch_assoc($rsCWProductsSearch);
header("Content-type: text/xml");
echo('<?xml version="1.0" ?>');
echo("<mainTag>");

do { echo("<product>");
echo("<productMerchantId>");
echo($row_rsCWProductsSearch["product_MerchantProductID"]);
echo("</productMerchantId>");
echo("<productId>");
echo($row_rsCWProductsSearch["product_ID"]);
echo("</productId>");
echo("<productName>");
echo($row_rsCWProductsSearch["product_Name"]);
echo("</productName>");
echo("<link>");
echo($cartweaver->settings->targetDetails . "?prodId=" . $row_rsCWProductsSearch["product_ID"]);
echo("</link>");
echo("</product>");
} while ($row_rsCWProductsSearch = $cartweaver->db->db_fetch_assoc($rsCWProductsSearch));

echo("</mainTag>");?>

The XML would look something like this:

<?xml version="1.0" ?>
<mainTag>
  <product>
    <productMerchantId>New Product 2 Options</productMerchantId>
    <productId>36</productId>
    <productName>2-option new</productName>
    <link>http://localhost/phpcart/details.php?prodId=36</link>
  </product>
  <product>
    <productMerchantId>1option</productMerchantId>
    <productId>21</productId>
    <productName>One Option Product</productName>
    <link>http://localhost/phpcart/details.php?prodId=21</link>
  </product>
  <product>
    <productMerchantId>Framed</productMerchantId>
    <productId>37</productId>
    <productName>Picture with frame or not</productName>
    <link>http://localhost/phpcart/details.php?prodId=37</link>
  </product>
  <product>
    <productMerchantId>test333</productMerchantId>
    <productId>35</productId>
    <productName>test333</productName>
    <link>http://localhost/phpcart/details.php?prodId=35</link>
  </product>
  <product>
    <productMerchantId>testauto</productMerchantId>
    <productId>32</productId>
    <productName>testauto</productName>
    <link>http://localhost/phpcart/details.php?prodId=32</link>
  </product>
  <product>
    <productMerchantId>testauto2</productMerchantId>
    <productId>33</productId>
    <productName>testauto2</productName>
    <link>http://localhost/phpcart/details.php?prodId=33</link>
  </product>
</mainTag>

Something like this could easily be adapted for RSS or any other XML file type.

Back to Cartweaver PHP FAQ, code changes, and samples