删除查询正在执行,但记录被删除,表为空


Delete Query is executing however record is deleted and table is empty

每次"已删除!!"都是结果...$na在au中声明.php...也许删除查询可能有问题。.

<?php
date_default_timezone_set('Asia/KolKata');
$xyz = date(DATE_RFC2822);
include "../au.php";
$conn = mysql_connect('localhost', 'local', 'local');
mysql_select_db('sol_index', $conn);
$sid = $_GET['sid'];
$qqq = "SELECT * FROM $sid WHERE (one = '$na' AND three = 'liked')";
if (mysql_query($qqq)){
    mysql_query("DELETE FROM $sid WHERE (one='$na' AND three='liked')");
    echo "Removed!!!";
} else {
    mysql_query("INSERT INTO $sid (one, three) VALUES ('$na', 'liked')");
    echo "Liked!!!";
}
?>

感谢您的沟通和帮助!

每次"已删除!!"都是结果

没错。

$qqq = "SELECT * FROM $sid WHERE (one = '$na' AND three = 'liked')";
if (mysql_query($qqq)){
    mysql_query("DELETE FROM $sid WHERE (one='$na' AND three='liked')");
    echo "Removed!!!";
} 

if不正确,只要查询有效,即使没有数据,它也将始终返回 true。您需要对记录数或记录本身运行该检查,而不仅仅是在执行时运行。例如,您必须从该结果中获取数据并对其进行检查。

如何防止 PHP 中的 SQL 注入?