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));
}
