{php} Column count doesn't match value count at row 1

Question

I make a add forum

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');

}

The Select need to read values from car_name (id, name) and writes it id in car_class

But when i click on submit give me Column count doesn't match value count at row 1

Where is the problem with this code?

Thank you

EDIT Problem from above is solved. NOW script work but do not write value in id_car_name Only write 0 car_class.id_car_na‌me = car_name.id Why still this problem?

RiggsFolly · Accepted Answer · 2016-08-17 08:05:15Z

2

You must add comma after '$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);

edited Aug 17, 2016 at 8:05

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Aug 17, 2016 at 8:03

Imanez

5145 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Martinovska Over a year ago

oh yes thank you, now work but do not add id_car_name only write 0. car_class.id_car_name = car_name.id

Imanez Over a year ago

when you use var_dump(intval ($_REQUEST['id_car_name'])). what do you get ?

Imanez Over a year ago

after $car_name = intval ($_REQUEST['id_car_name']); add var_dump to check the value

Imanez Over a year ago

So the problem came form $_REQUEST['id_car_n‌ame'] , check it (if id_car_n‌ame is the correct name... )

Martinovska Over a year ago

I change $_REQUEST with $_POST and now work. It's correct this?

|

Collectives™ on Stack Overflow

{php} Column count doesn't match value count at row 1

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related