in dem Register Skript soll überprüft werden ob der Username schon existiert. Jedoch zeigt er mir an was anderes an.
PHP Code:
<form action="register.php" method="POST">
<input type="text" name="username" placeholder="username">
<input type="password" name="password" placeholder="Passwort">
<input type="email" name="email" placeholder="email">
<input type="submit" name="register" value="Senden">
<?php
if(isset($_POST['register'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
if($stmt = $pdo->prepare("SELECT username FROM test_user WHERE username = :username")) {
$params = array(':username' => $username);
if(!$stmt->execute($params)) {
print_r($stmt->errorInfo());
}
$row = $stmt->fetch();
$column = $stmt->rowCount();
if($column > 0) {
if(strlen($username) >= 6 && strlen($username) <= 32) {
if(ctype_alnum($username)) {
if(filter_var($email, FILTER_VALIDATE_EMAIL)) {
if($insert = $pdo->prepare("INSERT INTO test_user (username, password, email) VALUES (?, ?, ?)")) {
$insert->BindValue(1, $username);
$insert->BindValue(2, password_hash($password, PASSWORD_BCRYPT));
$insert->BindValue(3, $email);
if($insert->execute()) {
echo 'Erfolgreich';
} else {
print_r($stmt->errorInfo());
}
} else {
echo 'DB Fehler';
}
} else {
echo 'Email Invalid';
}
} else {
echo 'user Invalid';
}
}
} else {
echo 'username existiert';
}
} else {
echo 'Kein Benutzer';
}
}
?>
</form>
