如何使用php和mysql插入选中的复选框和删除未选中的复选框？

<form method="post" action="process.php">
  <input type="checkbox" name="option1" value="value1"> Option 1<br>
  <input type="checkbox" name="option2" value="value2"> Option 2<br>
  <input type="checkbox" name="option3" value="value3"> Option 3<br>
  <input type="submit" value="Submit">
</form>

<?php
// 连接到MySQL数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查是否成功连接到数据库

if (!$conn) {
  die("连接数据库失败: " . mysqli_connect_error());
}

// 获取选中的复选框值
$selectedOptions = array();

foreach ($_POST as $key => $value) {
  if (isset($_POST[$key])) {
    $selectedOptions[] = $_POST[$key];
  }
}

// 插入选中的复选框值到MySQL数据库
foreach ($selectedOptions as $option) {
  $sql = "INSERT INTO your_table_name (column_name) VALUES ('$option')";

  if (mysqli_query($conn, $sql)) {
    echo "插入记录成功: $option<br>";
  } else {
    echo "插入记录失败: " . mysqli_error($conn);
  }
}

// 删除未选中的复选框值
$sql = "DELETE FROM your_table_name WHERE column_name NOT IN ('" . implode("','", $selectedOptions) . "')";

if (mysqli_query($conn, $sql)) {
  echo "删除记录成功: " . mysqli_affected_rows($conn) . " 条";
} else {
  echo "删除记录失败: " . mysqli_error($conn);
}

// 关闭数据库连接
mysqli_close($conn);
?>