@mysql_connect("localhost","macadam",".macadam.") or die("Echec de connexion au serveur");
mysql_query("use JRN");
$query="select * from Inscriptions order by NOM";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
echo "
Inscriptions pour la journée Rennes-Nantes (".$numrows." inscrits)\n";
echo "
\n";
echo " | NOM | Prénom | Email | Buffet |
\n";
$type="pair";
for ($i=0;$i<$numrows;$i++)
{if ($type=="impair")
$type="pair";
else
$type="impair";
$nom = trim(mysql_result($result,$i,"NOM"));
$prenom = trim(mysql_result($result,$i,"PRENOM"));
$email = trim(mysql_result($result,$i,"EMAIL"));
$buffet = trim(mysql_result($result,$i,"BUFFET"));
echo " \n";
echo " | ".$nom." | \n";
echo " ".$prenom." | \n";
echo " ".$email." | \n";
echo " ".$buffet." | \n";
echo "
\n";
}
echo "
\n";
echo "
\n";
// Date de mise a jour
$res = mysql_query("SHOW TABLE STATUS");
$row = mysql_fetch_assoc($res);
$date = $row['Update_time'];
$a = substr($date, 0, 4);
$m = substr($date, 5, 2);
$j = substr($date, 8, 2);
$h = substr($date, 11, 2);
$min = substr($date, 14, 2);
$s = substr($date, 17, 2);
$datefr=$j.'/'.$m.'/'.$a;
$heurefr=$h.':'.$min;
echo "
Dernière modification de la base le ".$datefr." à ".$heurefr.".
";
?>
Retour à la page d'accueil