Showing rows 0 - 0(1 total，Query took 0.0008 seconds.)in phpmyadmin SELECT WHERE 1

k3fezbri 于 2023-08-05 发布在 PHP

关注(0)|答案(2)|浏览(139)

我在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'无效

phpmyadmin

来源：https://stackoverflow.com/questions/42080533/showing-rows-0-0-1-total-query-took-0-0008-seconds-in-phpmyadmin-select-wh