1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
|
<?php
echo "$IdAdmin";
mysql_connect("localhost","root","");
mysql_select_db("Candidat1");
$myquery ="SELECT Candidature.CodeCandidat,Candidature.NomCandidat,Candidature.PrenomCandidat
From Candidature" ;
$rep=mysql_query($myquery);
$Aquery = "SELECT Notepreuve From ReponseCandidat ";
$repA=mysql_query($Aquery);
$Bquery ="SELECT ReponseCandidat1.Notepreuve1 From ReponseCandidat1 ";
$repB=mysql_query($Bquery);
$Cquery="SELECT ReponseCandidat2.Notepreuve2 From ReponseCandidat2 ";
$repC=mysql_query($Cquery);
$Dquery="SELECT ReponseCandidat3.Notepreuve3 From ReponseCandidat3 ";
$repD=mysql_query($Dquery);
$Equery ="SELECT ResultatCandidat.Resultat From ResultatCandidat ";
$repE=mysql_query($Equery);
?>
<div align="center">
<p> </p>
<table width="495" border="2" bgcolor="#407091">
<tr>
<td><div>
<div align="center" class="Style1">Resultat du Test d'évaluation </div>
</div></td>
</tr>
</table>
<table width="689" height="184" border="2">
<tr>
<td width="677"><form id="form1" name="form1" method="post" action="AdminTest.php">
<div align="center"><br />
<table width="632" height="92" border="2">
<tr>
<td height="23"><div><strong>Num</strong></div></td>
<td><div><strong>Nom</strong></div></td>
<td><div><strong>Prenom</strong></div></td>
<td><div><strong>Note en CG</strong></div></td>
<td><div><strong>Note en Reseaux</strong></div></td>
<td><div><strong>Note en BD</strong></div></td>
<td><div><strong>Note en SI</strong></div></td>
<td><div><strong>Resultat Total</strong></div></td>
</tr>
<?php
$Total=80 ;
do { ?>
<tr>
<td><div>
<div align="center"><strong><?php echo $donnee['CodeCandidat'];?></strong></div>
</div></td>
<td><div>
<div align="left"><strong><?php echo $donnee['NomCandidat'];?></strong></div>
</div></td>
<td><div>
<div align="left"><strong><?php echo $donnee['PrenomCandidat'];?></strong></div>
</div></td>
<td><div>
<div align="center"><strong><?php echo $donnee['Notepreuve'];?></strong></div>
</div></td>
<td><div>
<div align="center"><strong><?php echo $donnee['Notepreuve1'];?></strong></div>
</div></td>
<td><div>
<div align="center"><strong><?php echo $donnee['Notepreuve2'];?></strong></div>
</div></td>
<td><div>
<div align="center"><strong><?php echo $donnee['Notepreuve3'];?></strong></div>
</div></td>
<td><div>
<div align="center"><strong><?php echo $donnee['Resultat'];?></strong> Sur <strong><?php echo $Total ;?></strong></div>
</div></td>
</tr>
<?php } while($donnee=mysql_fetch_array($rep,$repA,$repB,$repC,$repD,$repE)); ?>
</table>
<p>
<input type="submit" name="Submit" value="Quitter" />
</p>
</div></form> |
Partager