<?php # coding:utf-8
-include_once("traitement_pre_affichage.php");
+include_once("php/traitement_pre_affichage.php");
-$participants = mysql_query("
+$participants = pg_query("
SELECT id, pseudo, nom, prenom, clan_nom, clan_tag, remarques
FROM participants
- ORDER by clan_nom, clan_tag, pseudo
+ ORDER by clan_nom NULLS FIRST, clan_tag NULLS FIRST, pseudo
");
-$periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");
+$periodes = pg_query("SELECT nom_abrege FROM periodes ORDER BY id");
$debut_table = '
<tr>
<th>pseudo</th>
<th>nom</th>
<th>prénom</th>';
$nb_periode = 0;
-while($periode = mysql_fetch_object($periodes))
+while($periode = pg_fetch_object($periodes))
{
$debut_table .= '<th>'.$periode->nom_abrege.'</th>';
$nb_periode++;
$debut_table .= '<th>remarques</th>
</tr>';
-$clan_courant = null;
+$clan_courant = "PHP c'est du CACA";
echo '<table class="inscrits">';
-while($participant = mysql_fetch_object($participants))
+while($participant = pg_fetch_object($participants))
{
if ($clan_courant !== $participant->clan_nom)
{
$clan_courant = $participant->clan_nom;
}
- $participations = mysql_query("
+ $participations = pg_query_params("
SELECT periodes.nom, participations.participant_id FROM periodes
- LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = ".$participant->id."
+ LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = $1
ORDER BY id
- ");
+ ", array($participant->id));
echo '<tr>';
echo '<td>', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), '</td>';
echo '<td>', traitement_pre_affichage($participant->nom), '</td>';
echo '<td>', traitement_pre_affichage($participant->prenom), '</td>';
- while ($participation = mysql_fetch_object($participations))
- echo '<td '.($participation->participant_id == $participant->id ? 'class="participe"' : '').'></td>';
+ while ($participation = pg_fetch_object($participations))
+ echo '<td '.($participation->participant_id == $participant->id ? 'class="participe"' : '').'></td>';
echo '<td>', traitement_pre_affichage($participant->remarques), '</td>';
echo '</tr>';