1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| <?php
$bdd1='mysql.xxx'; // adresse
$bdd2='xxx'; // login
$bdd3='xxx'; // password
$bdd4='xxx'; / base de donnée
//////// NE PAS TOUCHER /////////////
// système de connection
@require_once("../magpierss/rss_fetch.inc");
function base($bdd1,$bdd2,$bdd3,$bdd4){
$db = mysql_connect($bdd1, $bdd2, $bdd3) or die('Erreur de connexion '.mysql_error());
mysql_select_db($bdd4,$db) or die('Erreur de selection '.mysql_error());
}
// système de lecture du flux rss
function FeedParser($url_feed,$id_n, $nb_items_affiches=10)
{
$rss = fetch_rss($url_feed);
if (is_array($rss->items))
{
$items = array_slice($rss->items,
0, $nb_items_affiches);
foreach ($items as $item)
{
$item['title'] = str_replace(array('\'','"'), array(''','"'), $item['title']);
$item['title']=htmlentities($item['title']);
$date = date("d-m-Y", parse_w3cdtf($item['dc']['date']));
$html .= "$date : <a href=\"".$item['link']."\">";
$html .= $item['title']."</a><br></li>\n";
$verification = mysql_num_rows(mysql_query("SELECT * FROM article_flux WHERE titre='".$item['title']."'"));
if($verification==0){
$verification2 = mysql_fetch_array(mysql_query("SELECT * FROM site2 WHERE id='".$id_n."'"));
$item['description'] = str_replace(array('\'','"'), array(''','"'), $item['description']);
$item['description']=htmlentities($item['description']);
$ajout= "INSERT INTO article_flux (titre, texte, date, url, site) VALUES('$item[title]','$item[description]','$item[date]','$item[link]','$verification2[nom]')";
mysql_query($ajout) or die('Erreur ajout !'.$ajout.'<br>'.mysql_error());
}
}
}
}
function remove_tags($tachaine)
{
return preg_replace('`<img src="[^"]+"(?: [[:alpha:]]+="[^"]+")* ?/?>`', '', $tachaine);
}
// système de mise a jour
base($bdd1,$bdd2,$bdd3,$bdd4);
$sql = "SELECT * FROM site2";
$req = mysql_query($sql) or die('Une Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($data = mysql_fetch_array($req)){
@FeedParser($data['url'],$data['id']); }
$sql = "SELECT * FROM info WHERE id='1'";$data = mysql_fetch_array(mysql_query($sql));$nombre1=$data['info'];
$sql = "SELECT * FROM info WHERE id='2'";$data = mysql_fetch_array(mysql_query($sql));$nombre2=$data['info'];
?> |
Partager