/home/wpollock1/public_html/PHP/myrss.php
1: <?php
2: // Downloaded on 12/22/08 from http://www.developer.com/xml/article.php/3113931
3:
4: session_start();
5:
6: if (! isset($_SESSION['userid']))
7: {
8:
9: if (! isset($_POST['email']))
10: {
11:
12: echo "<form action='myrss.php' method='post'>";
13: echo "Email:<br />";
14: echo "<input type='text' name='email' size='20' maxlength='55' value='' /><br />";
15: echo "Password:<br />";
16: echo "<input type='password' name='pswd' size='20' maxlength='20' value='' /><br />";
17: echo "<input type='submit' value='login'>";
18: echo "</form>";
19:
20: } else {
21:
22: mysql_connect("localhost","aggregator","secret");
23: mysql_select_db("rssfeeds");
24:
25: $email = $_POST['email'];
26: $pswd = md5($_POST['pswd']);
27:
28: $query = "SELECT rowID, email, pswd FROM user WHERE email='$email' AND '$pswd'";
29: $result = mysql_query($query);
30:
31: if (mysql_numrows($result) != 1)
32: {
33: echo "<p>Could not login!</p>";
34: } else {
35: list($rowID, $email, $pswd) = mysql_fetch_row($result);
36: $_SESSION['userid'] = $rowID;
37: }
38:
39: mysql_close();
40:
41: } // end isset[email]
42:
43: }
44:
45: if (isset($_SESSION['userid'])) {
46:
47: mysql_connect("localhost","aggregator","secret");
48: mysql_select_db("rssfeeds");
49:
50: require_once("rss_fetch.inc");
51:
52: $userID = $_SESSION['userid'];
53:
54: $query = "SELECT rss.title, rss.url FROM rssfeed AS rss, user_to_rss_feed as userrss
55: WHERE userrss.userid='$userID' AND rss.rowID=userrss.rssid";
56:
57: $result = mysql_query($query);
58: while(list($title,$url) = mysql_fetch_row($result)) {
59:
60: $url = "$url";
61: $rss = fetch_rss( $url );
62:
63: echo "Channel Title: " . $rss->channel['title'] . "<p>";
64: echo "<ul>";
65: foreach ($rss->items as $item)
66: {
67: $href = $item['link'];
68: $title = $item['title'];
69: echo "<li><a href=$href>$title</a></li>";
70: }
71:
72: echo "</ul>";
73:
74: }
75:
76: mysql_close();
77:
78: }
79:
80: ?>