Creating an xml file from php and mysql?

Question

How do I create an xml file from php for other people to use the content for their own work? Thanks

Answer 1

An XML is merely a text file that has a defined layout (which is dependent upon the application).

So, you could simply use the printf(), echo(), or print() commands, like this:

   $title = "This is my title";

   printf("\n\t", $title);



Of course, if you're generating the XML and storing it into a file and then sending it in an email, then you want to use the fwrite() command.



Or if you have PHP version 5.1.2 or greater, you can use the XML functions provided by the language, such as this: http://us.php.net/manual/en/function.xmlwriter-open-uri.php

Answer 2

xml_parser_create



You may want to review the PHP manual. If you are using an open sourced PHP program like moodle, or wordpress XML parsing tools are available to add on to the applicaiton.

Answer 3

The Sample PHP code is
header ("content-type: text/xml");

mysql_connect('localhost','root','') or die(mysql_error());

mysql_select_db('fitness') or die(mysql_error());

$xml='';

$qr=mysql_query("SELECT * FROM `f_img` order by id desc") or die(mysql_error());

$xml.='';

while($res=mysql_fetch_array($qr))

{

$xml.=''.$res['name'].''.$res['state'].''.$res['country'].'';

}

$xml.='';

echo $xml;

?>