Listing 2723

<?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 = false;
    $sql = "INSERT INTO entries (headline, summaries, pubdate, link, viewed) VALUES ";
    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)
        {
            $linkbool = true;
            $sql .=  " ('$headline', '$summaries', '$pubdate', '$link', $viewed), ";
        }
    }
    if($linkbool){
                  echo "adding to database";
                  $sql = substr_replace($sql ,"",-1);
                  mysql_query($sql);
    }
}
 
mysql_close($conn);
?>