PHP复选框数据回显报错与显示异常问题求助

我在data.php第25、26行遇到错误，提示Invalid argument supplied for foreach()。我希望在展示页面回显复选框选中的活动选项，但页面无法echo出内容，不过数据已成功存入数据库。相关代码如下：

data.php代码 #

<html>

<head>
    <title>data.php</title>
</head>
<center>
    <h1>
        <p style="color:red;">Your DATA</p>
    </h1>

    <body style="background-color:powderblue;">
        <center>
            <h2>
                <?php
                $Firstname = $_POST['f_name'];
                $Lastname = $_POST['l_name'];
                $emeil = $_POST['emeil'];
                $friend = $_POST['friend'];
                $event = $_POST['check_list'];
                $selected = $event; //trying to define variable
                if (is_array($event)) {
                    foreach ($_POST['check_list'] as $selected) { //trying to echo multiple data from checkbox
                        echo $selected;
                    }
                }
                echo " 1)Firstname :   " . $Firstname;
                echo "<br>";
                echo " 2)Lastname :   " . $Lastname;
                echo "<br>";
                echo " 3)emeil :   " . $emeil;
                echo "<br>";
                echo " 4)friend :   " . $friend;
                echo "<br>";
                echo " 5)event : " . $selected; //echo statement
                echo "<br>";
                $link = mysqli_connect("localhost", "root", "", "eventreg");
                if ($link === false) {
                    die("ERROR:Could not connect." .
                        mysqli_connect_error());
                }
                $sql = "INSERT INTO eventreg (f_name,l_name,email,event,friend) VALUES ('$Firstname','$Lastname','$emeil','$event','$friend')";
                if (mysqli_query($link, $sql)) {
                    echo "Records inserted successfully.";
                } else {
                    echo "ERROR:Could not able to execute" .
                        mysqli_error($link);
                }
                mysqli_close($link);
                ?>
        </center>
        </h2>
    </body>

</html>

register.php代码 #

<html>

<head>
    <h1>Online Event Registration</hi>
        <h2> Register today</h2>
</head>

<body style="background-color:powderblue;">
    <form action="data.php" method="post">
        First name :<input type="text" name="f_name" required>
        <br>
        <br>
        Last name :<input type="text" name="l_name" required>
        <br>
        <br>
        emeil :<input type="text" name="emeil" size="20" maxlength="60" required /></p>
        <br>
        How many friend you will bring along?
        <br>
        <br>
        <select id="friend" name="friend">
            <option value="one">ONE</OPTION>
            <option value="two">TWO</OPTION>
            <option value="three">THREE</OPTION>
            <option value="four">FOUR</OPTION>
        </select>
        <br>
        <br>
        <br>
        How do you hear about the event ? //checkbox coding
        <br>
        <input type="checkbox" id="cfriend@colleague" name="check_list" value="friend@colleague">
        <label for="cfriend@colleague"> Friend @ Colleague</label><br>
        <input type="checkbox" id="cadvertisement" name="check_list" value="advertisement">
        <label for="cadvertisement"> Advertisement</label><br>
        <input type="checkbox" id="cTV" name="check_list" value="TV">
        <label for="cTV"> TV</label><br>
        <br>
        <br>
        <input type="submit" value="Register">
    </form>
    <a href="http://localhost:8080/final%20project/paparan.php">paparan Admin</a>
</body>

</html>

我已参考多个在线foreach用法示例，但仍未找出错误根源，推测问题与注册页的复选框代码相关。

错误原因分析 #

1. 复选框name属性错误：HTML中多个复选框需传递数组时，name属性必须写成check_list[]，否则选中多个选项只会传递最后一个值，未选中时$_POST['check_list']直接不存在，触发未定义索引和foreach参数错误。
2. 变量存在性未校验：直接访问$_POST['check_list']会导致未定义索引警告，且未选中任何选项时，is_array($event)会因变量未定义报错。
3. 回显逻辑缺陷：当前foreach仅逐个输出选中项，最后单独echo$selected仅能显示最后一个选中值，未选中时$selected处于未定义状态。

解决方案 #

1. 修改register.php的复选框name属性 #

将所有复选框的name="check_list"改为name="check_list[]"，确保PHP能接收数组格式的选中值：

<input type="checkbox" id="cfriend@colleague" name="check_list[]" value="friend@colleague">
<label for="cfriend@colleague"> Friend @ Colleague</label><br>
<input type="checkbox" id="cadvertisement" name="check_list[]" value="advertisement">
<label for="cadvertisement"> Advertisement</label><br>
<input type="checkbox" id="cTV" name="check_list[]" value="TV">
<label for="cTV"> TV</label><br>

2. 优化data.php的逻辑，修复错误并完善回显 #

修改data.php中处理复选框的代码，增加变量校验并优化回显方式：

// 初始化变量，避免未定义
$Firstname = isset($_POST['f_name']) ? $_POST['f_name'] : '';
$Lastname = isset($_POST['l_name']) ? $_POST['l_name'] : '';
$emeil = isset($_POST['emeil']) ? $_POST['emeil'] : '';
$friend = isset($_POST['friend']) ? $_POST['friend'] : '';
$selectedEvents = '未选择任何选项';

// 处理复选框数据
if(isset($_POST['check_list']) && is_array($_POST['check_list']) && !empty($_POST['check_list'])){
    // 用逗号拼接数组，方便回显和存入数据库
    $selectedEvents = implode(', ', $_POST['check_list']);
}

// 回显内容
echo " 1)Firstname :   " . $Firstname;
echo "<br>";
echo " 2)Lastname :   " . $Lastname;
echo "<br>";
echo " 3)emeil :   " . $emeil;
echo "<br>";
echo " 4)friend :   " . $friend;
echo "<br>";
echo " 5)event : " . $selectedEvents; // 回显选中的所有选项
echo "<br>";

// 数据库连接与插入
$link = mysqli_connect("localhost", "root", "", "eventreg");
if ($link === false) {
    die("ERROR:Could not connect." . mysqli_connect_error());
}

// 使用预处理语句避免SQL注入
$sql = "INSERT INTO eventreg (f_name,l_name,email,event,friend) VALUES (?, ?, ?, ?, ?)";
if($stmt = mysqli_prepare($link, $sql)){
    mysqli_stmt_bind_param($stmt, "sssss", $Firstname, $Lastname, $emeil, $selectedEvents, $friend);
    if(mysqli_stmt_execute($stmt)){
        echo "Records inserted successfully.";
    } else {
        echo "ERROR:Could not able to execute: " . mysqli_stmt_error($stmt);
    }
    mysqli_stmt_close($stmt);
}
mysqli_close($link);

关键说明 #

• 用isset()校验$_POST变量是否存在，避免未定义索引错误。
• 用implode()将复选框数组转为字符串，既方便回显，也能正常存入数据库（原代码直接存数组会变成Array字符串）。
• 替换为预处理语句，彻底解决SQL注入风险。

内容的提问来源于stack exchange，提问作者aymandinie