Using PHP to make an xml file

SeanKann

It works but it only does the last entry in the database.

I want to have it as a link to just click it and it makes an xml file of my database so it has the most up to date info in the .xml page.

Any ideas why it's only getting the last entry?

<?php

include( 'connection.php' );

mysql_connect($dbhost,$dbuser,$dbpass) or die("Unable to connect to database");
@mysql_select_db("$dbname") or die("Unable to select database $dbname");

$query = "SELECT * FROM $table";
$result=mysql_query($query);

while($row = mysql_fetch_array($result))
  {

$xml_dec = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";
$rootElementStart = "<business_info>";
$rootElementEnd = "</business_info>";
$results = "results";
$xml_doc= $xml_dec;

$xml_doc .= $rootElementStart;

$xml_doc .= "<business_name>";

$xml_doc .= "".$row['business_name'] ."";

$xml_doc .= "</business_name>";

$xml_doc .= "<business_address>";

$xml_doc .= "".$row['business_address'] ."";

$xml_doc .= "</business_address>";

$xml_doc .= $rootElementEnd;
$default_dir = "xml/";
$default_dir .= $results.".xml";
$fp = fopen($default_dir,'w');

$write = fwrite($fp,$xml_doc);

}
echo "done";
mysql_close();
?>

Kudose

The easiest way would be to let MySQL do it for you

[cli]$ mysql --xml --user=me --password=you db_name -e "SELECT * FROM table" > out.xml

http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_xml

You could also try restructuring your document

i.e.

<?xml ... ?>
<rss version="2.0">
  <channel>
    <title>Feed Name</title>
    <link>http://www.website.com</link>
    <description>La la la</description>
    <item>
      <biz_name>data</biz_name>
      <biz_addy>data</biz_addy> 
    </item>
    <item>
      <biz_name>data</biz_name>
      <biz_addy>data</biz_addy> 
    </item>
    <item>
      <biz_name>data</biz_name>
      <biz_addy>data</biz_addy> 
    </item>
  </channel>
</rss>

SeanKann

ya but I need to do it on the website where it has the most up to date info. So I can like just click on a link or load a page to update the xml file.

I don't want to have to login to mysql all the time to get this file updated.

Kudose

Ok, then the reason you are having a problem is because you loop through the results and write to the file each time using "w" which means "write over the file, or create and write to the file.

You want "a" for "append"

Also, you should create the file like this

<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
  <channel>
    <title>Feed Name</title>
    <link>http://www.website.com</link>
    <description>La la la</description>
    <business_info>
      <business_name>data</business_name>
      <business_address>data</business_address> 
    </business_info>
    <business_info>
      <business_name>data</business_name>
      <business_address>data</business_address> 
    </business_info>
  </channel>
</rss>

Maybe not as RSS 2.0, but with some structure or DTD in place.

SeanKann

the A fixed it but now all the data keeps looping.

?xml version="1.0" encoding="UTF-8" ?><business_info><business_name>St. Louis Bar and Grill</business_name><business_address>595 Bay St</business_address><br></business_info><?xml version="1.0" encoding="UTF-8" ?><business_info><business_name>Soma</business_name><business_

i tried moving some things around to stop it from loooping but no matter what I do it just keeps looping.

any ideas?

Kudose

$xml_dec = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";
$rootElementStart = "<business_info>";
$rootElementEnd = "</business_info>";
$results = "results";
$xml_doc= $xml_dec;

Should not be in yrou loop for starters. Can you post your modified code?