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
| echo '<br>Visites par nom de domaine<br><br>';
$bdd = pg_query($base, "SELECT domaine, count(domaine) as nb_mail, count(volet) as nb_page
FROM statistique WHERE volet='bdd' and domaine='audeso.org' and to_char(date, 'YYYY-MM') = '".$date_mois."' GROUP BY domaine, volet ");
$carto = pg_query($base, "SELECT domaine, count(domaine) as nb_mail, count(volet) as nb_page
FROM statistique WHERE volet='carto' and domaine='audeso.org' and to_char(date, 'YYYY-MM') = '".$date_mois."' GROUP BY domaine, volet");
$obs = pg_query($base, "SELECT domaine, count(domaine) as nb_mail, count(volet) as nb_page
FROM statistique WHERE volet='obs' and domaine='audeso.org' and to_char(date, 'YYYY-MM') = '".$date_mois."' GROUP BY domaine, volet");
echo "<TABLE width='100%'>";
echo " <tr >
<td class='sup'><h2></h2></td>
<td width='20%' bgcolor='gainsboro' align='center'><h2>Bases de données</h2></td>
<td width='20%' bgcolor='gainsboro' align='center'><h2>Portail carto</h2></td>
<td width='20%' bgcolor='gainsboro' align='center'><h2>Observatoires</h2></td>
</tr>";
while ($data = pg_fetch_assoc($bdd) and $data1= pg_fetch_assoc($carto) and $data2= pg_fetch_assoc($obs)) {
echo "<tr>
<td bgcolor='gainsboro' align='center'><h2>".$data["domaine"]."</h2></td>
<td align='right' width='20%'><h2>".$data["nb_page"]."</h2></td>
<td align='right' width='20%'><h2>".$data1["nb_page"]."</h2></td>
<td align='right' width='20%'><h2>".$data2["nb_page"]."</h2></td>
</tr>";
}
echo "</TABLE>"; |
Partager