php - mysql : how to submit 2 sets of checkbox in two different column in a table

Question

我有两组带有不同复选框选项的 div :

<div id="mobile_device" style="display:none;">
<font size="3"><b>Select the accessories :</b></font>
</br></br>
    <input type="checkbox" name="mobile[]" value="charger"/>  Charger &nbsp;&nbsp; &nbsp; <input type="checkbox" name="mobile[]" value="case"/> Case &nbsp;&nbsp;&nbsp;
    <input type="checkbox" name="mobile[]" value="headset"/> Headset &nbsp;&nbsp; &nbsp; <input type="checkbox" name="mobile[]" value="box"/> Box&nbsp;&nbsp; &nbsp; 
    <input type="checkbox" name="mobile[]" value="usb"/> USB Cable &nbsp;&nbsp; &nbsp; <input type="checkbox" name="mobile[]" value="sim"/> SIM<br/>
</div>

div id="desktop_device" style="display:none;">
<font size="3"><b>Select the accessories :</b></font>
</br></br>
<input type="checkbox" name="desktop[]" value="adaptor"/>  Adaptor &nbsp;&nbsp; &nbsp; <input type="checkbox" name="desktop[]" value="privacy"/> Privacy Screen &nbsp;&nbsp;&nbsp;
<input type="checkbox" name="desktop[]" value="mouse"/> Mouse &nbsp;&nbsp; &nbsp; <input type="checkbox" name="desktop[]" value="keyboard"/> Keyboard&nbsp;&nbsp; &nbsp; 
<input type="checkbox" name="desktop[]" value="connector"/> Desktop Connector <br/><br/>
</div>

现在我试图在数据库的两列中提交一组复选框值。

if (isset($_POST['submit']))
    { 
        // get form data, making sure it is valid
        $type = $_POST['type'];
        $name = $_POST['name'];
        $serial = $_POST['serial'];
        $imei = $_POST['imei'];
        $mobile = implode(",", $_POST['mobile']);
        $desktop = implode(",", $_POST['desktop']);
        $chargerno = $_POST['chargerno'];
        $connectorno = $_POST['connectorno'];
        $monitor = $_POST['monitor'];
        $monitorno = $_POST['monitorno'];       



            // save the data to the database
            $sql3= "INSERT INTO devices (type, name, serial, imei, mobile, desktop, chargerno, connectorno, monitor, monitorno) VALUES ('$type', '$name', '$serial', '$imei', '$mobile', $desktop, $chargerno, $connectorno, $monitor, $monitorno)";
            mysqli_query($mysqli,$sql3) or die(mysqli_error($mysqli));
            }   

但是我收到了类似“字段列表”中的未知列“适配器”的错误。

如何将两个 div 中选定的复选框值提交到两个不同的列中。

Answer 1

$desktop 必须作为字符串传递，因此:

$sql3= "INSERT INTO devices (type, name, serial, imei, mobile, desktop, chargerno, connectorno, monitor, monitorno) VALUES ('$type', '$name', '$serial', '$imei', '$mobile', '$desktop', $chargerno, $connectorno, $monitor, $monitorno)";