Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once 'config/Database.php';
- error_reporting(0);
- if (isset($_POST['register'])) {
- $error = "";
- if (empty($_POST['username']) || empty($_POST['email'] || empty($_POST['password']) || empty($_POST['repeatpassword']))) {
- $error = 'please input username email password and repeat password';
- }
- elseif($_POST['password'] === $_POST['repeatpassword']){
- $error = 'please password and repeat password same';
- }
- try {
- $stmt = $conn->prepare('SELECT * FROM users WHERE username=:username');
- $query_params = [':username' => $_POST['username']];
- $stmt->execute($query_params);
- } catch (PDOException $e) {
- die('query failed'.$e->getMessage());
- }
- $row = $stmt->fetch(PDO::FETCH_ASSOC);
- if ($row) {
- $error = 'username has used';
- }
- if (!filter_var($_POST['email'],FILTER_VALIDATE_EMAIL)) {
- $error = 'please use valid email';
- }
- try {
- $stmt = $conn->prepare('SELECT * FROM users WHERE email=:email');
- $query_params = [':email' => $_POST['email']];
- $stmt->execute($query_params);
- } catch (PDOException $e) {
- die('error query1'.$e->getMessage());
- }
- $row = $stmt->fetch(PDO::FETCH_ASSOC);
- if($row){
- $error ="email has used";
- }
- $password = hash('sha256',$_POST['password']);
- try {
- $stmt = $conn->prepare('INSERT INTO users (username, email , password) VALUES (:username, :email , :password)');
- $query_params = [
- ':username' => $_POST['username'],
- ':email' => $_POST['email'],
- ':password' => $password
- ];
- $stmt->execute($query_params);
- } catch (PDOException $e) {
- die('error query2'.$e->getMessage());
- }
- if($stmt){
- header('location: login.php');
- }else{
- return false;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement