duplicate image

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I have script which download rssfeed from the internet. But unfortunately it
keep downloading duplicate image to the database.

Here is  my script 

<?php
require 'database.php';

$url = "http://www.albaldnews.com/rss.php?cat=24";;
$rss = simplexml_load_file($url);

if($rss)
{
echo '<h1>'.$rss->channel->title.'</h1>';
echo '<li>'.$rss->channel->pubDate.'</li>';
$items = $rss->channel->item;
foreach($items as $item)
{

$title = $item->title;
$link = $item->link;
$published_on = $item->pubDate;
$description = $item->description;
$category = $item->category;
$guid = $item->guid;
$enclosure = $item->enclosure[0]['url'];


$ch = curl_init ("$item->enclosure");
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_BINARYTRANSFER,1);
$rawdata=curl_exec ($ch);
curl_close ($ch);


mysqli_real_escape_string($conn,$item->title);
mysqli_real_escape_string($conn,$item->link);
mysqli_real_escape_string($conn,$item->pubDate);
mysqli_real_escape_string($conn,$item->description);
mysqli_real_escape_string($conn,$item->category);
$img=mysqli_real_escape_string($conn,$rawdata);

$sql = "INSERT INTO feedtable
(title,link,pubdate,description,category,image)VALUES
('$item->title','$item->link','$item->pubDate','$item->description','$item->
category','$img')";
$result = mysqli_query($conn, $sql);

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully\n";
}
else
{
    echo "Error:\n " . $sql . "<br>" . $conn->error;
}

}
}

?>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux