XML_encode??

[mayurabtMember]

Hi,

This below code feeds records from MySQL database in the form of Json with the use of json_encode() function.
Is there any function to encode this in form of XML? something like XML_encode()….

Code:
..
..
..
..
$query = “SELECT * FROM master_data group by Region”;

$result = mysql_query($query) or die(“SQL Error 1: ” . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$ordertype[] = array(
‘MasterID’ => $row[‘master_Data_id’],
‘OrderNumber’=> $row[‘Order_Number’],
‘OrderType’ => $row[‘Order_Type’],
‘OrderSource’ => $row[‘Order_Source’],
‘BillToCustomer’ => $row[‘Bill_To_Customer’],
‘Region’ => $row[‘Region’],
‘LICTotalUSD’ => $row[‘License_Total_in_Constant_USD’],
‘CreatedDate’ => $row[‘Date_Ordered’],
‘BookedDate’ => $row[‘Booked_Date’]
);
}

echo json_encode($ordertype);
?>

[Peter StoevKeymaster]

Hi mayurabt,

Unfortunately, we are not aware whether there is such PHP function.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[mayurabtMember]

Oh… its Sad… is there any other way the records from MySQL database be pushed in form of XML?
In examples and demos I see only the pre-existing XML files being used as URLs to fetch details on to some controls… but there is no example showing how to get those XML files in first place? is there any? Please assist..

[Peter StoevKeymaster]

Hi mayurabt,

Here’s a link related to your scenario: http://stackoverflow.com/questions/5112282/get-mysql-database-output-via-php-to-xml

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts