Problème d'envoie sur une BDD SQL

Fermé
OhhRaj Messages postés 1 Date d'inscription samedi 9 avril 2016 Statut Membre Dernière intervention 9 avril 2016 - 9 avril 2016 à 12:01
Bonjour,
Je développe actuellement un site web mais je rencontre un problème lors de l'envoie sur la base de donnée SQL. Voici mon code :

<?php
session_start();
if(isset($_POST['registerSubmit'])) {
if(isset($_POST['username']) AND isset($_POST['password']) AND isset($_POST['passwordConfirm']) AND isset($_POST['mail']) AND isset($_POST['mailConfirm'])) {
if(!empty($_POST['username']) AND !empty($_POST['password']) AND !empty($_POST['passwordConfirm']) AND !empty($_POST['mail']) AND !empty($_POST['mailConfirm'])){
if($_POST['password'] == $_POST['passwordConfirm']){
if($_POST['mail'] == $_POST['mailConfirm']){
if(filter_var($_POST['mail'], FILTER_VALIDATE_EMAIL)){
$username = htmlspecialchars($_POST['username']);
$password = sha1(htmlspecialchars($_POST['password']));
$mail = htmlspecialchars($_POST['mail']);
try
{
$bdd = new PDO('mysql:host=PRIVATE;dbname=PRIVATE;charset=utf8', 'PRIVATE', 'PRIVATE');
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$null = 0;

if($req = $bdd->prepare('INSERT INTO users(id, username, mail, password, grade) VALUES(:id, :username, :mail, :password, :grade)')){
if($req->execute(array('id' => '', 'username' => $username, 'mail' => $mail, 'password' => $password, 'grade' => $grade))){
$_SESSION['username'] = $username;
$_SESSION['mail'] = $mail;
$_SESSION['grade'] = 'membre';
header('Location: ../index.php');
}
else{
header('Location: register.php?error=1');
}
}
else{
header('Location: register.php?error=2');
}
}
else{
header('Location: register.php?error=3');
}
}
else{
header('Location: register.php?error=4');
}
}
else{
header('Location: register.php?error=5');
}
}
else{
header('Location: register.php?error=6');
}
}
else{
header('Location: register.php?error=6');
}
}

?>




Merci d'avance.
Cordialement,
OhhRaj.