HTML表单无法向PHP文件传递数据，变量未定义求助

核心错误点 #

• 超全局变量大小写错误：PHP中$_POST是大写的，原代码写成$_post，导致无法获取表单数据。
• isset判断逻辑错误：原代码检查未定义的变量（如$cust_name）而非$_POST数组中的键，且用||逻辑或导致判断失效，应改为检查$_POST中的必填字段并使用&&确保所有必填项存在。
• 数据库连接参数错误：mysqli构造函数参数顺序为(主机, 用户名, 密码, 数据库名)，原代码多传了一个冗余的your_password参数，导致连接失败。
• bind_param变量遗漏$符号：绑定参数时safety, ciricullum, comment未加$，会被当作常量而非变量处理。
• HTML标签未闭合：部分<label>标签未闭合，虽不影响数据提交，但不符合规范。

修正后的PHP代码 #

<?php
// 开启错误提示，方便调试（上线后可注释）
error_reporting(E_ALL);
ini_set('display_errors', 1);

// 检查所有必填POST字段是否存在
if (isset($_POST['cust_name'], $_POST['dept'], $_POST['facilities'], $_POST['faculty'], $_POST['extraciricular'], $_POST['safety'], $_POST['ciricullum'])) {
    // 使用大写$_POST获取表单数据
    $cust_name = $_POST['cust_name'];
    $dept = $_POST['dept'];
    $facilities = $_POST['facilities'];
    $faculty = $_POST['faculty'];
    $extraciricular = $_POST['extraciricular'];
    $safety = $_POST['safety'];
    $ciricullum = $_POST['ciricullum'];
    $comment = isset($_POST['comment']) ? $_POST['comment'] : ''; // 评论为可选字段，做容错处理

    // 修正数据库连接参数
    $conn = new mysqli('localhost', 'root', 'your_password', 'suveyres');
    if ($conn->connect_error) {
        die('连接失败: ' . $conn->connect_error);
    } else {
        $stmt = $conn->prepare("INSERT INTO surveyresult(cust_name, dept, facilities, faculty, extraciricular, safety, ciricullum, comment) VALUES(?, ?, ?, ?, ?, ?, ?, ?)");
        // 修正变量前的$符号
        $stmt->bind_param("ssssssss", $cust_name, $dept, $facilities, $faculty, $extraciricular, $safety, $ciricullum, $comment);
        $stmt->execute();
        echo "感谢您的反馈";
        $stmt->close();
        $conn->close();
    }
} else {
    echo "表单数据未正确传递到PHP文件";
}
?>

修正后的HTML表单（闭合标签） #

<form action="connect.php" method="post">
    <label class="labe"><h5>Name:</h5></label>
    <input class="txtbx" type="text" name="cust_name" placeholder="enter your name here" required>
    <div class="box1">
        <div class="box2">
            <label class="labe"><h3>department:</h3></label>
            <div class="opt">
                <label><input type="radio" name="dept" value="department1" required>department1</label>
                <label><input type="radio" name="dept" value="department2">department2</label>
                <label><input type="radio" name="dept" value="department3">department3</label>
                <label><input type="radio" name="dept" value="department4">department4</label>
                <label><input type="radio" name="dept" value="department5">department5</label>
            </div>
        </div>
        <div class="satifaction_box">
            <div class="box2">
                <h3 class="polo">Rate your satifaction with:</h3>
                <div class="box3">
                    <label class="labe"><h3>facilities:</h3></label>
                    <div class="opt">
                        <label><input type="radio" name="facilities" value="good" required>good</label>
                        <label><input type="radio" name="facilities" value="neutral">neutral</label>
                        <label><input type="radio" name="facilities" value="bad">bad</label><br>
                    </div>
                </div>
            </div>
            <div class="box3">
                <label class="labe"><h3>faculty:</h3></label>
                <div class="opt">
                    <label><input type="radio" name="faculty" value="good" required>good</label>
                    <label><input type="radio" name="faculty" value="neutral">neutral</label>
                    <label><input type="radio" name="faculty" value="bad">bad</label><br>
                </div>
            </div>
            <div class="box3">
                <label class="labe"><h3>extracurricular:</h3></label>
                <div class="opt">
                    <label><input type="radio" name="extraciricular" value="good" required>good</label>
                    <label><input type="radio" name="extraciricular" value="neutral">neutral</label>
                    <label><input type="radio" name="extraciricular" value="bad">bad</label><br>
                </div>
            </div>
            <div class="box3">
                <label class="labe"><h3>safety:</h3></label>
                <div class="opt">
                    <label><input type="radio" name="safety" value="good" required>good</label>
                    <label><input type="radio" name="safety" value="neutral">neutral</label>
                    <label><input type="radio" name="safety" value="bad">bad</label><br>
                </div>
            </div>
            <div class="box3">
                <label class="labe"><h3>curricullum:</h3></label>
                <div class="opt">
                    <label><input type="radio" name="ciricullum" value="good" required>good</label>
                    <label><input type="radio" name="ciricullum" value="neutral">neutral</label>
                    <label><input type="radio" name="ciricullum" value="bad">bad</label><br>
                </div>
            </div>
        </div>
    </div>
    <div class="comment">
        <input class="txtbx" type="text" name="comment" placeholder="comment here">
    </div>
    <button type="submit">Submit</button>
</form>

额外检查建议 #

1. 确认connect.php与HTML文件在同一目录下，或action属性使用正确的相对/绝对路径。
2. 检查数据库表surveyresult的字段名与插入语句中的字段完全一致（注意拼写：如extraciricular、ciricullum是否与表中字段匹配）。

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