创建自定义RSS馈送汇集器 zz

mysql>CREATE TABLE rssfeed (     >rowID tinyint unsigned not null auto_increment,     >title varchar(150) not null,     >url varchar(150) not null,     >primary key(rowID)     >);

mysql>CREATE TABLE user (     >rowID smallint unsigned not null auto_increment,     >email varchar(55) not null,     >pswd varchar(32) not null,     >primary key(rowID)     >);

mysql>CREATE TABLE user_to_rss_feed (     >userid smallint unsigned not null auto_increment,     >rssid tinyint unsigned not null     >);

// Start or continue a sessionsession_start();// Has the userif (! isset($_SESSION['userid'])){   if (! isset($_POST['email']))   {      echo "<form action='myrss.php' method='post'>";      echo "Email:<br />";      echo "<input type='text' name='email' size='20'      maxlength='55' value='' /><br />";      echo "Password:<br />";      echo "<input type='password' name='pswd' size='20'                   maxlength='20' value='' /><br />";      echo "<input type='submit' value='login'>";      echo "</form>";   } else {      mysql_connect("localhost","aggregator","secret");      mysql_select_db("rssfeeds");      $email = $_POST['email'];      $pswd = md5($_POST['pswd']);      $query = "SELECT rowID, email, pswd FROM user                 WHERE email='$email' AND '$pswd'";      $result = mysql_query($query);      if (mysql_numrows($result) != 1)      {         echo "<p>Could not login!</p>";      } else {         list($rowID, $email, $pswd) = mysql_fetch_row($result);         $_SESSION['userid'] = $rowID;      }      mysql_close();   } // end isset[email]}Listing 1-2. RSS汇集和呈送组件if (isset($_SESSION['userid'])) {   require_once("rss_fetch.inc");   mysql_connect("localhost","aggregator","secret");   mysql_select_db("rssfeeds");	   $userID = $_SESSION['userid'];   $query = "SELECT rss.title, rss.url             FROM rssfeed AS rss, user_to_rss_feed as userrss             WHERE userrss.userid='$userID'              AND rss.rowID=userrss.rssid";   $result = mysql_query($query);   while(list($title,$url) = mysql_fetch_row($result))    {      $url = "$url";      $rss = fetch_rss( $url );      echo "<strong>" . $rss->channel['title'] . "</strong><p>";      echo "<ul>";      foreach ($rss->items as $item)       {         $href = $item['link'];         $title = $item['title'];         echo "<li><a href=$href>$title</a></li>";      }      echo "</ul>";   }   mysql_close();}View the complete scrīpt here