This script is producing my xml file from database:
<?php
//--------------------------------------------------------------------------
// This is where you specify your Database connection stuff
//
// mysql_connect -- Open a connection to a MySQL Server / die -- Alias of exit()
//
//--------------------------------------------------------------------------
$db_name = "my_database_name"; //This is your database Name
$link = mysql_connect("localhost", "username", "pass") or die("Could not connect to server!");
//This is your table name. This is a one table config to do more table you will need to rework the code.
$table_name = 'my_table_from_database';
$broj = 20;
$select_db = mysql_select_db($db_name, $link); // mysql_select_db -- Select a MySQL database
$query = "SELECT * FROM table WHERE status = '1' ORDER BY id DESC LIMIT 20";
$result = mysql_query($query, $link) or die("Could not complete database query"); //mysql_query -- Send a MySQL query
$num = mysql_num_rows($result); //mysql_num_rows -- Get number of rows in result
if ($num != 0) {
//--------------------------------------------------------------------------
// If you would like to save a copy of the XML Doc being created uncomment this
// line and the two lines at the bottom containing fwrite and fclose.
//
//
//--------------------------------------------------------------------------
$file= fopen("feed.xml" , "w"); //fopen -- Opens file or URL
//--------------------------------------------------------------------------
// XML Header Tag Goes Here
//
//
//
//--------------------------------------------------------------------------
$_xml ='<?xml version="1.0" encoding="windows-1250"?>';
$_xml .='<rss version="2.0">';
$_xml .='<channel>';
$_xml .='<title>domain.com</title>';
$_xml .='<link>http://www.domain.com/</link>';
$_xml .='<description>Description.</description>';
$_xml .='<docs>http://www.domain.com/feed.xml</docs>';
//--------------------------------------------------------------------------
// This while loop loops throught the data found from the above query and
// generates the XML Doc.
//
//
//--------------------------------------------------------------------------
while ($row = mysql_fetch_array($result)) { //mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both.
$_xml .=' <item>';
$_xml .=' <title>' . $row[title_row] . '</title>';
$_xml .=' <description>' . $row[short_description] . '</description>';
$_xml .=' <link>http://www.domain.com/url/' . $row[id] . '</link>';
$_xml .=' <guid>http://www.domain.com/url/' . $row[id] . '</guid>';
$_xml .=' <author>email@domain.com</author>';
//You can use if statements to check if the returned value is null.
//If it is just place a default value in the tags like below.
$_xml .=' </item>';
}
$_xml .='</channel>';
$_xml .='</rss>';
//--------------------------------------------------------------------------
// If you would like to save a copy of the XML Doc being created uncomment this
// line and the two lines at the bottom containing fwrite and fclose.
//
//
//--------------------------------------------------------------------------
fwrite($file, $_xml); //fwrite -- Binary-safe file write
fclose($file); //fclose -- Closes an open file pointer
//--------------------------------------------------------------------------
// This will echo the XML file out to the screen so you can view it.
//
//
//
//--------------------------------------------------------------------------
echo $_xml;
} else {
echo "No Records found";
}
?>
Can this help?