/PHP/How to check user already exists in php

How to check user 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 vote102 views1 answer
Get cart item by cart item key woocommerce
PHP
39 votes142 views6 answers
Get today date in php
PHP
25 votes135 views2 answers
Clear cache without using composer in laravel 8
PHP Laravel
3 votes127 views3 answers
Php check if a url exists
PHP
0 vote103 views2 answers
Change Initial Country For Caldera Forms Phone Fields
PHP
4 votes101 views5 answers
Php run command terminal
PHP
2 votes99 views2 answers
Wpdb get last query
PHP
0 vote102 views2 answers
Laravel log could not be opened fix
PHP
0 vote56 views1 answer
Php text to html
PHP
0 vote70 views1 answer
Laraverl add collect
PHP Laravel