PHP / XML write and save to DB

cmccomas

I have the following code:

<?php 
header ("content-type: text/xml" ); 
print "<?xml version=\"1.0\"?>\n"; 
mysql_connect ("localhost", "database_username", "**********" ) or die ("<b>Unable to establish connection with MySQL.</b>\n" ); 
mysql_select_db("database_name") or die ( "<b>Unable to locate specified database.</b>"); 

$query = "SELECT * FROM client_news ORDER BY date DESC LIMIT 1, 5"; 
$result = mysql_query ($query); 

print "<recent_news>" ; 

while($id = mysql_fetch_object( $result )) { 
    print "<ID>\n"; 
    print "<headline>".$id->headline ."</headline>\n" ; 
    print "<intro>" .$id ->intro."</ intro>\n"; 
    print "<url>" .$track->url."</url>\n" ;  

    print "</ID>\n" ; 
} 
print "</recent_news>"; 
?>

What I need to add to it, is it writing to a .xml file, then saves it to the database. Can anyone help me or point me in the right direction?

rincewind456

You could read the database result into an array like so:

<?php
header ("content-type: text/xml" ); 
print "<?xml version=\"1.0\"?>\n"; 
mysql_connect ("localhost", "database_username", "**********" ) or die ("<b>Unable to establish connection with MySQL.</b>\n" ); 
mysql_select_db("database_name") or die ( "<b>Unable to locate specified database.</b>"); 

$query = "SELECT * FROM client_news ORDER BY date DESC LIMIT 1, 5";
$result = mysql_query ($query);

$recent_news .= "<recent_news>\n" ;

while($id = mysql_fetch_object( $result )) {
    $recent_news .= "<ID>\n";
    $recent_news .= "<headline>".$id->headline ."</headline>\n" ;
    $recent_news .= "<intro>" .$id ->intro."</intro>\n";
    $recent_news .= "<url>" .$track->url."</url>\n" ;
    $recent_news .= "</ID>\n" ;
}
$recent_news .= "</recent_news>";

file_put_contents('recent_news.xml',$recent_news)
?>

then use file_put_contents() to write the xml file and also write the array back to the Database.

cmccomas

Thank you!

One more thing, when I add a news item to the CMS, how should I have the XML update? Will it automatically update it?

rincewind456

If you run the script it will write a new copy of "recent_news.xml" every time you run it.

jbachris

rincewind456 wrote:
If you run the script it will write a new copy of "recent_news.xml" every time you run it.

I tried the above code and it did not work. I get this error:

Fatal error: Call to undefined function: file_put_contents() in /home/mario/public_html/news.php on line 21

samudasu

jbachris,

jbachris wrote:
I tried the above code and it did not work. I get this error:

Fatal error: Call to undefined function: file_put_contents() in /home/mario/public_html/news.php on line 21

You probably aren't using php5 so your can't use file_put_contents. Just use fopen, frwite, and fclose. It take 3 functions but it does the same as file_put_contents. You can probably find an example in the php manual if you don't know how to use them.

MarkR

You may want to either use DOM to generate your XML document, or correctly escape those strings that you're putting into it.

Also, what encoding are you using? Pay special attention to this as XML uses UTF-8 by default, and PHP does not (actually, it's generally ignorant).

Try with some non-ascii characters in your data (like £) and some < & and >

Mark

khatibti

activation de bank