HeartFelt

RSS Feed Creation

May 1st, 2014
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 1.25 KB | None | 0 0
  1. <?php
  2. define ("DB_HOST", "localhost"); // set database host
  3. define ("DB_USER", "alove_listadmin"); // set database user
  4. define ("DB_PASS", "xxxxxxx"); // set database password
  5. define ("DB_NAME", "alove_listadmin"); // set database name
  6.  
  7. $link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
  8. $db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");
  9.  
  10. $query = "SELECT title, description, url FROM ".table_rss." WHERE status=1 ORDER BY created_date desc";
  11. $getBlogDisplay = mysql_query($query);
  12.  
  13. header("Content-type: text/xml");
  14.  
  15. echo "<?xml version='1.0' encoding='UTF-8'?-->
  16. <rss version='2.0'>
  17. <channel>
  18.     <title>A Love Letter</title>
  19.     <link>http://aloveletter.co.uk/</link>
  20.     <description>a fanlisting collective</description>
  21.     <language>en-us</language>";
  22.  
  23.  
  24. while($dataBlogDisplay = mysql_fetch_array($getBlogDisplay)){
  25.            
  26.  $title         = $dataBlogDisplay['uTitle'];
  27.  $link          = $dataBlogDisplay['uID'];
  28.  $description   = $dataBlogDisplay['uEntry'];
  29.  $date          = $dataBlogDisplay['uAdded'];
  30.  
  31. echo "<item>
  32.     <title>$title</title>
  33.     <pubDate>$date</pubDate>
  34.     <link>$link</link>
  35.     <description>$description</description>
  36. </item>";
  37. }
  38. echo "</channel></rss>"; ?>
Advertisement
Add Comment
Please, Sign In to add comment