php - mysqli_num_rows 始终返回 0

Question

这里尝试从数据库获取用户名和密码，如果找到结果，则重定向到某个页面，但 mysqli_num_rows 总是返回 0，我不知道为什么`

    if (isset($_POST['login'])) {


    $username = $_POST['username'];
    $password = $_POST['password'];

    $query = "SELECT * FROM `login` WHERE username = '$username' AND password = '$password'";
    $run  = mysqli_query($con,$query);
    if (mysqli_num_rows($run) == 1) {
        header("location: login.php");

    }}?>

`

Answer 1

        <?php

        $servername = "localhost";
        $username = "root";
        $password = "";
        $dbname = "ornament";   // My local DB Name

        $conn = mysqli_connect($servername, $username, $password, $dbname);
        if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        }

            $username = "test";   // $_POST["username"] value
            $password = "test";     // $_POST["password"] value
            $sql = "SELECT * FROM `ornament` WHERE username = '$username' AND password = '$password'";
            $result = mysqli_query($conn, $sql);

             if (mysqli_num_rows($result) == 1) {
                   echo "correct";

                } else {
                    echo "wrong";
                }



        mysqli_close($conn);
        ?> 

        </body>
        </html>

输出:

     correct

我有一个数据库名称和表名称相同，但对我来说它工作正常。

注意:请检查您在 POST 获取时是否使用了正确的密码。

无论您如何找到解决方案，祝您有美好的一天

谢谢

穆图