php - 复选框和 MySQL

Question

不是只知道如何将复选框“插入”数据库的常见情况，我有一个包含多个复选框的表单...大约 25 个复选框，每个复选框具有相同的名称和 1-25 的值，现在问题是我需要它们具有相同的名称才能运行防止选择不超过 4 个复选框的脚本...

HTML代码

<input type="checkbox" name="ckb" id="EngineeringWorkshops" value=1 onclick='chkcontrol(0)';>
<label for="EngineeringWorkshop"> Engineering Workshops           </label>

PHP代码

$engineeringworkshops = mysqli_real_escape_string($dbcon, $_POST['cob']); 


    $sql="INSERT INTO courses (studentid, engworkshops)
    VALUES ('$studentid', '$engineeringwokshops')";

engworkshops 列类型是 tinyint(4) 默认值设置为 0

Answer 1

使用这样的 html:

<form>
<input type='checkbox' name='data[]' value='YourId' /> Data
<input type='checkbox' name='data[]' value='AnotherId' /> AnotherData
<input type='checkbox' name='data[]' value='OneMoreId' /> OneMoreData
// others
</form>

如何在 php 中处理这些数据？

使用这个:

$engineeringworkshops = mysqli_real_escape_string($dbcon, $_POST['cob']); 
// handle data from checkboxes
foreach($_POST['data') as $item) {
    // do something in item
    $sql="INSERT INTO courses (studentid, engworkshops) VALUES ('$item', '$engineeringwokshops')";
}