¨PHP: Sélectionner les données d’une base de données selon le choix d’un formulaire

Author:

 formulaire, base de données
Download

<?php
if (isset($_POST['submit']))
{
      $matricule = $_POST['id'];
      mysql_connect("localhostt","root","motdepasse");
      mysql_select_db("BD_Etudiants");
 
      $requete = "SELECT nom, année ,note FROM Etudiants WHERE Matricule='$matricule'";
      $resultat = mysql_query($requete);
      list($nom,$annee,$note) = mysql_fetch_row($resultat);
}
 
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<select name="id">
<option name="">Chosissez votre matricule:</option>
<option name="1">0012541</option>
<option name="2">2214253</option>
<option name="3">3487520</option>
</select>
<input type="submit" name="submit" value="Voir ma note" />
</form>

Leave a Reply

Your email address will not be published. Required fields are marked *


5 + = twelve