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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
| <?php
if (!$CodeMembre)
{
?><br /><span class="TitreMenuDroite" ><strong>Visite guidée de x</strong></span><br /><br /><object width="270" height="166"><param name="movie" value="http://www.youtube.com/x/x&hl=fr_FR&fs=1&"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/x&hl=fr_FR&fs=1&" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="270" height="166"></embed></object>
<br />
<br />
<?php
}
else
{
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" class="TitreBlok"> </td>
</tr>
<tr>
<td height="20" class="TitreBlok"><span class="TitreMenuDroite" ><strong>Mes abonnements</strong></span></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<?php
$select_flux_sql = "
SELECT this.CodeFlux AS CodeFlux, TitreFlux, ajouter.NomFlux AS NomFlux, (
SELECT COUNT( * )
FROM item, ajouter, flux
WHERE flux.CodeFlux = ajouter.CodeFlux
AND item.CodeFlux = flux.CodeFlux
AND flux.CodeFlux = this.CodeFlux
AND item.CodeItem NOT
IN (
SELECT CodeItem
FROM afficher
WHERE CodeMembre = '$CodeMembre'
)
) AS NewItem
FROM ajouter, flux AS this
WHERE ajouter.CodeMembre = '$CodeMembre'
AND ajouter.CodeFlux = this.CodeFlux
ORDER BY NomFlux
";
$select_flux = mysql_query($select_flux_sql) or die (mysql_error());
if (mysql_num_rows($select_flux) == 0)
{
//echo "Aucune ligne trouvee, rien a afficher";
}
else
{
while ($rows = mysql_fetch_assoc($select_flux))
{
$R_CodeFlux = $rows["CodeFlux"];
$R_TitreSite = $rows["TitreFlux"];
$R_FaviconSite = $rows["FaviconSite"];
$R_AdresseSite = $rows["AdresseSite"];
$R_NewItem = $rows["NewItem"];
$R_NomFlux = $rows["NomFlux"];
if ($R_NomFlux)
{
$R_TitreSite = $R_NomFlux;
}
?>
<tr onmouseover="this.style.backgroundColor='#F4F4EE'" onmouseout="this.style.backgroundColor='#FBFBFB'" >
<td height="30" align="left"><a class="LienMenuDroite" href="start.php?CodeFlux=<?php echo "$R_CodeFlux&kw=".str_replace(" ", "-", str_replace("&", "-", strtolower(SupprimeHTML(TitreSite($R_CodeFlux, 1)))))."-".str_replace(" ", "-", str_replace("&", "-", strtolower(SupprimeHTML(TitreSite($R_CodeFlux, 2))))).""; ?>"><?php echo CoupeurTexte ("$R_TitreSite", 40); ?></a></td>
<td width="25" align="center"><strong><a class="LienDetails" href="start.php?<?php echo "CodeFlux=$R_CodeFlux&OnlyNews=1"; ?>">
<?php if ($R_NewItem > 0) { echo "<span id = 'Flux$R_CodeFlux'>$R_NewItem</span>"; } ?>
</a></strong></td>
</tr>
<tr>
<td height="5" background="img/separator.png" colspan="2"></td>
</tr>
<?php
}
mysql_free_result($select_flux);
}
if (NbAbonnement($CodeMembre) == 0)
{
?>
<tr>
<td height="30" colspan="2" align="center">Vous n'avez aucun abonnement.</td>
</tr>
<?php
}
else
{
?>
<tr>
<td height="30" colspan="2" align="right"><a class="LienGestion" href="gestion_abonnement.php">Gérer mes abonnements</a></td>
</tr>
<?php
}
?>
<tr>
<td style="height:100%" height="30" colspan="2" align="right"> </td>
</tr>
</table>
<?php
}
?>
<br />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" colspan="2" class="TitreMenuDroite"><strong>x</strong></td>
</tr>
<tr>
<td width="40"><img src="../img/mobile.jpg" width="40" height="40" /></td>
<td align="right" style="text-align:justify;">x</td>
</tr>
</table>
<br />
<br /> |
5s d'attente sur mes pages PHP
Répondre avec citation
Envoyé par RunCodePhp
Partager