自定义函数获取商品图片在While循环中无法显示的问题求助

其他商品信息均可正常显示，仅图片无法加载。已将获取图片的自定义函数写入functions.php，通过config.php引入该文件，再在header.php中调用config.php实现函数全局可访问。

自定义获取图片函数代码 #

function get_featured_image($p_id) {
    global $con;

    // 从products表获取image_id
    $featured_image_query   = mysqli_query($con, "SELECT images_id FROM products WHERE id = $p_id");
    $featured_image         = mysqli_fetch_assoc($featured_image_query);

    if ($featured_image) {
        $image_id = $featured_image['images_id'];

        // 根据image_id从images表获取图片详情
        $image_query    = mysqli_query($con, "SELECT * FROM images WHERE image_id = $image_id");
        $image_data     = mysqli_fetch_assoc($image_query);

        if ($image_data) {
            return $image_data['file_name'];
        }
    }

    return ""; // 无图片时返回空字符串
}

图片展示循环代码 #

<?php
$productscount = 0;
while ($products = mysqli_fetch_object($product_query)) { 
$product_id = $products->id;
$featured_image = get_featured_image($product_id);   
?>
<a href="product_details.php?id=<?php echo $products->id; ?>"
 <img src="images/products/<?php echo $featured_image; ?>" class="img-fluid blur-up lazyload" alt="">
</a>
<?php } ?>

数据库表结构 #

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