Untitled

<html>
<div class="form-group">
            <label for="exampleInputUsername">Username</label>
            <input type="text" name="name" class="form-control" id="exampleInputUsername" placeholder="enter username">
            <span class="error_message"><?php echo $nameErr;?></span>
          </div>

          <div class="form-group">
              <label for="exampleInputEmail1">Email address</label>
              <input type="email" name="email" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Enter email">
              <span class="error_message"><?php echo $emailErr;?></span>
              <small id="emailHelp" class="form-text text-muted">We'll never share your email with anyone else.</small>
            </div>

    <button type="submit" name="signupBtn" class="btn btn-primary">SIGNUP</button>
</html>

<?php
if(isset($_POST['signupBtn'])){
    $name = trim($_POST['name']);
    $email = trim($_POST['email']);

    $hashed_password = password_hash($pwd, PASSWORD_DEFAULT);
    $encrypted = password_hash($cpwd, PASSWORD_DEFAULT);

    // check if user already exist
    $username_exist = "SELECT * FROM signup WHERE username=:name";
    $email_exist = "SELECT * FROM signup WHERE email=':email'";

    $username_result = $dbh->prepare($username_exist);
    $email_result = $dbh->prepare($email_exist);

    $username_result->bindParam(':name', $name);
    $email_result->bindParam(':email', $email);

    $username_result->execute();


    if( $username_result->execute() && $username_result->rowCount() > 0){ // check if execute returns true
        $nameErr = "username already taken";
    } elseif ($email_result->execute() && $email_result->rowCount() > 0) { // check if execute returns true
        if($email_result == true){
            $emailErr = "email taken";
        }
    }else {
        // insert into database
        $insert="INSERT INTO signup(username, email,password,confirm_password) VALUES(:name, :email, :pwd, :cpwd)";
        $statement = $dbh->prepare($insert);
        $statement->bindParam(':name', $name);
        $statement->bindParam(':email', $email);
        $statement->bindParam(':pwd', $hashed_password);
        $statement->bindParam(':cpwd', $encrypted);

        if ($statement->execute() && $statement->rowCount() > 0) { //here
            $result = "row inserted";
        }else {
            $result = "insertion failed";
        }


    }


    }

?>