?php

if(isset($_POST['register'])) {

    session_start();
    $FName = $_POST['firstname'];
    $LName = $_POST['lastname'];
    $Email = $_POST['email'];
    $PW = $_POST['password'];
    $servername = "localhost";
    $username = "root";
    $password = "root";
    $dbname = "users_db_physicians";
    $conn = new mysqli($servername, $username, $password, $dbname);
    $result_x = $conn->query("SELECT FROM users_database (username) WHERE username = '$Email'");
    if (mysqli_num_rows($result_x)>=1) {
    echo "name already exists";
    }
    else
    {
    $conn->query("INSERT INTO users_database (first_name, last_name, username, password)Values('{$FName}', '{$LName}', '{$Email}', '{$PW}')");
    header('Location: login.php');
    echo "it works";
    }


    }
?>