//echo $req_select; $req = mysql_query($req_select) or die('\\nInvalid query: ' . $req_select . ' ' . mysql_error()); if (mysql_num_rows($req) > 0) { $xml = '<xml>'; while ($row = mysql_fetch_assoc($req)) { $xml .= '<object>'; foreach ($row as $fieldname => $fieldvalue) { if ($fieldname == 'category') { $categ_id = $row['id']; $category_path = getCategoryPath($categ_id, $parent_id = 0) . "/" . getCategoryName($categ_id); $category_path = constant('_COLLECTION_CIM_ID_') . "" . $category_path; $xml .= '<' . $fieldname . '>' . $category_path . '</' . $fieldname . '>'; } else { $xml .= '<' . $fieldname . '>' . $fieldvalue . '</' . $fieldname . '>'; } } $xml .= '</object>'; } if ($order_item_id != "") { $xml .= getProductAttributeFormattedList($order_item_id); } $xml .= '</xml>'; header('Content-type: text/xml'); echo $xml; } else { $xml = "<xml></xml>"; } } else { echo '\\nInvalid query: No parameter given!'; } mysql_close();
<?php include "includes/config.inc.php"; include "includes/function.php"; //Get the query string and complete the SQL query $product_id = "8"; if (isset($_POST['product_id'])) { $product_id = $_POST['product_id']; } elseif (isset($_POST['group_id'])) { $product_id = $_POST['group_id']; } if ($product_id != "") { $xml = '<xml>'; $xml .= getProductAttributeFormattedList($product_id); $xml .= '</xml>'; header('Content-type: text/xml'); echo $xml; } else { echo "<xml></xml>"; } mysql_close();