Merci bcp Monsieur KILIAN, je vous en suis tres reconnaissant.
voici mon code:
C’est le formulaire que je selectionne la classe ainsi il m’affiche tt les etudiants(nom,prenom,numcarte)et regenere le checkbox .
********************************************************************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.Style1 {
font-size: 18px;
font-weight: bold;
}
body {
background-color: #669966;
}
.Style2 {color: #FFFFFF}
-->
</style>
</head>
<body>
<form action="classeaff.php" method="post" name="form" id="form">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="404" border="1" align="center" cellpadding="8" bordercolor="#663366">
<tr>
<td width="186"> </td>
<td width="174"> </td>
</tr>
<tr>
<td><div align="center" class="Style2"><span class="Style1">Choisissez la classe </span></div></td>
<td><div align="center">
<select name="select">
<option value="gi1">Gi1</option>
<option value="gi2">Gi2</option>
<option value="gi3">Gi3</option>
<option value="gi4">Gi4</option>
</select>
</div></td>
</tr>
<tr>
<td>
<div align="center">
<input name="cmd_val" type="submit" id="cmd_val" value="Valider">
</div></td>
<td><div align="center">
<input type="reset" name="Submit2" value="Annuler">
</div></td>
</tr>
</table>
</form>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>
C’est le form qui affiche les resultat de la precedente
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
//include("../modeles/entete.php");
//Connexion à MySQL
include "open.php";
if ($_POST['cmd_val']){
$menselect = $_POST['select'];
}
//Requete pour afficher les utilisateurs enrégistrer dans la base de données
$rq="select num_carte_etud, nom, prenom, filiere from etudiant where filiere='$menselect'
order by num_carte_etud ";
//fardi $rq="select num_Abs, date_Abs, h_debut, h_fin, nb_abs, num_carte_etud, filiere from absence where filiere='$menselect'
//fardi order by num_Abs ";
//Envoie de la requete au serveur MySQL
$resultat=mysql_query($rq) or die("Une erreur systeme s'est glissée: ".mysql_error());
//if ($resultat=true) { echo "Bien"; } else { echo "Soucis au niveau du serveur"; }
//Derouler la boucle while pour afficher les résultats de la requête
$nb=mysql_num_rows($resultat);
//if ($resultat) 1ere methode ou
if ($nb>0)
echo "<h2 align='center'><font color=blue>Actuellement vous vous êtes absentéz pendant $nb jours(s) </font></h2>";
{ echo "<table align='center' border=1 width=100%>
<tr>
<th align='center'><font color=black> Carte scolaire</th><th align='center'><font color=black>Nom</font></th>
<th align='center'><font color=black> Prénom</th><th align='center'><font color=black>Filiére</font></th>
</tr>"; { ?>
<form name="form1" method="post" action="classetrait.php">
<? }
while($lignes=mysql_fetch_array($resultat,MYSQL_NUM)) // ou bien: while ($lignes=mysql_fetch_rows($resultat))
{
echo "<tr><td>$lignes[0]</td> <td>$lignes[1]</td> <td>$lignes[2]</td> <td>$lignes[3]</td> <td><input type='checkbox' name='checkbox' value='$lignes[0]'></td></tr>";
}
echo "</table>";
//2eme partie
//if (isset('checkbox'))
?>
<table width="518" border="1" align="center" cellpadding="8">
<tr>
<td width="299"><input name="imageField2" type="image" src="maison.gif" align="middle" width="103" height="60" border="0"></td>
<td width="175"><input name="imageField" type="image" src="telesurveillance_ecran.jpg" align="right" width="170" height="133" border="0"></td>
</tr>
<tr>
<td><span class="Style1">Date de l'abscence : </span></td>
<td><input name="t_date" type="text" id="t_date" value="<? echo 'Le ' . date ('d - m - Y'); ?>"></td>
</tr>
<tr>
<td><span class="Style1">Heure début :</span></td>
<td><input name="hr_debut" type="text" id="hr_debut"></td>
</tr>
<tr>
<td><span class="Style1">Heure fin : </span></td>
<td><input name="hr_fin" type="text" id="hr_fin"></td>
</tr>
<tr>
<td>
<div align="left"><span class="Style1">Numero de la carte scolaire : </span> </div></td>
<td>
<div align="left"> </div></td>
</tr>
<tr>
<td>
<div align="center">
<input name="cmd_enreg" type="submit" id="cmd_enreg" value="Enregistrer">
</div></td>
<td><div align="center">
<input name="t_numcarte" type="text" value=007 >
<input type="reset" name="Submit" value="Annulerr">
</div></td>
</tr>
</table>
</form>
<?
//echo "</form>";
mysql_free_result($resultat);
//mysql_close($cnx);
}
echo"<p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p>";
echo"<p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p>";
echo"<p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p><p>";
?>
<p align="center" class="Style1"><a href="index.htm">Retoure à l'accueil </a></p>
</body>
</html>
</body>
</html>
------------------------------------------------------------------------------
Et enfin c’est le form de traitement
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
//include "head.php";
include "open.php";
//if ($_POST['cmd_rech']=='Rechercher')
// { #1
//if (isset($_POST['checkbox'])){
$v0 = $_POST['t_date'];
$v1 = $_POST['hr_debut'];
$v2 = $_POST['hr_fin'];
$v3 = $v2-$v1;
$v4 = $_POST['checkbox'];
$v5 = $_POST['t_numcarte'];
while(isset($_POST['checkbox'])){
$req = "INSERT INTO `absence`VALUES ('','$v0','$v1','$v2','$v3','$v4','$v5')";
$res = mysql_query($req) or die ("Transfert non efféctuer");
//include "paiement.php";
}
?>
</body>
</html>
------------------BDD--------------------
-- Structure de la table `etudiant`
--
CREATE TABLE `etudiant` (
`num_carte_etud` varchar(255) default NULL,
`nom` varchar(255) default NULL,
`prenom` varchar(255) default NULL,
`date_naiss` varchar(255) default NULL,
`sex` varchar(60) default NULL,
`adresse` varchar(255) default NULL,
`tel` int(12) default NULL,
`mail` varchar(255) default NULL,
`filiere` varchar(255) default NULL,
`code_tuteur` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `etudiant`
--
INSERT INTO `etudiant` VALUES ('001', 'moufouti', 'ali', '12', 'Masculin', 'moscou', 65647896, 'moscou^hotmail.com', 'gi1', '22236');
INSERT INTO `etudiant` VALUES ('011', 'aa', 'bb', ' 12-02-1896', 'Masculin', 'qertret', 1444444444, 'mal@yahoo.fr', 'gi1', 'noeop@yahoo.fr');
INSERT INTO `etudiant` VALUES ('012', 'lll', 'mmmm', '12-04-18957', '', 'ttttttttttttttttt', 2147483647, 'maot@yahoo.fr', 'gi1', 'mppro@yahoo.fr');
INSERT INTO `etudiant` VALUES ('012', 'lll', 'mmmm', '12-04-18957', 'Feminin', 'ttttttttttttttttt', 2147483647, 'maot@yahoo.fr', 'gi1', 'mppro@yahoo.fr');
INSERT INTO `etudiant` VALUES ('013', ' poi', 'poi', '17-08-1996', 'Masculin', 'ggggggggggg', 1457896, 'lkflsdr@hotmail.com', 'gi1', 'hot@heoit.fr');
INSERT INTO `etudiant` VALUES ('014', 'kassavoubou', 'presid', '12-03-1897', 'Feminin', 'ddddd', 123857, 'maoh^hotmcom', 'gi1', 'mjdf@yahoofr');
-- --------------------------------------------------------
-- Structure de la table `absence`
--
CREATE TABLE `absence` (
`num_Abs` int(11) NOT NULL auto_increment,
`date_Abs` varchar(100) default NULL,
`h_debut` int(3) default NULL,
`h_fin` int(3) NOT NULL default '0',
`nb_abs` int(3) default NULL,
`num_carte_etud` varchar(50) default NULL,
`filiere` varchar(255) NOT NULL default '',
KEY `Num_Abs` (`num_Abs`),
KEY `Num_Abs_2` (`num_Abs`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=60518 ;
Base de données php mysql
