/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: ?>