/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 vote279 views1 answer
Concat object php
PHP
1 vote537 views1 answer
Sort relation model count yii2
PHP Yii
0 vote319 views2 answers
Laravel collection sort by date
PHP
1 vote372 views2 answers
Php date function get previous month
PHP
0 vote331 views3 answers
Laravel 7 upload file s3
PHP
4 votes333 views2 answers
Read json file data using php
PHP
0 vote372 views1 answer
E: Couldn't find any package by regex 'php7.2-json'
PHP
0 vote370 views1 answer
Multiple laravel site in one directory
PHP Laravel
1 vote359 views3 answers
Php convert to boolean
PHP
5 votes317 views3 answers
Get month first date and last date in php
PHP