public function validate_inscription($param) { $other_key = $param; $passdb = new \db\db_handler(); $passdb->prepare("SELECT COUNT(*) AS NUMBER FROM USERS WHERE TOKEN = ?"); $passdb->execute(array($other_key)); $query = $passdb->fetch(PDO::FETCH_ASSOC); if ($query['NUMBER'] === '1') { $passdb->prepare("UPDATE USERS SET ENABLE = 1, TOKEN = null, VALID_TIME = null WHERE TOKEN = ?"); $passdb->execute(array($other_key)); echo "Votre compte a bien été crée !"; } else { echo "Votre compte ne peut être crée ! "; } $passdb->execute(array($other_key)); }
function error_handler($errno, $errstr, $errfile, $errline, $context = null) { if (!(error_reporting() & $errno)) { //unreported error; return; } $db = new \db\db_handler(); $continue = true; switch ($errno) { case E_ERROR: $continue = false; break; case E_WARNING: break; case E_PARSE: break; case E_NOTICE: break; case E_CORE_ERROR: $continue = false; break; case E_CORE_WARNING: $continue = false; break; case E_COMPILE_ERROR: $continue = false; break; case E_COMPILE_WARNING: $continue = false; break; case E_USER_ERROR: $continue = false; break; case E_USER_WARNING: break; case E_USER_NOTICE: break; case E_STRICT: break; case E_RECOVERABLE_ERROR: break; case E_DEPRECATED: break; case E_USER_DEPRECATED: break; default: $continue = false; break; } $sentence = "INSERT INTO `ERRORS` (`ERRNO`,`WHAT`,`FILE`,`LINE`) VALUES (?,?,?,?)"; $db->prepare($sentence); $db->execute($errno, $errstr, $errfile, $errline); }
public function create_new_user(User $user, $password, $key) { $token = $this->getRandomToken(); $this->pdo->prepare("INSERT INTO `USERS` (`EMAIL`,`NAME`,`ENABLE`,`TOKEN`) VALUES (?,?,0,?)"); $this->pdo->execute(array($user->getEmail(), $user->getName(), $key)); $id = $this->pdo->lastInsertId(); $new_password = encrypt($password, $token); $passdb = new \db\db_handler(); $passdb->prepare("INSERT INTO `PASSWORD` (`ID`,`PASSWORD`,`TOKEN`) VALUES (?,?,?)"); $passdb->execute(array($id, $new_password, $token)); }