我有一个带有很多复选框的表单，当您选中该复选框时，发件人会发送“ on”值。在将它们插入数据库之前，我想将其更改为更可用的名称，例如值“是”，然后对于所有未选中的框，将其值为“否”。有人可以帮我吗？
这是我的代码：
<?php
include_once 'database_login.php';
$barcode = $_POST['barcode'];
$name = $_POST['name'];
$company = $_POST['company'];
$fair_trade = $_POST['fair_trade'];
$palm_oil = $_POST['palm_oil'];
$organic = $_POST['organic'];
$gm_free = $_POST['gm_free'];
$nz = $_POST['nz'];
$animals = $_POST['animals'];
$recyclable = $_POST['recyclable'];
$category = $_POST['category'];
$sub_category = $_POST['sub_category'];
$add = "INSERT INTO products (barcode, name, company, fair_trade, palm_oil, organic, gm_free, nz, animals, recyclable, category, sub_category) VALUES ('$barcode', '$name', '$company', '$fair_trade', '$palm_oil', '$organic', '$gm_free', '$nz', '$animals', '$recyclable', '$category', '$sub_category')";
$added = mysqli_query($con, $add);
header( "Location: add.php?message=1");
mysqli_close($con);
?>
您可以更改复选框的值，
<input type="checkbox" name="chk_name1" value="Yes">
至于未选中但应有No值的复选框，
// all form checkbox
$checkbox = array("chk_name1", "chk_name2");
foreach ($checkbox as $name) $_POST[$name] ?: "No";
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句