<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body>

<?php 

	if(isset($_GET['id'])){
			$id=((int)$_GET['id']);

			try{
$conn = new PDO("mysql:host=localhost;dbname=caen2","root","");

	}catch(exception $e){

		echo $e->getMessege();
	}

			$q="select * from utilisateur where id_utilisateur=$id";
		$query=$conn->query($q);


		while ($result=$query->fetch()){

echo"
	<center><h2>**** modification du page ****</h2></center>			
	<center>
	<form method='post' action='mo.php'>	
	
<input value='".$id."' type='hidden' name='id'><br><br>		

<label>nom</label><input value='".$result['nom_utilisateur']."' type='text' name='n'><br><br>
<label>password </label><input value='".$result['password_utilisateur']."' type='text' name='p'><br><br>
<label>email </label><input value='".$result['email_utilisateur']."' type='text' name='e'><br><br>

<input type='submit' name='s' value='modifier'>

</form>
</center>";
  }
}

if(isset($_POST['s'])){         // specialty here i have problem 
				if(isset($_POST['n']) && isset($_POST['p']) && isset($_POST['e'])){
					if(!empty($_POST['n']) && !empty($_POST['p']) && !empty($_POST['e'])){

				 $name=$_POST['n'];
				 $password=$_POST['p'];
				 $email=$_POST['e'];
				 echo $name." ".$password." ";
                 
                 $id=$_POST['id'];
                          

				 try{

					$conn = new PDO("mysql:host=localhost;dbname=caen2","root","");

				}catch(exception $e){

		echo $e->getMessege();
				}

				$req=$conn->prepare("update utilisateur set  						
					nom_utilisateur=:nom,password_utilisateur=:password,email_utilisateur=:email, where id_utilisateur=:id");
		
												
						
				$req->execute(array(
						"nom"=>$name,
						"password"=>$password,
						"email"=>$email,

						"id"=>$id
					));
					   header('location:data.php');

								} } }

?>

 
</body>
</html>

(Added [code]...[/code] tags ~ MOD)

    Should you be checking for $_POST['id'] instead of $_GET['id']?

      You have an sql syntax error in the UPDATE query.

      You need to ALWAYS have error handling for all statements that can fail. The easiest way of adding error handling for database statements (connection, query, prepare, and execute) is to use exceptions and in most cases let php catch and handle the exception, where it will use its' error_reporting, display_errors, and log_errors settings to control what happens with the actual error information (database statement errors will get displayed/logged the same as php errors.) The exception to this rule is when inserting/updating duplicate user submitted data. In this case, this is a recoverable error, that your code needs to detect and report back to the user so that they can enter different value(s) and resubmit the data.

      For the PDO extension, the connection always uses exceptions. To enable exceptions for the rest of the PDO statements, set the error mode to exceptions when you make the connection. You can either supply an array of options in the connection statement or call the ->setAttribute() method after making the connection.

      You should also set emulated prepared queries to false, and set the default fetch mode to assoc.

        Write a Reply...