mysqli_query 在 if 语句中不起作用 - mysqli_query Not Working In If Statement

mysqli_query Not Working In If Statement

本文关键字：语句不起作用 if query mysqli | 更新日期: 2023-09-27

我将直截了当地解决问题。我的代码中的一行似乎正在起作用。它与 else 一起返回，似乎不想运行它。它没有错误，但它只是不会将其移动到数据库。正如标题所说，它是 if 语句中的mysqli_query。这是代码，我已经将箭头放在错误似乎所在的位置。

        $t_name = $_POST['topic_name'];
        $content = $_POST['con'];
        $date = date("y-m-d");
        if(isset($_POST['submit'])) {
            if($t_name && $content) {
                if(strlen($t_name) >= 10 && strlen($t_name) <= 70) {
//vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
                    if($query = mysqli_query($connect, "INSERT INTO topics('topic_id', 'topic_name', 'topic_content', 'topic_creator', 'date') VALUES ('', '".$t_name."', '".$content."', '".$_SESSION["username"]."', '".$date."')")) {
                        echo "<font color = 'green'>Topic posted!</font>";
                    } else {
                        echo "<font color='red'>Unknown failure, time to panic!</font>";
                    }
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
                } else {
                    echo "<font color='red'>Topic name must be between 10 and 70 characters long!</font>";
                }
            } else {
                echo "<font color='red'>All fields must be filled out!</font>";
            }
        }
    } else {
        include('header.php');
        echo "You must be logged in to access this page.  Click <a href='login.php'>here</a> to login.";
    }
    include('footer.php');

是的，我知道SQL注入和其他事情的危险，一旦我放下代码，我就会处理它。

请删除每个列名称的引号："topic_id"，"topic_name"...."日期"

 $query = mysqli_query($connect, "INSERT INTO topics(topic_id, topic_name, topic_content, topic_creator, date) VALUES ('', '".$t_name."', '".$content."', '".$_SESSION["username"]."', '".$date."')")

为了理解您的错误，我建议您调试查询。尝试使用 mysqli_error（）函数。

if (...) {
} else {
    die( mysqli_error($connect)); // Add this
}

您的topic_id不能设置为 null。而是删除topic_id或为其指定default值。

另外，就像@HizerCache提到的，您可以使用MySQL函数NOW()插入当前时间。

像这样：

"INSERT INTO topics(topic_id, topic_name, topic_content, topic_creator, date) VALUES (default, '".$t_name."', '".$content."', '".$_SESSION["username"]."', NOW())"

此外，使用 mysqli_error() 调试错误。

if($query = mysqli_query($connect, "INSERT INTO topics('topic_id', 'topic_name', 'topic_content', 'topic_creator', 'date') VALUES ('', '".$t_name."', '".$content."', '".$_SESSION["username"]."', '".$date."')")) {
    echo "<font color = 'green'>Topic posted!</font>";
} else {
    echo "Error : " . mysqli_error($connect);
}