我有一个带有很多复选框的表单,当您选中该复选框时,发件人会发送“ 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/

10-12 12:46
查看更多