j'arrive pas a faire le classement dans les matière de cette classe
<?php
include('body/header.php');
include('body/menu.php');
echo'</br>';
//if(isset($_GET['id'])) $id = urldecode($_GET['id']); echo $id;
//if(isset($_GET['mat'])) $mat = urldecode($_GET['mat']);
if(isset($_GET['desgn'])) $desgn = urldecode($_GET['desgn']); //permet de recuperer l'id de la classe;
$sql0 = "SELECT * FROM inscription ";
// on envoie la requête
$req0 = mysql_query($sql0) or die('Erreur SQL !<br>'.$sql0.'<br>'.mysql_error());
$res0 = mysql_num_rows($req0);
$l = mysql_fetch_assoc($req0); // echo $l['id'];
//recuperetion des dates du trimestre
$q_trim = mysql_query("SELECT id,trim,debut,fin,code FROM trimestres ") or die('NO');
$liste = mysql_fetch_assoc($q_trim);
$debut = $liste["debut"]; //echo $debut;
$fin = $liste["fin"];// echo $fin;
//mois debut trim
$debut = explode("/",$debut); //echo $date;
// $date_ann = $date[2]; //echo $date_diff ;
$debut = $debut[1];// echo $debut ;
//mois fin trim
$fin = explode("/",$fin); //echo $date;
// $date_ann = $date[2]; //echo $date_diff ;
$fin = $fin[1]; //echo $fin ;
//recuperation du groupe
$sql_m0 = ('SELECT groupe FROM matieres GROUP BY groupe ');
$q_m0 = mysql_query($sql_m0) or die('Erreur SQL !<br>'.$sql_m0.'<br>'.mysql_error());
$n_m0 = mysql_num_rows($q_m0);
while ($r_m0 = mysql_fetch_assoc($q_m0)) {
//recuperation des matières
$sql_m = ('SELECT * FROM matieres WHERE groupe = "'.$r_m0['groupe'].'" ');
$q_m = mysql_query($sql_m) or die('Erreur SQL !<br>'.$sql_m.'<br>'.mysql_error());
$n_m = mysql_num_rows($q_m);
while ($r_m=mysql_fetch_assoc($q_m)) {
//partie maoyenne
$req = mysql_query("SELECT a.id,a.id_elv,a.note,SUM(a.note) AS NOTE,a.code,a.pseudo,a.obs,a.date_enrg,a.eval,b.id_elv,b.eval,c.matiere,c.id_elv,SUM(d.coeff) AS COEFF,d.id FROM notes a, tb_type_evaluation b , tb_matieres c,tb_coeff d WHERE a.eval = '".$desgn."' AND a.id = b.id AND a.id = c.id AND a.id = d.id AND c.matiere = '".$r_m['matiere']."' AND (MONTH(a.date_enrg) BETWEEN '".$debut."' AND '".$fin."') ") or die('il y a un blem ici');
$rr = mysql_fetch_assoc($req);
//calcul de moyenne
$MOY0 = $rr['NOTE']/$rr['COEFF'];
$MOY = number_format($MOY0, 2, ',', ' ');
//Mise à jour des moyennes dans la base de donnée
//mysql_query("SELECT matieres FROM moyenne WHERE matieres='".$r_m['matiere']."' AND debut='$debut' AND fin ='$fin'");
$reqq = mysql_query("SELECT matieres FROM moyenne WHERE matieres='".$r_m['matiere']."' AND id='".$id."' ");
// on compte le nombre de résultats
$ress = mysql_num_rows($reqq);
if($ress!=0) // l'url existe déjà, on affiche un message d'erreur
{
mysql_query("UPDATE moyenne SET moy = '".$MOY."' WHERE id='".$l['id']."'");
}
else // L'url n'existe pas, on insère les informations du formulaire dans la table
{
//mysql_query("UPDATE membres SET email ="p@pierre.fr" WHERE 'id'=1;");
mysql_query("INSERT INTO moyenne(id,matieres,moy,debut,fin) VALUES('".$l['id']."','".$r_m['matiere']."','".$MOY."','".$debut."','".$fin."')");
}
}
}
?>
$sql="SELECT a.id ,a.id_elv ,a.note ,SUM(a.note) AS NOTE ,a.code ,a.pseudo ,a.obs ,a.date_enrg ,a.eval ,b.id_elv ,b.eval ,c.matiere ,c.id_elv ,SUM(d.coeff) AS COEFF ,d.id ,SUM(a.note)/SUM(d.coeff) as Moyenne FROM notes a , tb_type_evaluation b , tb_matieres c,tb_coeff d WHERE a.eval = '".$desgn."' AND a.id = b.id AND a.id = c.id AND a.id = d.id AND c.matiere = '".$r_m['matiere']."' AND (MONTH(a.date_enrg) BETWEEN '".$debut."' AND '".$fin."') "; $req = mysql_query($sql) or die('il y a un blem ici : ' . $sql);
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question//recuperetion des dates du trimestre
$q_trim = mysql_query("SELECT id,trim,debut,fin,code FROM trimestres ") or die('NO');
while($liste = mysql_fetch_assoc($q_trim)){
echo '<div style="background-color:#F00">'.$liste["trim"].'</div></br></br></br>';
$debut = $liste["debut"]; //echo $debut;
$fin = $liste["fin"];// echo $fin;
//mois debut trim
$debut = explode("/",$debut); //echo $date;
// $date_ann = $date[2]; //echo $date_diff ;
$debut = $debut[1];// echo $debut ;
//mois fin trim
$fin = explode("/",$fin); //echo $date;
// $date_ann = $date[2]; //echo $date_diff ;
$fin = $fin[1]; //echo $fin ;
..........
//recuperation des matières
$sql_m = ('SELECT * FROM matieres ');
$q_m = mysql_query($sql_m) or die('Erreur SQL !<br>'.$sql_m.'<br>'.mysql_error());
$n_m = mysql_num_rows($q_m);
while($r_m=mysql_fetch_assoc($q_m)){
............................
//recuperation des matières
$sql_m = ('SELECT * FROM matieres ');
$q_m = mysql_query($sql_m) or die('Erreur SQL !<br>'.$sql_m.'<br>'.mysql_error());
$n_m = mysql_num_rows($q_m);
while($r_m=mysql_fetch_assoc($q_m)){
//partie maoyenne
echo $r_m['matiere'];
$sql="SELECT a.id
,a.id_elv
,a.note
,SUM(a.note) AS NOTE
,a.code
,a.pseudo
,a.obs
,a.date_enrg
,a.eval
,b.id_elv
,b.eval
,c.matiere
,c.id_elv
,SUM(d.coeff) AS COEFF
,d.id_elv
,SUM(a.note)/SUM(d.coeff) as Moyenne
FROM notes a
, tb_type_evaluation b
, tb_matieres c,tb_coeff d
WHERE a.eval = '".$desgn."'
AND a.id_elv = b.id_elv
AND a.id_elv = c.id_elv
AND a.id_elv = d.id_elv
AND c.matiere = '".$r_m['matiere']."'
AND (MONTH(a.date_enrg) BETWEEN '".$debut."' AND '".$fin."')
";
$req = mysql_query($sql) or die('il y a un blem ici : ' . $sql);
//calcul de moyenne
$MOY0 = $rr['Moyenne'];
$MOY = number_format($MOY0, 2, ',', ' ');
?>
<table width="384" height="81" border="0">
<tr>
<td>ID_ELV</td>
<td>MOY</td>
<td>CLASSEMENT</td>
</tr>
<?php while($rr = mysql_fetch_assoc($req)){
$MOY0 = $rr['Moyenne'];
$MOY = number_format($MOY0, 2, ',', ' ');
?>
<tr>
<td><?php echo $rr["id_elv"];?></td>
<td><?php echo $MOY;?></td>
<td><?php echo $rr["id"];?></td>
</tr>
<?php
}
?>
</table>
<?php
}
}
?>
<?php
include('body/header.php');
include('body/menu.php');
echo'</br>';
if(isset($_GET['desgn'])) $desgn = urldecode($_GET['desgn']); //permet de recuperer l'id de la classe;
//recuperetion des dates du trimestre
$q_trim = mysql_query("SELECT id,trim,debut,fin,code FROM trimestres ") or die('NO');
while($liste = mysql_fetch_assoc($q_trim)){
echo '<div style="background-color:#F00">'.$liste["trim"].'</div></br></br></br>';
$debut = $liste["debut"]; //echo $debut;
$fin = $liste["fin"];// echo $fin;
//mois debut trim
$debut = explode("/",$debut); //echo $date;
// $date_ann = $date[2]; //echo $date_diff ;
$debut = $debut[1];// echo $debut ;
//mois fin trim
$fin = explode("/",$fin); //echo $date;
// $date_ann = $date[2]; //echo $date_diff ;
$fin = $fin[1]; //echo $fin ;
//recuperation des matières
$sql_m = ('SELECT * FROM matieres ');
$q_m = mysql_query($sql_m) or die('Erreur SQL !<br>'.$sql_m.'<br>'.mysql_error());
$n_m = mysql_num_rows($q_m);
while($r_m=mysql_fetch_assoc($q_m)){
//partie maoyenne
echo $r_m['matiere'];
$sql="SELECT a.id
,a.id_elv
,a.note
,SUM(a.note) AS NOTE
,a.code
,a.pseudo
,a.obs
,a.date_enrg
,a.eval
,b.id_elv
,b.eval
,c.matiere
,c.id_elv
,SUM(d.coeff) AS COEFF
,d.id_elv
,SUM(a.note)/SUM(d.coeff) as Moyenne
FROM notes a
, tb_type_evaluation b
, tb_matieres c,tb_coeff d
WHERE a.eval = '".$desgn."'
AND a.id_elv = b.id_elv
AND a.id_elv = c.id_elv
AND a.id_elv = d.id_elv
AND c.matiere = '".$r_m['matiere']."'
AND (MONTH(a.date_enrg) BETWEEN '".$debut."' AND '".$fin."')
";
$req = mysql_query($sql) or die('il y a un blem ici : ' . $sql);
//calcul de moyenne
$MOY0 = $rr['Moyenne'];
$MOY = number_format($MOY0, 2, ',', ' ');
?>
<table width="384" height="81" border="0">
<tr>
<td>ID_ELV</td>
<td>MOY</td>
<td>CLASSEMENT</td>
</tr>
<?php while($rr = mysql_fetch_assoc($req)){
$MOY0 = $rr['Moyenne'];
$MOY = number_format($MOY0, 2, ',', ' ');
?>
<tr>
<td><?php echo $rr["id_elv"];?></td>
<td><?php echo $MOY;?></td>
<td><?php echo $rr["id"];?></td>
</tr>
<?php
}
?>
</table>
<?php
}
}
?>