duplicate image
| From: | hadi | Date: | Sun, 15 Feb 2015 10:24:23 +0000 |
| Subject: | duplicate image | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-324454@lists.php.net to get a copy of this message | ||
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;
}
}
}
?>