I am trying to create a registration form but when it comes time to perform the query to add the new user to the database, I do not mark any error and yet this new user does not appear in the table.
$SQL = new PDO("mysql:host=localhost;dbname=arkan", "root", "");
if (isset($_POST['register'])) {
$registerDataFields = array(
$nameField = $_POST['registerName'], //0
$passwordField = $_POST['registerPassword'], //1
$gradeField = $_POST['registerGrade'], //2
$groupField = $_POST['registerGroup'], //3
$questionField = $_POST['registerQuestion'], //4
$answerField = $_POST['answerQuestion'], //5
$arkanCodeField = $_POST['arkanCode'] //6
);
foreach($registerDataFields as $registerField) {
if (empty($registerField)) {
echo '<script>alert("Necesitas llenar todos los campos.");</script>';
exit;
}
}
$checkGroup = $SQL->query("SELECT * FROM grades WHERE ".$registerDataFields[3]." = 1;");
if(!$checkGroup->fetch()) {
echo '<script>alert("Este grupo no está registrado en Arkan.");</script>';
exit;
} else {
$checkArkan = $SQL->query("SELECT * FROM grades WHERE arkancode".$registerDataFields[3]." = ".$registerDataFields[6].";");
if(!$checkArkan->fetch()) {
echo '<script>alert("Código de Arkan incorrecto.");</script>';
exit;
}
}
$SQL->query("INSERT INTO accounts VALUES (NULL, 0, ".$registerDataFields[0].", ".sha1($registerDataFields[1]).", ".$registerDataFields[2].", ".$registerDataFields[3].", ".$registerDataFields[4].", ".$registerDataFields[5].");");
echo '<script>alert("Tu cuenta ha sido correctamente creada.");</script>';
header("Location: index.php");
}
What could be the problem? Thanks.