$username = "test";
$password = "1234";
$type = "User";

try{
    $conn = new PDO("mysql:host=$servername;dbname=$dbname;charset=utf8", $dbusername, $dbpassword);

    if (!$conn){
        $_SESSION['error'] = "Couldn't connect to the database";
        redirect('../index.php');
    }

    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    //Finding if a user exists with that username inside database
    $sql_select = 'SELECT * FROM users WHERE username=:username';
    $query_select = $conn->prepare(sql_select);

    $query_select->execute(array(':username' => $username));

    while($row = mysql_fetch_assoc($query_select)){
        $dbuname = $row['username'];
    }

    if(strtolower($username)==strtolower($dbuname)){
        $_SESSION['error'] = "That user already exists";
        redirect('../pages/functions/add-member.php');
    }

    else{
        //Inserting new user data into database
        $sql_insert = "INSERT INTO users (username, password, type) VALUES (:username, :password, :type)";
        $query_insert = $conn->prepare($sql_insert);

        $query_insert->execute(array(
            ':username' => $username,
            ':password' => $password,
            ':type' => $type
        ));

        echo "New record created successfully";
    }
}
catch(PDOException $e){
    echo $sql . "<br>" . $e->getMessage();
}

$conn = null;