php - 在 phpmyadmin SELECT WHERE 1 中显示第 0 - 0 行(总共 1 行，查询耗时 0.0008 秒。)

Question

我在 phpmyadmin 表中插入了一行，但是当我运行以下任何命令时它返回:

显示第 0 - 0 行(总共 1 行，查询耗时 0.0008 秒。)

SELECT * FROM library_info WHERE 1

SELECT * FROM library_info

SELECT * FROM library_info WHERE 1

SELECT * FROM library_info

HOW THE DATA IS STORED IN THE TABLE

我需要在我的 登录页面 中使用相同的 php 代码，用于 php 页面是

<?php
require('connect.inc.php');
// User is not logged in.
session_start();
if (isset($_POST['cmdlogin'])) {
    $u     = strip_tags($_POST['username']);
    $p     = strip_tags($_POST['password']);
    $query = "SELECT * FROM user_details WHERE USERNAME = '$u' AND PASSWORD = '$p'";
    echo $query;

    $result = mysql_query($query, $conn);
    if ($result) {
        echo "Valid";
    } else {
        echo "Invalid";
    } 
} else {
    echo "2";
    include 'index.php';
}
?>

结果:SELECT * FROM user_details WHERE USERNAME = 'Admin' and PASSWORD = 'JainLibrary' 无效

Answer 1

行计数器从零开始，因此您得到的第 0 行正是您插入的行。