我是新手PHP,我正在寻找以下一些帮助:我需要实现此php代码中的多个复选框的数组,并在MySql数据库中设置数据,但不起作用
php代码
<?php
require_once "../lakota/config.php";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (isset($_POST['faction'], $_POST['stations'], $_POST['active'], $_POST['pending'], $_POST['influence'], $_POST['id_fact'])) {
$sql = "INSERT INTO lakotabgs (faction, stations, active, pending, influence, id_fact) VALUES (?,?,?,?,?,?)";
if ($stmt = $link->prepare($sql)) {
$stmt->bind_param("ssssss", $_POST['faction'], $_POST['stations'], $_POST['active'], $_POST['pending'], $_POST['influence'], $_POST['id_fact']);
$active = isset($_POST['active']) ? $_POST['active'] : array();
foreach($active as $actives) {
echo $actives . '<br/>';
}
if ($stmt->execute()) {
header("location: ../lakota/index.php");
exit();
} else {
echo "Errore! Riprova più tardi.";
}
$stmt->close();
}
}
$link->close();
}
?>html代码
<form action="<?php echo $_SERVER["PHP_SELF"] ?>" method="post">
<div class="form-group">
<label><b>Stati Attivi</b> – <i>Selezionare una o più voci interessate.</i></label>
<input type="checkbox" name="active[]" value="si"/> si
<input type="checkbox" name="active[]" value="no"/> no
</div>
<input type="submit" class="btn btn-primary" value="Aggiungi">
<a href="../lakota/index.php" class="btn btn-default">Annulla</a>
</form>发布于 2020-11-14 07:23:21
你必须遍历"active“
当您像这样发送HTML元素时:
<input type="checkbox" name="active[]" value="no"/>
它们将成为PHP中的一个数组,因此如下所示:
foreach($_POST['active'] as $act){
//whatever you want to do with $act since it represents an option right now
}https://stackoverflow.com/questions/64828621
复制相似问题