如何将多个复选框值插入数据库？

Question

I have the following piece of code inside a html form tag :

<label for="client">Services Included:</label>
    <p><input type="checkbox" name="service[]" value="Spa"> Spa </p>
    <p><input type="checkbox" name="service[]" value="Massage"> Massage </p>
    <p></p>
    <input type="submit" value="Submit" />

And in the php code I have this:

      if(!empty($_POST['service']))
  {
    foreach ($_POST['service'] as $selected) 
    {
      $query7 ="INSERT INTO reservation_includes_service VALUES (3,'".$selected."');";
      $queryexe7 = mysql_query($queryexe7);

    }
  }

Although I have tried everything, the query doesn't work... Any ideas? Thank you for your help :)

Answer 1

As I stated in comments and posting as a community wiki:

"mysql_query($queryexe7) wrong variable. You're just creating some type of loop and is confused as to which variable to use. It's kind of like "monkey in the middle", if I could say.".

This is what you needed to use:

$queryexe7 = mysql_query($query7);

You should look into using the mysqli_ or PDO API. mysql_ is deprecated and deleted from PHP 7.