mysql DELETE在phpmyadmin上工作，但不在php脚本上

Question

基本上如我的问题所述，它适用于phpmyadmin，但不适用于php本身。当我运行脚本时，它会返回true，并且不会死亡。帮帮我！

这里是查询：

DELETE FROM selections WHERE selectorID = '$userID' AND selectedID = '$ID' 

下面是PHP脚本：

<?php 

include_once "connect_to_mysql.php"; 

$errorB = false; 

$error = ''; 
$id = ''; 
$userID = ''; 
if (empty($_GET['ID']) || empty($_GET['userID'])) { 
$errorB = true; 

if (empty($_GET['ID'])) { 
    $error = $error.'-No selected ID was sent'; 

} 

if (empty($_GET['userID'])) { 
    $error = $error.'-No selector ID was sent'; 

} 


} else { 
$id = $_GET['ID']; 
$userID = $_GET['userID']; 
echo $id.$userID; 
$sqlInsert = mysql_query("DELETE FROM selections WHERE selectorID = '$userID' AND selectedID = '$ID'") or die (mysql_error()); 
echo 'shz'; 
} 

if ($errorB) { 
echo $error; 

} 



?> 

我的数据库看起来是这样的：

id|selectorID|selectedID 
3 1   4 
4 1   5 

Answer 1

你的第一次，但较小的麻烦是case sensitive nature of PHP variables：

这里

$sqlInsert = mysql_query("DELETE FROM selections WHERE selectorID = '$userID' AND selectedID = '$ID'") or die (mysql_error()); 

您参考$ID，但只有$id：

$id = $_GET['ID']; 

正确：

$sqlInsert = mysql_query("DELETE FROM selections WHERE selectorID = '$userID' AND selectedID = '$id'") or die (mysql_error()); 

重要提示

尽管这很可能会起作用，但这很容易出现SQL injection！改用PDO，或者至少，escape你的价值观！