Listing 2722

<?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 count(link) as link_count FROM entries WHERE link = '" . mysql_real_escape_string($link) . "'");
        $row = mysql_fetch_array($result);               
        if($row['link_count'] == 0)
        {
            echo "adding to database";
            $sql =     "INSERT INTO entries (headline, summaries, pubdate, link, viewed) VALUES ('$headline', '$summaries', '$pubdate', '$link', $viewed)";
            mysql_query($sql);
        }
    }
}
 
mysql_close($conn);
?>