/PHP/How to check if username already exists in php

How to check if username already exists in php

$firstname = $_POST["firstname"];
$lastname = $_POST["lastname"];
$email = $_POST["email"];
$pass = $_POST["password"];

$check_email = mysqli_query($conn, "SELECT Email FROM crud where Email = '$email' ");
if(mysqli_num_rows($check_email) > 0){
    echo('Email Already exists');
}
else{
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $result = mysqli_query($conn, "INSERT INTO crud (Firstname, Lastname, Email, Password) VALUES ('$firstname', '$lastname', '$email', '$pass')");
}
    echo('Record Entered Successfully');
}

Source: stackoverflow.com

How to check user already exists in php

$sql = "SELECT username FROM table_name WHERE username='{$username}'";
$result = mysqli_query($con,$sql) or die("Query unsuccessful") ;
      if (mysqli_num_rows($result) > 0) {
        echo "Username is already exist";
      } else {
             ...............   
      }

Similar codes

0 vote243 views2 answers
Wp colibri delete footer
PHP Wordpress
0 vote201 views1 answer
Phpmyadmin delete wordpress shortcode
PHP Wordpress
7 votes238 views2 answers
Laravel seeder with relationships
PHP
0 vote158 views1 answer
Image watermark on image laravel 8
PHP
0 vote182 views1 answer
Php get slug
PHP
0 vote209 views1 answer
Laravel reroute 419
PHP Laravel
0 vote163 views1 answer
How convert the string to int in laravel function event
PHP Laravel
26 votes245 views6 answers
Drop foreign key laravel
PHP Laravel
28 votes306 views12 answers
Laravel middleware
PHP Laravel
0 vote186 views1 answer
Cannot be cast automatically to type integer laravel
PHP