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 112 113 114 115 116 117 118 119 120 121 122 123 124
| <?php
$liendb = mysql_connect("localhost", "root","");
mysql_select_db ("mabdd");
if ($_REQUEST['action']=="maj")
{
if (empty($_REQUEST['nom']) || empty($_REQUEST['prenom']) ||
empty($_REQUEST['adresse']) ||
empty($_REQUEST['ville']) ||
empty($_REQUEST['codepostal']) ||
empty($_REQUEST['pays']) ||
empty($_REQUEST['naissance']) ||
empty($_REQUEST['telephone']) ||
empty($_REQUEST['lv']))
die("ERREUR : tous les champs doivent être remplis.");
if ($_REQUEST['sexe']!="masculin" && $_REQUEST['sexe']!="feminin")
die("ERREUR : choissisez votre sexe.");
$reg_email = "^[[:alnum:]]+@[[:alpha:]]+\.[[:alpha:]]{2,3}$";
if (eregi($reg_email,$_REQUEST['email']) == 0)
die("ERREUR : adresse mail non valide");
if ($_REQUEST['taille']<=100 || $_REQUEST['taille']>=220)
die("ERREUR : la taille n'est pas valide.");
$sql = "UPDATE eleve SET nom = '".$_REQUEST['nom']."',".
"prenom = '".$_REQUEST['prenom']."',".
"adresse = '".$_REQUEST['adresse']."',".
"ville = '".$_REQUEST['ville']."',".
"cp = '".$_REQUEST['cp']."',".
"pays = '".$_REQUEST['pays']."',".
"sexe = '".$_REQUEST['sexe']."',".
"naissance = '".$_REQUEST['naissance']."',".
"taille = '".$_REQUEST['taille']."',".
"email = '".$_REQUEST['email']."',".
"telephone = '".$_REQUEST['telephone']."',".
"lv = '".$_REQUEST['lv']."',".
" WHERE ideleve = '".$_REQUEST['id']."'";
mysql_query ($sql);
}
elseif ($_REQUEST['action']=="suppr" && $_REQUEST['id']>=1)
{
$sql = "DELETE FROM eleve WHERE ideleve='".$_REQUEST['id']."'";
mysql_query ($sql);
header("Location: <a href="http://localhost/admin.php" target="_blank">http://localhost/admin.php</a>");
}
echo "<html>";
echo "<head>";
echo "<title>Admin Ecole</title>";
echo "</head>";
echo "<body>";
echo "<h1>admin - école</h1>";
echo "<p align=left> :: fiche d'élève [".$_REQUEST['id']."]</p>";
$sql = "SELECT * FROM eleve WHERE ideleve = '".$_REQUEST['id']."'";
$resultat = mysql_query ($sql);
$eleve = mysql_fetch_array ($resultat);
?>
<form action="eleve_edite.php" method="post">
<input type="hidden" name="enregistre" value="oui"/>
<input type="hidden" name="id" value="<?php echo $_REQUEST['id']; ?>" />
<table>
<tr>
<td>nom</td>
<td><input type="text" name="nom" value="<?php echo $eleve['nom']; ?>" /></td>
</tr>
<tr>
<td>prénom</td>
<td><input type="text" name="prenom" value="<?php echo $eleve['prenom']; ?>" /></td>
</tr>
<tr>
<td>adresse</td>
<td><textarea name="adresse" ><?php echo $eleve['adresse']; ?></textarea></td>
</tr>
<tr>
<td>ville</td>
<td><input type="text" name="vile" value="<?php echo $eleve['ville']; ?>" /></td>
</tr>
<tr>
<td>code postal</td>
<td><input type="text" name="codepostal" value="<?php echo $eleve['cp']; ?>" /></td>
</tr>
<tr>
<td>pays</td>
<td><input type="text" name="pays" value="<?php echo $eleve['pays']; ?>" /></td>
</tr>
<tr>
<td>sexe</td>
<td>M <input type="radio" name="sexe" value="masculin" <?php if ($eleve['sexe'] == "masculin") echo "CHECKED";?>> -
<td>F <input type="radio" name="sexe" value="feminin" <?php if ($eleve['sexe'] == "feminin") echo "CHECKED";?>></td>
</tr>
<tr>
<td>date de naissance</td>
<td><input type="text" name="naissance" value="<?php echo $eleve['naissance']; ?>" /></td>
</tr>
<tr>
<td>taille</td>
<td><input type="text" name="taille" value="<?php echo $eleve['taille']; ?>" /></td>
</tr>
<tr>
<td>email</td>
<td><input type="text" name="email" value="<?php echo $eleve['email']; ?>" /></td>
</tr>
<tr>
<td>téléphone</td>
<td><input type="text" name="telephone" value="<?php echo $eleve['telephone']; ?>" /></td>
</tr>
<tr>
<td>langue vivante</td>
<td><select name="lv">
<option value="anglais"> anglais </option>
<option value="espagnol" <?php if ($eleve['lv'] == "espagnol")
echo "SELECTED"; ?>> espagnol </option>
<option value="allemand" <?php if ($eleve['lv'] == "allemand")
echo "SELECTED"; ?>> allemand </option>
</select>
</td>
</tr>
</table>
<br/>
<select name="action">
<option value="maj"> Enregistrer la fiche </option>
<option value="suppr"> Supprimer la fiche </option>
</select>
<input type="submit" value="valider">
</form>
</body>
</html>
<?php mysql_close($liendb); ?> |
Partager