php - {php} 列计数与第 1 行的值计数不匹配

Question

我创建了一个添加论坛

if ($_SERVER['REQUEST_METHOD'] == "POST" AND isset ($_REQUEST['addfinal'])) {

    $name_1 = clear_form_text ($_REQUEST['name_1']);
    $name_2 = clear_form_text ($_REQUEST['name_2']);
    $car_name = intval ($_REQUEST['id_car_name']);


    if (empty ($name_1)) $stop .= "Error text!<br>";
    if (empty ($name_2)) $stop .= "Error text!<br>";

    if ($stop == false) {

        $db->query ("INSERT INTO car_class (name_1, name_2, id_car_name) VALUES ('$name_1', '$name_2' '$car_name')") or die ($db->error);
        $infomessage = "<div class=\"attention-box attention-success\"><p class=\"text-muted\">Add success. <a href=\"index.php?module=school_class\">Back</a></p></div>";

    } else {

        $infomessage = "<div class=\"attention-box attention-danger\"><p class=\"text-muted\">" . $stop . " <a href=\"javascript:history.back();\">Врати се назад</a></p></div>";

    }

} else {

    $result = $db->query("SELECT id, name FROM car_name");
       while ($row = $result ->fetch_array())
        $arrayrow[] = $row; 

        foreach ($arrayrow as $row) {
            $select .= "<option value='".$row['id']."'>".$row['name']."</option>";

        }

    $template->set_block ('car_class-add', '', 'car_class');
    $template->set ('car_name', $select, 'car_class');

}

Select 需要从 car_name 中读取值(id, name)并将其写入 id 到 car_class

但是当我点击提交时给我列计数与第 1 行的值计数不匹配

这段代码的问题出在哪里？

谢谢

编辑上面的问题就解决了。现在脚本可以工作，但不在 id_car_name 中写入值，仅写入 0car_class.id_car_na‌​me = car_name.id 为什么还是这个问题？

Answer 1

您必须在“$name_2”后添加逗号:

 $db->query ("INSERT INTO car_class 
                     (name_1, name_2, id_car_name) 
              VALUES ('$name_1', '$name_2', '$car_name')") 
        or die ($db->error);