1 |
aurelien |
1 |
<?
|
|
|
2 |
|
|
|
3 |
function afficherErreurs($tab_erreurs) {
|
|
|
4 |
if (sizeof($tab_erreurs)>0) {
|
|
|
5 |
echo "<div class='erreurs'>";
|
|
|
6 |
foreach ($tab_erreurs as $err)
|
|
|
7 |
echo $err."<br>";
|
|
|
8 |
echo "</div><br>";
|
|
|
9 |
}
|
|
|
10 |
}
|
|
|
11 |
|
|
|
12 |
include("connect.php");
|
|
|
13 |
|
|
|
14 |
/*** Liste des participants***/
|
|
|
15 |
|
|
|
16 |
/*** Requête de sélection pour l'affichage de la bd ***/
|
|
|
17 |
|
|
|
18 |
$req_participants = mysql_query("select count(PARTICIPANT_ID), COMMUNE_LATITUDE, COMMUNE_LONGITUDE, COMMUNE_NOM from PARTICIPANT,COMMUNE".
|
|
|
19 |
" where PARTICIPANT.COMMUNE_ID=COMMUNE.COMMUNE_ID and PARTICIPANT_ADULTE=1".
|
|
|
20 |
" group by COMMUNE.COMMUNE_ID");
|
|
|
21 |
|
|
|
22 |
include ("modules/cartes/local_participants.php") ;
|
|
|
23 |
|
|
|
24 |
?>
|
|
|
25 |
|
|
|
26 |
<center>
|
|
|
27 |
<div id="map" class="carte"></div>
|
|
|
28 |
</center>
|
|
|
29 |
|
|
|
30 |
<?
|
|
|
31 |
/*$req_participants = mysql_query("select PARTICIPANT_ID,PARTICIPANT_ECOLE,PARTICIPANT_PSEUDO,PARTICIPANT_NOM,PARTICIPANT_PRENOM,PARTICIPANT_ADRESSE,COMMUNE_NOM,NIVEAU_NOM,PARTICIPANT_VISIBLE".
|
|
|
32 |
" from COMMUNE, PARTICIPANT left join NIVEAU on PARTICIPANT.NIVEAU_ID=NIVEAU.NIVEAU_ID where PARTICIPANT.COMMUNE_ID=COMMUNE.COMMUNE_ID and PARTICIPANT_VISIBLE=1".
|
|
|
33 |
" order by PARTICIPANT_PSEUDO");
|
|
|
34 |
echo mysql_error();
|
|
|
35 |
?>
|
|
|
36 |
<center>
|
|
|
37 |
<table class="spip">
|
|
|
38 |
<tr class="row_even" style='font-weight: bold; font-size: 11px;'>
|
|
|
39 |
<td>Pseudo</td>
|
|
|
40 |
<td>Nom</td>
|
|
|
41 |
<td>Ecole</td>
|
|
|
42 |
<td>Niveau</td>
|
|
|
43 |
<td>Commune</td>
|
|
|
44 |
<td>Adresse</td>
|
|
|
45 |
</tr>
|
|
|
46 |
<?
|
|
|
47 |
|
|
|
48 |
$styleligne = array("odd","even");
|
|
|
49 |
$l = 0;
|
|
|
50 |
$i=0;
|
|
|
51 |
while ($participant = mysql_fetch_row($req_participants)) {
|
|
|
52 |
echo "<tr class='row_".$styleligne[$l]."'><td>".$participant[2]."</td>
|
|
|
53 |
<td>".$participant[3]." ".$participant[4]."</td>
|
|
|
54 |
<td>".$participant[1]."</td>
|
|
|
55 |
<td>".$participant[7]."</td>
|
|
|
56 |
<td>".$participant[6]."</td>
|
|
|
57 |
<td>".$participant[5]."</td>
|
|
|
58 |
</tr>";
|
|
|
59 |
$l++;
|
|
|
60 |
if ($l==2)
|
|
|
61 |
$l=0;
|
|
|
62 |
}
|
|
|
63 |
?>
|
|
|
64 |
</table>
|
|
|
65 |
</center>
|
|
|
66 |
<? */
|
|
|
67 |
|
|
|
68 |
?>
|