在MysQl中插入多个复选框值

Question

I have the following checkbox items and I want to insert them in the database.

<form action="test.php" method="post">
<input type="checkbox" name="check_list[]" value="rice:10">
<input type="checkbox" name="check_list[]" value="milk:8">
<input type="checkbox" name="check_list[]" value="orange:4">
<input type="submit" />
</form>

The following is the php code:

if(!empty($_POST['check_list'])) {
    foreach($_POST['check_list'] as $check) { 
        $mealA = explode(":",$check);
        $meal = $mealA[0];
        $sql1 = "INSERT INTO Order (User, Meal, Total) VALUES ('$name' , '$meal', '$total')";
        if (mysqli_query($mysqli,$sql1)) {
            echo "You order has been recieved";
        } else {
            echo "Error: " . $sql1;
        }
    }
}

Note that the value of each checkbox means item name:price.

The problem is that I got error "Error: " . $sql1;

Answer 1

Your query fails because you have not set a value for $total. So either you have to remove the Total field from the query resulting in

$sql1 = "INSERT INTO Order (User, Meal) VALUES ('$name' , '$meal')";

which will give a NULL value to the Total column for each successful new insert

OR

based on the code you provided I 'm guessing you wanted to do something similar to this?

$mealA = explode(":",$check);
$meal = $mealA[0];
$total = $mealA[1]; // setting the value of $total otherwise query is going to fail
$sql1 = "INSERT INTO Order (User, Meal, Total) VALUES ('$name' , '$meal', '$total')";