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'];
?> |
