<?
require ‘pages/connexion/var.php’;
require ‘pages/connexion/parametres.php’;
function addZero($number) {
$tmp=””;
for ($i=0;$i<(4-strlen($number));$i++) $tmp.=”0″;
return $tmp.$number;
}
if(isset($_POST[‘etab’] )) $etab=$_POST[‘etab’];
if(isset($_POST[‘nom’] )) $nom=$_POST[‘nom’];
if(isset($_POST[‘sexe’] )) $sexe=$_POST[‘sexe’];
if(isset($_POST[‘score’] )) $score=$_POST[‘score’];
if(isset($_POST[‘etabli’] )) $etabli=$_POST[‘etabli’];
@mysql_connect($host,$user,$pass)
or die(“Impossible de se connecter”);
$select_base=@mysql_select_db(“$db”)
or die(“Impossible de se connecter”);
if (!$select_base)
echo “Mauvaise configuration!!!
Vérifiez que votre login et mot de passe sont bien saisi pour la connexion
à la base $db“;
else echo “”;
if (!$etab) $etab = ‘%%’;
if (!$nom) $nom = ‘%%’;
if (!$sexe) $sexe = ‘%%’;
if (!$etabli) $etabli = ‘oui’;
if (!$score) $score = ‘0 AND data_004 <=20’; $query=mysql_query(“SELECT * FROM asee_eleve, asee_eva WHERE id_eleve=id_asee AND nom_etab LIKE ‘”.$etab.”‘ AND nom_eleve LIKE ‘”.$nom.”%’ AND sexe LIKE ‘”.$sexe.”‘ AND etab = ‘”.$etabli.”‘ AND num_eva = ’36’ AND data_004 >= “.$score.”
AND data_004 != ‘0.0’
AND dnb_abs =’non’
ORDER by data_004 DESC
“);
?>
|
N°-
|
Nom
|
Prénom
|
Maths.
(/20) |
Français
(/20) |
Hist-géo
(/20) |
Total
(/20) |
<? $i=1; $moy_1=0; $moy_2=0; $moy_3=0; $moy_4=0; ?>
<? while($valeurlud = @mysql_fetch_array($query)){?>
|
Trier
|
Trier
|
Trier
|
Trier
|
Trier
|
Trier
|
|
|---|---|---|---|---|---|---|
|
–
|
<? echo $valeurlud[“nom_eleve”]; ?>
 .gif”> |
<acronym “title=’‘>
 |
<? $i=$i+1; $moy_1=$moy_1+($valeurlud[“data_001”]); $moyenne_1 = round($moy_1)/($i-1); $moyenne_aff_1 = number_format($moyenne_1, 1); $moy_2=$moy_2+($valeurlud[“data_002”]); $moyenne_2 = round($moy_2)/($i-1); $moyenne_aff_2 = number_format($moyenne_2, 1); $moy_3=$moy_3+($valeurlud[“data_003”]); $moyenne_3 = round($moy_3)/($i-1); $moyenne_aff_3 = number_format($moyenne_3, 1); $moy_4=$moy_4+($valeurlud[“data_004”]); $moyenne_4 = round($moy_4)/($i-1); $moyenne_aff_4 = number_format($moyenne_4, 1); ?> |
|
Sélection
|
(Moyenne)
|
<? $def_1= str_replace(“.”,”,”,$moyenne_aff_1); $num=strlen($def_1); if ($num==4){echo $def_1;} else {echo “0”.$def_1;}?>
|
<? $def_2= str_replace(“.”,”,”,$moyenne_aff_2); $num=strlen($def_2); if ($num==4){echo $def_2;} else {echo “0”.$def_2;}?>
|
<? $def_3= str_replace(“.”,”,”,$moyenne_aff_3); $num=strlen($def_3); if ($num==4){echo $def_3;} else {echo “0”.$def_3;}?>
|
<? $def_4= str_replace(“.”,”,”,$moyenne_aff_4); $num=strlen($def_4); if ($num==4){echo $def_4;} else {echo “0”.$def_4;}?>
|
