<?php require_once("dbmysqli.php"); ///////créer le formulaire pour remplir l'entête du bulletin $query="CREATE TABLE IF NOT EXISTS formubulletin( id int NOT NULL AUTO_INCREMENT, direction VARCHAR(150) NOT NULL, colleges VARCHAR(150) NOT NULL, adressecollege VARCHAR(150)NOT NULL, annescolaire1 VARCHAR(150)NOT NULL, annescolaire2 VARCHAR(150)NOT NULL, trimno VARCHAR(150)NOT NULL, PRIMARY KEY(id))"; $result=mysqli_query($link,$query); if ($result){ echo'bon'; mysqli_close($link); } else{ echo'faux'; mysqli_close($link); } ?>
<?php require_once("dbmysqli.php"); if( isset($_POST["valider"])){ $direction =addslashes($_POST['direction']); $colleges = htmlspecialchars($_POST['colleges']); $adressecollege = $_POST['adressecollege']; $contactcollege= $_POST['contactcollege']; $trimno = $_POST['trimno']; $query="INSERT INTO formubulletin(direction,colleges,adressecollege,trimno,contactcollege) VALUES('".$direction."','".$colleges."','".$adressecollege."','".$trimno."','".$contactcollege."')"; $result=mysqli_query($link,$query); if( $result){ echo' <meta charset="UTF-8"> <table border="2" bgcolor="#AFAFAF"> <tr> <td> <p><center>REPUBLIQUE DU BENIN</center></p> <hr align:center; size:2% width="10%" /> <P align="center">'.$direction.'<br><br> <b>'.$colleges.'</b><br><br> '.$adressecollege.'<br>'.$contactcollege.'</p> <center><p><h2>BULLETIN DE NOTES</h2></p></center> <P align="right">Années Scolaire:20....- 20.....</P><br> <h3><p align="center">'.$trimno.'<sup>er</sup> Trimestre</p></h3> </td> </tr> <tr> <td> Nom:..................................Classe:............................. <br><br> Prénoms:..............................Effectif:........................... <div> <label for="Nouveau">Nouveau :</label> <input type="checkbox" id="Nouveau" /> </div> <div> <label for="Doublant">Doublant :</label> <input type="checkbox" id="Doublant" /> </div> </td> </tr> <tr> <td> <table border="1"> <tr> <th>MATIERES</th> <th>Coef</th> <th>Moy.<br>classe.</th> <th>Note.<br>compo.</th> <th>Moy.<br>Trim.</th> <th>Moy<br>Coef</th> <th>Rang</th> <th>Appréciations</th> </tr> <tr> <td>Anglais</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Religion</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Lecture</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Comm.Ecrite</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Hist-Géo</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>S.V. T</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Maths</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Physique</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Economie</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Allemand/Espagnol</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Philosophie</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>E.P.S</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Conduite</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>TOTAL1</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Eco.Fam.Soc</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Informatique</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Musique</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Education Civique</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Dessin</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Mmoy.des epr.Facul</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>TOTAL1et M.E.F</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td>Moy.Générale</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td colspan="8">Plus forte moyenne: Plus faible moyenne:</td> </tr> <tr> <td colspan="4">Moy.1<sup>er</sup>Trim : Rang:</td> <td colspan="2">Decision du conseil</td> <td></td> <td rowspan="7"></td> </tr> <tr> <td colspan="4">Moy.2<sup>er</sup>Trim : Rang:</td> <td colspan="2">Tableau d\'Honneur</td> <td></td> </tr> <tr> <td colspan="4">Moy.3<sup>er</sup>Trim : Rang:</td> <td colspan="2">Avertissement/Travail</td> <td></td> </tr> <tr> <td colspan="4">Moy.Annuelle: Rang:</td> <td colspan="2">Avertissement/Conduite</td> <td></td> </tr> <tr> <td colspan="4">Retards du Trim annuelles:</td> <td colspan="2">Blame</td> <td></td> </tr> <tr> <td colspan="4">Absences du Trim annuelles:</td> <td colspan="2">Renvoi</td> <td></td> </tr> <tr> <td colspan="7">Passe/Rebouble:</td> </tr> <tr> <td colspan="8"> Appréciation/Observation de la Directrice<br><br><br><br> Date:............................. </td> </tr> </table> </table> </td> <table border="1"> <tr> <td> <td> </tr> </table> '; mysqli_close($link); } else{ echo'faux' ; mysqli_close($link); ; } } else{ $content=' <meta charset="UTF-8"> <form name="form1" id="form1" method="post" action="#"/> <label style="display:inline-block; text-align:right; vertical-align:middle; color:#0000FF; width:50%; for="direction">Direction:</label> <input type="text" size="60" name="direction" id="direction"/><br/> <label style="display:inline-block; text-align:right; vertical-align: middle; color:#0000FF;width:50%"for="colleges ">Collège:</label> <input type="text" size="60" name="colleges" id="colleges"/> <br/> <label style="display:inline-block; text-align:right; vertical-align: middle; color:#0000FF;width:50%"for="adressecollege">Adresse du Collège:</label> <input type="text" size="60" name="adressecollege" id="adressecollege" /> <br/> <label style="display:inline-block; text-align:right; vertical-align: middle; color:#0000FF;width:50%"for="trimno">Numéro du trimestre:</label> <input type="text" size="60" name="trimno" id="trimno"/> <br/> <label style="display:inline-block; text-align:right; vertical-align: middle; color:#0000FF;width:50%"for="contactcollege">Contact Du Collège:</label> <input type="text" size="60" name="contactcollege" id="contactcollege"/> <br/> <label style="display:inline-block; text-align:right; vertical-align: middle; color:#0000FF;width:50%"for=""></label> <input type="submit" value="valider" name="valider" id="valider"/> </form> '; print $content; } ?>
EDIT : Ajout des balises de code (la coloration syntaxique).
Explications disponibles ICI Merci d'y penser dans tes prochains messages. |
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question