How to Check if exist in database mysqli_num_rows - Mysqli Select Tutorial

you are not running the sql statement by using mysqli_query

you must first query sql statement and then count row.

Method - 1

See the example.

index.php

Example: PHP

<?php

$conn = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");
/*mysqli connection*/

$check = mysqli_real_escape_string($link, $_REQUEST['email']);
    $sql = "SELECT * FROM users WHERE email = '$check'";
    $res = mysqli_query($conn,$sql);
      if (mysqli_num_rows($res ) == 0){
          echo 'Number of Row 0';
    } else {
        echo 'Row available';
    }
?>

mysqli num rows

Type:	Develop
Category:	Web Tutorial
Sub Category:	Mysqli Select Tutorial
Uploaded by:	Admin