| New file |
|---|
| 0,0 → 1,68 |
|---|
| <? |
| |
| function afficherErreurs($tab_erreurs) { |
| if (sizeof($tab_erreurs)>0) { |
| echo "<div class='erreurs'>"; |
| foreach ($tab_erreurs as $err) |
| echo $err."<br>"; |
| echo "</div><br>"; |
| } |
| } |
| |
| include("connect.php"); |
| |
| /*** Liste des participants***/ |
| |
| /*** Requête de sélection pour l'affichage de la bd ***/ |
| |
| $req_participants = mysql_query("select count(PARTICIPANT_ID), COMMUNE_LATITUDE, COMMUNE_LONGITUDE, COMMUNE_NOM from PARTICIPANT,COMMUNE". |
| " where PARTICIPANT.COMMUNE_ID=COMMUNE.COMMUNE_ID and PARTICIPANT_ADULTE=1". |
| " group by COMMUNE.COMMUNE_ID"); |
| |
| include ("modules/cartes/local_participants.php") ; |
| |
| ?> |
| |
| <center> |
| <div id="map" class="carte"></div> |
| </center> |
| |
| <? |
| /*$req_participants = mysql_query("select PARTICIPANT_ID,PARTICIPANT_ECOLE,PARTICIPANT_PSEUDO,PARTICIPANT_NOM,PARTICIPANT_PRENOM,PARTICIPANT_ADRESSE,COMMUNE_NOM,NIVEAU_NOM,PARTICIPANT_VISIBLE". |
| " from COMMUNE, PARTICIPANT left join NIVEAU on PARTICIPANT.NIVEAU_ID=NIVEAU.NIVEAU_ID where PARTICIPANT.COMMUNE_ID=COMMUNE.COMMUNE_ID and PARTICIPANT_VISIBLE=1". |
| " order by PARTICIPANT_PSEUDO"); |
| echo mysql_error(); |
| ?> |
| <center> |
| <table class="spip"> |
| <tr class="row_even" style='font-weight: bold; font-size: 11px;'> |
| <td>Pseudo</td> |
| <td>Nom</td> |
| <td>Ecole</td> |
| <td>Niveau</td> |
| <td>Commune</td> |
| <td>Adresse</td> |
| </tr> |
| <? |
| |
| $styleligne = array("odd","even"); |
| $l = 0; |
| $i=0; |
| while ($participant = mysql_fetch_row($req_participants)) { |
| echo "<tr class='row_".$styleligne[$l]."'><td>".$participant[2]."</td> |
| <td>".$participant[3]." ".$participant[4]."</td> |
| <td>".$participant[1]."</td> |
| <td>".$participant[7]."</td> |
| <td>".$participant[6]."</td> |
| <td>".$participant[5]."</td> |
| </tr>"; |
| $l++; |
| if ($l==2) |
| $l=0; |
| } |
| ?> |
| </table> |
| </center> |
| <? */ |
| |
| ?> |