I'm currently working on creating the xml feed since I had data ready
in my database after web data extraction. However, it has errors for
this line:
<xml version="1.0" encoding="ISO-8859-1">
I was unable to solve this.
<html>
<head>
<title>MMU RSS FEED</title>
</head>
<body>
header("Content-type: application/xml");
<xml version="1.0" encoding="ISO-8859-1">
<rss version ="2.0">
<channel>
<title>MMU RSS FEED Today: <?php echo date("D, d-M-Y H:i:s")?></
title>
<link>http://bulletin.mmu.ed u.my/</link>
<description>MM U RSS FEED</description>
<ttl>60<ttl>
<?php
//connect to database
$db = mysql_connect(" localhost", "root", "") or die(mysql_error ());
mysql_select_db ("bulletin", $db) or die(mysql_error ());
$day = date("Y-n-j");
//select queries
$sql = "SELECT * FROM `bul_data` WHERE `DATE` LIKE '{$day}%' ORDER by
`DEPARTMENT`";
echo "sql=".$sql ;
$res = mysql_query($sq l) or die(mysql_error ());
if(mysql_num_ro ws($res)>0)
{
while($row=mysq l_fetch_assoc($ res))
{
$date = $row['DATE'];
$title = $row['TITLE'];
$department = $row['DEPARTMENT'];
$link = $row['LINK'];
//output to browser
echo "<item>";
echo "<title>$ti tle</title>";
echo "<category>$dep artment</category>";
echo "<link><a href=\"$link\"> $link</a></link>";
echo "</item>";
}
echo "</table>";
}
?>
</channel>
</rss>
</body>
</html>
