php - 复选框值带有单个值

Question

这个问题已经有答案了:

Arrayed input value inserts empty record in mysql (2 个回答)

已关闭 8 年前。

我的代码可以工作，但是如果我选择表单中的值，然后只选择单个增值数据库，则会出现问题。哪里出了问题。

<?php
$con = mysqli_connect('localhost', 'root', '12345', 'fruit');
if ($_SERVER['REQUEST_METHOD'] != 'POST' && !isset($_POST['submit'])) {
    echo '<form action="" method="post">
    <input type="checkbox" name="fruits[]" value="Apple" />APPLE<br />
            <input type="checkbox" name="fruits[]" value = "Lemon" />LEMON<br />
            <input type="submit" name="submit" value="POST">
</form>';
}elseif ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['submit'])){
    $fruit = $_POST['fruits'];
    foreach ($fruit as $fruits){
        $fruits = mysqli_real_escape_string($con, strip_tags($fruits));
    }
    $sql_add = mysqli_query($con, "INSERT INTO fruit (name) VALUES ('$fruits')");
    if (mysqli_affected_rows($con) == 1) {
        echo "Ok not problem.";
    }else {
        echo "There are some problem. Please submit your choice again.";
    }
}

Answer 1

在insert语句后结束for循环，

foreach ($fruit as $fruits){
    $fruits = mysqli_real_escape_string($con, strip_tags($fruits));
    $sql_add = mysqli_query($con, "INSERT INTO fruit (name) VALUES ('$fruits')");
}