排查Ajax传递city_id时出现Undefined Index问题求助

我帮你找到了几个核心问题，正是这些导致了Undefined Index错误和邮编选择框失效：

1. Undefined Index错误的直接诱因 #

你在ajaxData.php的第一行就直接赋值$city_id=$_POST['city_id'];，但这行代码在isset($_POST["city_id"])的判断之前。如果请求中没有携带city_id参数（比如用户直接访问这个PHP文件，或者Ajax请求异常），这行代码会立刻抛出Undefined Index错误。而且这行赋值完全多余，应该在判断参数存在后再取值。

2. SQL查询的字段名错误 #

你的SQL语句里写的是WHERE city_name = '$city_id'，但从前端传递的cityID是城市选择框的value（也就是数据库里的城市ID，对应city_id字段），把city_name改成city_id才能正确关联到邮编数据，否则查询结果为空，邮编框自然没有选项。

3. 条件判断的语法错误 #

elseif($num_rows = 0)这里用了赋值运算符=，而不是比较运算符==。这会把$num_rows强制设为0，导致这个条件永远不会被触发（因为0在布尔判断中是false）。

修正后的ajaxData.php代码 #

<?php
// 先验证参数存在且非空，再取值
if(isset($_POST["city_id"]) && !empty($_POST["city_id"])){
    $city_id = $_POST['city_id'];
    // 修正字段名为 city_id
    $query = mysqli_query($conn, "SELECT * FROM zipcodes WHERE city_id = '$city_id' AND status = 1 ORDER BY zipcode ASC");
    $num_rows = mysqli_num_rows($query);
    
    if($num_rows > 0){
        echo '<option value="">Select zipcode</option>';
        while($row = $query->fetch_assoc()){
            echo '<option value="'.$row['zipcode'].'">'.$row['zipcode'].'</option>';
        }
    }
    // 修正为比较运算符 ==
    elseif($num_rows == 0){
        echo '<option value="">Zipcode not available</option>';
    }
} else {
    // 当没有city_id参数时，返回默认提示
    echo '<option value="">Select city first</option>';
}
?>

额外优化建议 #

防止SQL注入风险

当前直接把用户输入拼到SQL里有注入风险，建议改用预处理语句：

<?php
if(isset($_POST["city_id"]) && !empty($_POST["city_id"])){
    $city_id = $_POST['city_id'];
    // 预处理语句
    $stmt = mysqli_prepare($conn, "SELECT * FROM zipcodes WHERE city_id = ? AND status = 1 ORDER BY zipcode ASC");
    mysqli_stmt_bind_param($stmt, "i", $city_id);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $num_rows = mysqli_num_rows($result);
    
    if($num_rows > 0){
        echo '<option value="">Select zipcode</option>';
        while($row = mysqli_fetch_assoc($result)){
            echo '<option value="'.$row['zipcode'].'">'.$row['zipcode'].'</option>';
        }
    } elseif($num_rows == 0){
        echo '<option value="">Zipcode not available</option>';
    }
    mysqli_stmt_close($stmt);
} else {
    echo '<option value="">Select city first</option>';
}
?>

前端调试增强

在Ajax请求里添加error回调，方便排查请求异常：

$('#city_id').on('change',function(){
    var cityID = $(this).val();
    if(cityID){
        $.ajax({
            type:'POST',
            url:'ajaxData.php',
            data:{city_id: cityID},
            dataType:'html',
            success:function(html){
                $('#zipcode').html(html);
                console.log(html);
            },
            // 新增错误回调，打印调试信息
            error:function(xhr, status, error){
                console.log("请求出错:", error);
                console.log("服务器响应:", xhr.responseText);
            }
        });
    }else{
        $('#zipcode').html('<option value="">Select city first</option>');
    }
});

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