Advertisement
Guest User

Untitled

a guest
Apr 19th, 2013
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. <?php
  2. echo '<?xml version="1.0"?>
  3. <rss version="2.0">
  4. <channel>
  5. <title>Better information delivery page</title>
  6. <link>http://127.0.0.1/testingArea/</link>
  7. <description>Some random junk nobody reads anyway</description>';
  8.  
  9. $link = mysql_connect("127.0.0.1", "root", "")
  10. or die("failed". mysql_error());
  11. print ("Connected successfully");
  12. echo '<br />';
  13. mysql_select_db("rssfeeds")
  14. or die("not working". mysql_error());
  15. $result=MYSQL_QUERY("SELECT * FROM feeds");
  16.  
  17. while ($row=MYSQL_FETCH_ARRAY($result))
  18. {
  19. $header=$row['header'];
  20. $descr=$row['descr'];
  21. $year=$row['year'];
  22. echo '<item>
  23. <title>.$header.</title>
  24. <link>http://127.0.0.1/testingArea/stuff.php</link>
  25. <description>$descr</description>
  26. <author>$year</author>
  27. </item>';
  28. }
  29. echo '</channel>
  30. </rss>';
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement