Question

write a sql query to export database data to xml in phpmyadmin.

Answer 1

`Hey,

Note: Brother in case of any queries, just comment in box I would be very happy to assist all your queries

Well brother since you are talking about sql query. I would like to tell you that it is not one line query which will output to xml. You need to extract all particular columns through php and write it to xml file for example:

If I have a MySQL database on my website, and I want an XML output via PHP of the following columns in the table:

1. udid
2. country

mysql_connect('server', 'user', 'pass');
mysql_select_db('database');

$sql = "SELECT udid, country FROM table ORDER BY udid";
$res = mysql_query($sql);

$xml = new XMLWriter();

$xml->openURI("php://output");
$xml->startDocument();
$xml->setIndent(true);

$xml->startElement('countries');

while ($row = mysql_fetch_assoc($res)) {
  $xml->startElement("country");

  $xml->writeAttribute('udid', $row['udid']);
  $xml->writeRaw($row['country']);

  $xml->endElement();
}

$xml->endElement();

header('Content-type: text/xml');
$xml->flush();

Well, you can do it manully very easily by Clicking the SQL tab. Craft a SQL statement that returns the 'part' of the db that you want exported. Then at the bottom of the page there is a 'Export' button. This will take you to a page that will allow you to export in various formats including XML.

Kindly revert for any queries

Thanks.