Listing 2721

<?php
$conn=mysql_connect("localhost", "root", "");
if (!$conn)
{
    die('Could not connect: ' . mysql_error());
}
mysql_select_db("rsseater", $conn);
 
$rssfeed = mysql_query("SELECT url FROM feeds");
 
while($row = mysql_fetch_array($rssfeed))
{
    $xmldata=simplexml_load_file($row['url']);
    $linkbool = 0;
    foreach($xmldata->channel->item as $values)
    {
        $headline = mysql_real_escape_string($values->title);
        $summaries = mysql_real_escape_string($values->description);
        $pubdate = mysql_real_escape_string($values->pubDate);
        $link = mysql_real_escape_string($values->link);
        $viewed = 0;
        $result = mysql_query("SELECT link FROM entries");
        while($row = mysql_fetch_array($result))
        {
            if($row['link'] == $link)
            {
                echo "already present in database";
                $linkbool=1;
            }
            else
            {
                echo "adding to database";
                $linkbool=0;
            }
        }
        if($linkbool == 0)
        {
            $sql =     "INSERT INTO entries (headline, summaries, pubdate, link, viewed) VALUES ('$headline', '$summaries', '$pubdate', '$link', $viewed)";
            mysql_query($sql);
        }
    }
}
 
mysql_close($conn);
?>