在执行过程中打印sql查询

Question

当我执行以下代码时，所附图像中以黄色突出显示的查询将在页面中打印出来。我不想打印那个sql。我的代码段出了什么问题？

​

​

if(isset($_REQUEST["stu_performance_activity_submit"]))
    {
    $stu_performance_main_category = $_REQUEST["stu_performance_main_category"];
    $stu_performance_sub_category = $_REQUEST["stu_performance_sub_category"];
    $stu_performance_activity_name = $_REQUEST["stu_performance_activity_name"];
    $stu_performance_activity_date = $_REQUEST["stu_performance_activity_date"];
    $stu_performance_activity_description = $_REQUEST["stu_performance_activity_description"];

    $newc = "INSERT INTO stu_performance_activity 
                    (stu_performance_activity_id, 
                    stu_performance_main_category, 
                    stu_performance_sub_category, 
                    stu_performance_activity_name, 
                    stu_performance_activity_date, 
                    stu_performance_activity_description) 
            VALUES ('', 
                    '$stu_performance_main_category', 
                    '$stu_performance_sub_category', 
                    '$stu_performance_activity_name', 
                    '$stu_performance_activity_date', 
                    '$stu_performance_activity_description')";

    if($connection->query($newc) === TRUE) 
        {   

        }
    else
        {
        echo "Error: " . $newc . "<br>" . $connection->error;
        }
    }

Answer 1

插入过程中主键应为NULL。以如下方式重写您的查询

$newc = "INSERT INTO stu_performance_activity 
                    (stu_performance_activity_id, 
                    stu_performance_main_category, 
                    stu_performance_sub_category, 
                    stu_performance_activity_name, 
                    stu_performance_activity_date, 
                    stu_performance_activity_description) 
            VALUES (NULL, 
                    '$stu_performance_main_category', 
                    '$stu_performance_sub_category', 
                    '$stu_performance_activity_name', 
                    '$stu_performance_activity_date', 
                    '$stu_performance_activity_description')";