将复选框值(共3个)分配给不同的变量以传递到不同的列

<form>
  <input type="checkbox" id="checkbox1" value="Value 1"> Checkbox 1
  <input type="checkbox" id="checkbox2" value="Value 2"> Checkbox 2
  <input type="checkbox" id="checkbox3" value="Value 3"> Checkbox 3
</form>

var checkbox1 = document.getElementById("checkbox1");
var checkbox2 = document.getElementById("checkbox2");
var checkbox3 = document.getElementById("checkbox3");

var value1, value2, value3;

if (checkbox1.checked) {
  value1 = checkbox1.value;
}

if (checkbox2.checked) {
  value2 = checkbox2.value;
}

if (checkbox3.checked) {
  value3 = checkbox3.value;
}

// 假设你已经连接到数据库并准备好执行插入操作

// 将变量值插入到不同的列中
$query = "INSERT INTO your_table (column1, column2, column3) VALUES ('$value1', '$value2', '$value3')";
$result = mysqli_query($connection, $query);

if ($result) {
  echo "数据插入成功！";
} else {
  echo "数据插入失败！";
}