我有一个带有很多复选框的表单,当您选中该复选框时,发件人会发送“ 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";
关于php - 将“打开”的表单的所有值更改为"is",我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/20216434/