MYSQLI_NUM_ROWS不返回任何内容[关闭]

Question

I have a table called "users" with 1 row. I have been trying to get the number of rows that exist when the username and password have been entered. This wasn't returning anything, so I have created this code in the most simple form, but still it is not returning anything.

If I run the query on phpmyadmin, it returns the row.

Why could this not be working?

include("../includes/db.php");
$result = $link->query("SELECT * FROM users");
die(mysqli_num_rows($result));

The connection to the database is fine, all the other code works fine on my CMS.

edit:

This is my now working code:

include("../includes/db.php");
if(!isset($_SESSION['loggedin'])){
    if(isset($_POST['username'])){
        $username = $_POST['username'];
        $password = md5($_POST['password']);
        $sql = "SELECT * from users WHERE username LIKE '{$username}' AND password LIKE '{$password}' LIMIT 1";
        $result = $link->query($sql);
        if (!$result->num_rows == 1) {
            echo "<p>Invalid username/password combination</p>";
            LoginForm();
        } else {
            echo "<p>Logged in successfully</p>";
            $_SESSION['loggedin'] = 1;
        }
    }else{
        LoginForm();
    }
} 

Answer 1

include("../includes/db.php");
$result = $link->query("SELECT * FROM users");
echo $result->num_rows;

My bad for the previous answer. It's been a while since I've used PHP