Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define ("DB_HOST", "localhost"); // set database host
- define ("DB_USER", "alove_listadmin"); // set database user
- define ("DB_PASS", "xxxxxxx"); // set database password
- define ("DB_NAME", "alove_listadmin"); // set database name
- $link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
- $db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");
- $query = "SELECT title, description, url FROM ".table_rss." WHERE status=1 ORDER BY created_date desc";
- $getBlogDisplay = mysql_query($query);
- header("Content-type: text/xml");
- echo "<?xml version='1.0' encoding='UTF-8'?-->
- <rss version='2.0'>
- <channel>
- <title>A Love Letter</title>
- <link>http://aloveletter.co.uk/</link>
- <description>a fanlisting collective</description>
- <language>en-us</language>";
- while($dataBlogDisplay = mysql_fetch_array($getBlogDisplay)){
- $title = $dataBlogDisplay['uTitle'];
- $link = $dataBlogDisplay['uID'];
- $description = $dataBlogDisplay['uEntry'];
- $date = $dataBlogDisplay['uAdded'];
- echo "<item>
- <title>$title</title>
- <pubDate>$date</pubDate>
- <link>$link</link>
- <description>$description</description>
- </item>";
- }
- echo "</channel></rss>"; ?>
Advertisement
Add Comment
Please, Sign In to add comment