Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- session_start();
- $conn=mysqli_connect("localhost", "root", "", "registration");
- if(!$conn)
- {
- die("Database Failed Connecting!<br>".mysqli_error($conn)); //MySQL error-t nem szokás egy az egyben kiíratni
- }
- if(isset($_POST["username"]) && isset($_POST["password"]))
- {
- extract($_POST, EXTR_SKIP);
- if(!filter_var($email, FILTER_VALIDATE_EMAIL))
- {
- $error[]="Helytelen email formátum.";
- }
- if($password1!=$password2)
- {
- $error[]="A két jelszó nem egyezik.";
- }
- $check=mysqli_stmt_init($conn);
- mysqli_stmt_prepare("SELECT id FROM users WHERE username=?");
- mysqli_stmt_bind_param($check, "s", $username);
- mysqli_stmt_execute($check);
- mysqli_stmt_store_result($check);
- if(mysqli_stmt_num_rows($check)!=0)
- {
- $error[]="Ez a felhasználónév már foglalt.";
- }
- mysqli_stmt_close($check);
- if(!isset($error))
- {
- $password=password_hash($password1, PASSWORD_BCRYPT, ["cost" => 12]);
- $prep=mysqli_stmt_init($conn);
- mysqli_stmt_prepare($prep, "INSERT INTO 'users' (username, email, password) VALUES (?, ?, ?)");
- mysqli_stmt_bind_param($prep, "sss", $username, $email, $password);
- mysqli_stmt_execute($prep);
- if(mysqli_stmt_affected_rows($prep)==1)
- {
- echo '<div class="alert alert-success" role="alert">Sikeres regisztráció!</div>';
- }
- else
- {
- echo '<div class="alert alert-danger" role="alert">Nem sikerült a regisztráció.</div>';
- }
- mysqli_stmt_close($prep);
- }
- else
- {
- echo '<div class="alert alert-danger" role="alert">'.implode("<br>", $error).'</div>';
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement