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
| if(isset($_POST['Modifier']))
{
mysql_connect("localhost","root","");
mysql_select_db("cour");
$id=$_GET['id'];
echo $id;
$test=mysql_query('select count(*) as nombre from user WHERE id=\'' . $_GET['id'] . '\'') or die (mysql_error());//Vérifier le nbr d'entrées
$res=mysql_fetch_assoc($test);
if($res['nombre'] != 0) // Je vérifie si la BD est vide avant d'afficher
{
$Nom=mysql_real_escape_string(htmlspecialchars($_POST['Nom']));
$Prenom=mysql_real_escape_string(htmlspecialchars($_POST['Prenom']));
$Date=mysql_real_escape_string(htmlspecialchars($_POST['Date']));
$Tel=mysql_real_escape_string(htmlspecialchars($_POST['Tel']));
$Mail=mysql_real_escape_string(htmlspecialchars($_POST['Mail']));
$Sexe=mysql_real_escape_string(htmlspecialchars($_POST['Sexe']));
mysql_query("UPDATE user SET Nom='" .$Nom. "',Prenom='" .$Prenom. "',Mail='" .$Mail. "',Sexe='" .$Sexe. "',Date='" .$Date. "',Tel='" .$Tel. "' where id='" . $id . "'") or die(mysql_error());
echo $id;
echo "<script language=javascript>alert('Utilisateur Modifié.')</script>";
}
else
{
echo "<script language=javascript>alert('Aucun utilisateur n\'est enregistré !')</script>";
}
} |