File: /homepages/16/d176908298/htdocs/wsb4118896501-old/pcolmar2/clf.php
<?php
require("./dbparams.php");
import_request_variables('g','p_');
$p_cat = "F";
$link = mysql_connect($hostn, $login, $passw) or die("Impossible de se connecter au serveur sql");
mysql_select_db($dbnam) or die("Erreur de connexion � la base");
$query = "SELECT COUNT(idpcs) as cnt from passages where categ='$p_cat'";
$result = mysql_query($query) or die("Query error: $query");
$cnt = mysql_result($result,0,"cnt");
if ( $cnt > 0 ) {
mysql_free_result($result);
$query = " SELECT MAX(idpcs) as mxp from passages where categ='$p_cat'";
$result = mysql_query($query) or die("Query error: $query");
$pmx = mysql_result($result,0,"mxp");
}
else { $pmx = -1; };
mysql_free_result($result);
$query = "SELECT pcs,hpcs.idpcs from hpcs inner join pcs on hpcs.idpcs=pcs.idpcs where categ='$p_cat' and pcs.idpcs<=$pmx order by pcs.idpcs desc";
$result = mysql_query($query) or die("Query error: $query");
$num = mysql_numrows($result);
$i=0;
$s=0;
echo "<html> <header> <link rel='stylesheet' type='text/css' href='colmar.css'/> </head>";
echo "<body><table>";
if ( $cnt == 0) { echo "<TR><TD> Aucun pointage effectu� </TD></TR>"; };
while ($i<$num) {
$pcs = mysql_result($result,$i,"pcs");
$idp = mysql_result($result,$i,"idpcs");
echo "<TR><TD colspan='5'>$pcs</TD></TR>";
$query2="SELECT place,nom,heure,total,ecart from passages inner join participants on passages.dossard=participants.dossard where idpcs=$idp and categ='$p_cat' order by place";
$result2 = mysql_query($query2) or die("Query error: $query2");
$num2 = mysql_numrows($result2);
$j=0;
while ($j<$num2) {
$nom = mysql_result($result2,$j,"nom");
$rng = mysql_result($result2,$j,"place");
$hor = mysql_result($result2,$j,"heure");
$tot = mysql_result($result2,$j,"total");
$dlt = mysql_result($result2,$j,"ecart");
echo "<TR><TD>$rng</TD>";
echo "<TD>$nom</TD>";
echo "<TD>".strftime("%H h %M",strtotime($hor))."</TD>";
echo "<TD>, ".str_replace(":"," h ",substr($tot,0,5))."</TD>";
echo "<TD>� ".strftime("%H h %M",strtotime($dlt))."</TD></TR>";
$j++;
};
mysql_free_result($result2);
fwrite($fichier, "<TR><TD colspan='4'> </TD></TR>");
$i++;
}
mysql_free_result($result);
mysql_close($link);
echo "</TABLE></BODY></HTML>";
?>