Mettre à jour un champ dans une base de données

Eléphanteau du PHP | 24 Messages

23 oct. 2020, 11:53

Bonjour, rien ne se met à jour dans la table alors que je n'ai aucun message d'erreur.

Besoin d'aide, bonne journée.

class/User.php

 class User {
		 
		 private $_user_id;
		 private $_user_name;
		 private $_user_pass;
			
		 public function __construct(array $data) {
 
             $this->setUserId($data['user_id']);
             $this->setUserName($data['user_name']);
			 $this->setUserPass($data['user_pass']);
         }
 
         public function setUserId($user_id) {
			 
			 if((is_int($user_id)) AND ($user_id > 0)) {
 
                 $this->_user_id = $user_id;
             }
         }
 
         public function setUserName($user_name) {
			 
			 if(is_string($user_name)) {
 
                 $this->_user_name = $user_name;
             }
         }
		 
		 public function setUserPass($user_pass) {
			 
			 if(is_string($user_pass)) {
 
                 $this->_user_pass = $user_pass;
             }
         }
 
         public function getUserId() {
 
             return $this->_user_id;
         }
 
         public function getUserName() {
 
             return $this->_user_name;
         }
		 
		 public function getUserPass() {
			 
			 return $this->_user_pass;
	     }
     }
class/userManager.php
class userManager {
		 
		 private $_db;
 
         public function __construct($db) {
 
             $this->setDb($db);
         }
 
         public function setDb(PDO $dbh) {
 
             $this->_db = $dbh;
         }

         public function getUser($user_id = '') {
 
             if(empty($user_id)) {
 
                 $sql = 'SELECT user_id, user_name, user_pass FROM user';
 
                 $stmt = $this->_db->prepare($sql);
             }
             elseif(is_numeric($user_id)) {
 
                 $sql = 'SELECT user_id, user_name, user_pass FROM user WHERE user_id = :user_id';
 
                 $stmt = $this->_db->prepare($sql);
 
                 $stmt->bindParam(':user_id', $user_id);
             }
 
             $stmt->execute();
 
             if($stmt->fetch()) {
				 
                 return true;
             }
             else {    
		     
			     return false;
			 }
         }		 
				 
		 public function updateUser(User $user) {

             $sql = 'UPDATE user SET user_name = :user_name, user_pass = :user_pass, dt_creation = CURTIME() WHERE user_id = :user_id';
			 
			 $user_id = $user->getUserId();
			 $username_form = $user->getUserName();
			 $userpass_form = $user->getUserPass();
 
             $stmt = $this->_db->prepare($sql);
 
             $stmt->bindParam(':user_id', $user_id);
			 $stmt->bindParam(':user_name', $username_form);
			 $stmt->bindParam(':user_pass', $userpass_form);
 
             $stmt->execute();
         }
user/forgot-your-password.php
require('../process/process-forgot-your-password.php');

<!DOCTYPE html>

<html lang="fr">

<head>
     <title>Espace membres - Mot de passe oublié</title>
	 <meta charset="utf-8">
	 <link rel="stylesheet" href="css/style.css">
</head>

<body>
     <div id="wrapper">
	     <main>
		     <header>
			     <h1>Espace membres - Mot de passe oublié</h1>
			 </header>
			 
			 <div>
			     <form action="" method="post" id="update_mdp">
				     <fieldset>
					     <legend>Informations du membre</legend>
						 
						 <p><label for="userpass_new">Nouveau mot de passe</label></p>
						 <p><input type="password" id="userpass_new" name="userpass_new_form"></p>
						 
						 <p>
						     <input type="reset" id="reset" value="Remise à zéro">
							 <input type="submit" id="submit" name="submit_form" value="Mettre à jour">
						 </p>
						 
						 <p><a href="../login.php">Se connecter</a></p>
					 </fieldset>
					 
					 <?php if(isset($message)) echo $message ?>
				 </form>
			 </div>
		 </main>
	 </div>
</body>

</html>
process/process-forgot-your-password.php
require('../includes/inc-connexion.php');
     require('../class/User.php');
	 require('../class/userManager.php');
	 
	 if(isset($_POST['submit_form'])) {
		 
		 $userpass_new_form = $_POST['userpass_new_form'];
		 
		 if(empty($userpass_new_form)) {
			 
			 $message = '<p class="error">Veuillez remplir le champ !</p>';
		 }
		 else {
			 
			 $manager = new userManager($db);
			 
			 $current_user = $manager->getUser();
			 
			 $new_content = array('user_id' => (int) $current_user[0]['user_id'], 'user_name' => $current_user[0]['user_name'],
	                              'user_pass' => $current_user[0]['user_pass'],);
			 
			 $user_to_update = new User($new_content);
			 
			 $user_to_update->setUserPass($userpass_new_form);
	 
	         $manager->updateUser($user_to_update);
		 }
	 }

Avatar du membre
Administrateur PHPfrance
Administrateur PHPfrance | 9782 Messages

23 oct. 2020, 12:15

Bonjour,

Il faut que tu avances davantage dans ton debugage :
- A quel moment ton code ne se comporte pas comme prévu ?
- Active la gestion des erreurs de PDO en WARNING, ça facilite le debugage : https://www.php.net/manual/fr/pdo.error-handling.php
- Fais un var_dump() de ta requête SQL et des variables et teste ta requête dans phpmyadmin
Quand tout le reste a échoué, lisez le mode d'emploi...