<?php
$server = "localhost";
$user = "";
$password = "";
$mysqlbase = "";
$conn=mysql_connect($server,$user,$password) or die(erreurServeurMySQL());
mysql_select_db($mysqlbase,$conn) or die('Problem sa konekcijom '.mysql_error());
$query1 = ('select * from linkovi order by id asc LIMIT 1');
$result1 = mysql_query($query1) or die('Query failed: ' . mysql_error());
while ($row1 = mysql_fetch_assoc($result1)):
$oXML = simplexml_load_file( $row1['link'] );
endwhile;
foreach ($oXML->channel->item as $oItem)
{
$sSQL = sprintf("INSERT INTO rss (`id`,`title`,`link`,`description`,`timestamp`)VALUES('','%s','%s','%s',%s)",
mysql_escape_string($oItem->title),
mysql_escape_string($oItem->link),
mysql_escape_string($oItem->description),
time()
);
mysql_query($sSQL);
echo 'Informacije upisane u bazu';
}
?>
Napravio sam skriptu pomocu koje vijesti sa rss feedova upisujem u bazu podataka. Moze li mi neko pomoc kako da napravim provjeru da li u bazi postoji neki odredjeni link tako da nebi dolazilo do dupliranja vijesti.
Unaprijed zahvalan
|