How can a PHP forum display a message to users indicating they already have a profile when attempting to create another one?

To display a message to users indicating they already have a profile when attempting to create another one, you can check if the user's email or username already exists in the database before allowing them to create a new profile. If a match is found, display a message informing the user that they already have a profile. 

// Check if user already has a profile
$email = $_POST['email'];
$username = $_POST['username'];

// Perform a query to check if the email or username already exists in the database
// Assuming $conn is the database connection

$query = "SELECT * FROM users WHERE email = '$email' OR username = '$username'";
$result = mysqli_query($conn, $query);

if (mysqli_num_rows($result) > 0) {
    echo "You already have a profile. Please log in instead.";
} else {
    // Proceed with creating a new profile
}

Keywords

PHP forum user profile message display duplicate profile

Related Questions