Heey!
Vraagje...
Mijn script werkte voorheen, nu heb ik een paar velden toegevoegd (voornaam,tussenvoegsel,achternaam,woonplaats etc). Nu werkt het nog wel het wordt alleen niet in de database opgeslagen. Kan iemand mij uit de brand helpen?
PHP
<?php
session_start();
// initializing variables
$username = "";
$email = "";
$straat = "";
$voornaam = "";
$tussenvoegsel = "";
$achternaam = "";
$huisnummer = "";
$postcode = "";
$woonplaats = "";
$errors = array();
// connect to the database
$db = mysqli_connect('localhost', '******', '*****', '******');
// REGISTER USER
if (isset($_POST['reg_user'])) {
// receive all input values from the form
$username = mysqli_real_escape_string($db, $_POST['username']);
$email = mysqli_real_escape_string($db, $_POST['email']);
$password_1 = mysqli_real_escape_string($db, $_POST['password_1']);
$password_2 = mysqli_real_escape_string($db, $_POST['password_2']);
$voornaam = mysqli_real_escape_string($db, $_POST['voornaam']);
$tussenvoegsel = mysqli_real_escape_string($db, $_POST['tussenvoegsel']);
$achternaam = mysqli_real_escape_string($db, $_POST['achternaam']);
$straat = mysqli_real_escape_string($db, $_POST['straat']);
$huisnummer = mysqli_real_escape_string($db, $_POST['huisnummer']);
$postcode = mysqli_real_escape_string($db, $_POST['postcode']);
$woonplaats = mysqli_real_escape_string($db, $_POST['woonplaats']);
// form validation: ensure that the form is correctly filled ...
// by adding (array_push()) corresponding error unto $errors array
if (empty($username)) { array_push($errors, "Gebruikersnaam is verplicht"); }
if (empty($email)) { array_push($errors, "Email is verplicht"); }
if (empty($voornaam)) { array_push($errors, "Voornaam is verplicht"); }
if (empty($achternaam)) { array_push($errors, "Achternaam is verplicht"); }
if (empty($straat)) { array_push($errors, "Straat is verplicht"); }
if (empty($huisnummer)) { array_push($errors, "Huisnummer is verplicht"); }
if (empty($postcode)) { array_push($errors, "Postcode is verplicht"); }
if (empty($woonplaats)) { array_push($errors, "Woonplaats is verplicht"); }
if (empty($password_1)) { array_push($errors, "Password is required"); }
if ($password_1 != $password_2) {
array_push($errors, "The two passwords do not match");
}
// first check the database to make sure
// a user does not already exist with the same username and/or email
$user_check_query = "SELECT * FROM users WHERE username='$username' OR email='$email' LIMIT 1";
$result = mysqli_query($db, $user_check_query);
$user = mysqli_fetch_assoc($result);
if ($user) { // if user exists
if ($user['username'] === $username) {
array_push($errors, "Username already exists");
}
if ($user['email'] === $email) {
array_push($errors, "email already exists");
}
}
// Finally, register user if there are no errors in the form
if (count($errors) == 0) {
$password = md5($password_1);//encrypt the password before saving in the database
$query = "INSERT INTO users (username,email,password,voornaam,tussenvoegsel,achternaam,straat,huisnummer,postcode,woonplaats,geboortedatum,geslacht)
VALUES('$username', '$email', '$password', '$straat', '$huisnummer', '$postcode', '$woonplaats', '$voornaam', '$tussenvoegsel', '$achternaam', '$geslacht', '$geboortedatum')";
mysqli_query($db, $query);
$_SESSION['username'] = $username;
$_SESSION['success'] = "You are now logged in";
header('location: index.php');
}
}
// LOGIN USER
if (isset($_POST['login_user'])) {
$username = mysqli_real_escape_string($db, $_POST['username']);
$password = mysqli_real_escape_string($db, $_POST['password']);
if (empty($username)) {
array_push($errors, "Username is required");
}
if (empty($password)) {
array_push($errors, "Password is required");
}
if (count($errors) == 0) {
$password = md5($password);
$query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$results = mysqli_query($db, $query);
if (mysqli_num_rows($results) == 1) {
$_SESSION['username'] = $username;
$_SESSION['success'] = "You are now logged in";
header('location: index.php');
}else {
array_push($errors, "Wrong username/password combination");
}
}
}
?>
.