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 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111
|
<?PHP
session_start();
/* selection3.php */
if (isset($_POST['modulex'])) $modulex=trim($_POST['modulex']);
else $modulex=0;
if (isset($_POST['moduley'])) $modulNom=trim($_POST['moduley']);
else $modulNom="";
if (isset($_POST['matiere'])) $matiere=trim($_POST['matiere']);
else $matiere=0; /* $IndexM */
if (isset($_POST['niveau'])) $niveauX=trim($_POST['niveau']);
else $niveauX=""; /* $IndexX */
if (isset($_POST['filiere'])) $filiere=trim($_POST['filiere']);
else $filiere=0; /* $IndexF */
$Serveur = "localhost";
$User = "root";
$Mdp = "";
$MaBase = "Ges";
$connexion = mysql_connect($Serveur,$User,$Mdp);
$connexion2 = mysql_select_db($MaBase);
?>
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Strict//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml' xml:lang='en' lang='en'>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>suivi scolaire</title>
<meta name="keywords" content="suivi scolaire" />
<meta name="description" content="suivi scolaire" />
<meta name="robots" content="all" />
<meta http-equiv="content-language" content="fr, en" />
<meta name="expires" content="never" />
<meta name="rating" content="general" />
<meta name="revisit-after" content="30 days" />
<style type="text/css">
* {font-size : 100%;}
html { width:100%;height : 100%;font-size : 100%;
}
BODY {
width:100%;
height : 100%;
background-color : #557bac;
font-family : Verdana, Myranda,Arial, Helvetica, sans-serif;
font-size : 100%;
color : #ffffff;
margin-left : 0;
margin-right : 0;
text-align:center;
}
div.centre {width: 800px;margin : auto;text-align:center;}
a.LesA { font-family : Verdana, Myranda,Arial, Helvetica, sans-serif; font-size: 1.2em; color: #ffffff; text-decoration: none;}
a.LesA:link { }
a.LesA:hover {color : #ff9999; }
</style>
</head>
<body>
<div class="centre" >
<table border=2 >
<tr><td> Nom_eleve </td><td> Matiere </td><td> Module </td><td> Filiere </td><td> La Date </td><td> La Note</tr>
<?PHP
/* ================ matiere =================== */
$result=mysql_query("select * from matiere
WHERE `IndexM` = '$matiere' ");
while ($row=mysql_fetch_array($result))
{
$IndexM= stripslashes($row['IndexM']);
$nommat= stripslashes($row['nommat']);
}
/* ================ filiere =================== */
$result=mysql_query("select * from filiere
WHERE `IndexF` = '$filiere' ");
while ($row=mysql_fetch_array($result))
{
$IndexF= stripslashes($row['IndexF']);
$Nomfili= stripslashes($row['Nomfili']);
}
/* ===On rempli le tableau eleves notes================ */
$result=mysql_query("select * from note
WHERE `Index_matiere` = '$matiere' ");
while ($row=mysql_fetch_array($result))
{
$Index_eleve= stripslashes($row['Index_eleve']);
$note= stripslashes($row['note']);
$datenote= stripslashes($row['datenote']);
$result2=mysql_query("select * from etudiant
WHERE `IndexX` = '$Index_eleve' ");
while ($row2=mysql_fetch_array($result2))
{
$nometu= stripslashes($row2['nometu']);
$niveau= stripslashes($row2['niveau']);
if($niveauX==$niveau )
echo ("<tr><td> ".$nometu." </td><td> ".$nommat." </td><td> ".$modulNom." </td><td> ".$Nomfili." ".$niveau." </td><td> ".$note." ".$datenote." </td><td><input type='text' name='note[]'></td></tr>");
}
}
echo "</table><br/>
<input type='submit' name='btok' value='inserer'/>
<input type='reset' name'vid' value='vider'/>
</form>";
mysql_close();
?>
</body></html> |
Partager