php - MySQL 查询为空

Question

这个问题已经有答案了:

Why do I get the MySQL Error "Query was empty"? (3 个回答)

已关闭 9 年前。

这意味着从 URL 获取数据并将其提交到数据库，但出现错误:查询为空；

我在其中添加了更多内容来测试，是的，它给出了我设置的变量的值。提前致谢

<?php
require 'variables.php';
if(empty($_REQUEST['Key']) || empty($_REQUEST['Computer']) || empty($_REQUEST['Panel'])){
die("Nothing was given for me to give back :(");
}else{
$key = $_REQUEST['Key'];
$computer = $_REQUEST['Computer'];
$panel = $_REQUEST['Panel'];
$insertquery = mysql_query("INSERT INTO keys (Key, PC, Panel) VALUES ('".$key."', '".$computer."', '".$panel."')");
$sql = mysql_query($insertquery);
if($sql){
    echo "good ". mysql_error();
}else{
    echo "bad ". mysql_error();
    echo "<br />".$key." ".$computer." ".$panel."";
}
}

?>

Answer 1

您正在调用 mysql_query() 两次。这就是问题所在

这样做

<?php
require 'variables.php';
if(empty($_REQUEST['Key']) || empty($_REQUEST['Computer']) || empty($_REQUEST['Panel'])){
die("Nothing was given for me to give back :(");
}else{
$key = $_REQUEST['Key'];
$computer = $_REQUEST['Computer'];
$panel = $_REQUEST['Panel'];
$insertquery = "INSERT INTO keys (Key, PC, Panel) VALUES ('".$key."', '".$computer."', '".$panel."')";
$sql = mysql_query($insertquery);
if($sql){
    echo "good ". mysql_error();
}else{
    echo "bad ". mysql_error();
    echo "<br />".$key." ".$computer." ".$panel."";
}
}

?>