使用复选框在MySQL中插入多行

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 处理表单提交
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // 获取复选框的值
    $selectedValues = $_POST["checkbox"];

    // 循环插入选中的数据
    foreach ($selectedValues as $value) {
        // 使用预处理语句防止SQL注入
        $stmt = $conn->prepare("INSERT INTO your_table (column_name) VALUES (?)");
        $stmt->bind_param("s", $value);
        $stmt->execute();
        $stmt->close();
    }

    echo "数据插入成功！";
}

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

<!-- HTML表单 -->
<form method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>">
    <input type="checkbox" name="checkbox[]" value="value1"> Value 1<br>
    <input type="checkbox" name="checkbox[]" value="value2"> Value 2<br>
    <input type="checkbox" name="checkbox[]" value="value3"> Value 3<br>
    <input type="submit" value="提交">
</form>