图片上传后仅存服务器目录，网页与数据库无显示问题求助

我点击上传图片后，URL提示上传成功，图片也已保存到服务器的uploads文件夹目录中，但网页和数据库里都看不到该图片。我已尝试修改代码、刷新数据库，且确认数据库连接正常、CSS无问题，但仍未找到问题根源。

相关页面代码如下：

account.php（前端页面） #

<?php
session_start();
include_once "safe-header.php";
include_once "serverside/database-server.php";

if (isset($_SESSION['useremail']) && !empty($_SESSION['useremail'])) {
    $useremail = $_SESSION['useremail'];
} else {
    $useremail = 'User';
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <link rel="stylesheet" href="Css/account.css">
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Alternative Account Page</title>
</head>
<body>
    
<div class="upload-container">
    <p class="useremail">Welcome, <?php echo htmlspecialchars($useremail); ?></p>
    <div class="account-options">
        <a href="update-profile.php" class="update-profile">Update Profile</a>
        <a href="serverside/logout-server.php" class="logout-btn">Logout</a>
    </div>
    <div>  
    <?php
    $userId = $_SESSION['userid'] ?? null;
    $sql = "SELECT image FROM profile WHERE usersId = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $userId);
    $stmt->execute();
    $result = $stmt->get_result();
    $row = $result->fetch_assoc();

    if ($row && !empty($row['image'])) {
        echo '<img src="' . $row['image'] . '">';
    } else {
        echo "<p>Nothing here.</p>";
    }
    ?>
          <form action="serverside/profile-upload.php" method="post" enctype="multipart/form-data">
            <label for="profile-image">Select Image</label>
            <input type="file" name="profile-image">
            <button type="submit" name="upload-btn">Upload Image</button>
          </form>
    </div>
</div>

<?php
include_once "footer.php";
?>

profile-upload.php（后端处理页面） #

<?php
session_start();
require "database-server.php";

if (isset($_POST['upload-btn'])) {
    $validExt = ['jpg', 'jpeg', 'png'];
    $ext = strtolower(pathinfo($_FILES['profile-image']['name'], PATHINFO_EXTENSION));

    if (in_array($ext, $validExt)) {
        $location = "../uploads/";
        $target = $location . uniqid() . '.' . $ext;

    if (move_uploaded_file($_FILES['profile-image']['tmp_name'], $target)) {
        $userId = $_SESSION['userid'];
        $sql = "UPDATE profile SET image = ? WHERE usersId = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("si", $target, $userId);
        $stmt->execute();
        $stmt->close();

        header("location: ../account.php?success=imageuploaded");
        exit();
    } else {
        header("location: ../account.php?error=imagecantbeuploaded");
        exit();
    }
} else {
    header("location: ../account.php?error=cannotusethisfiletype");
    exit();
}
} else {
    header("location: ../account.php");
    exit();
}

问题排查与解决方案 #

1. 核心问题：数据库更新逻辑缺陷+路径错误 #

• 当前代码执行UPDATE后未验证是否成功，若用户在profile表中无对应记录，UPDATE不会插入新数据，导致数据库无图片路径
• 存入数据库的../uploads/xxx.jpg是相对于后端脚本的路径，前端页面在根目录无法解析该路径，导致图片加载失败

修复后的后端核心代码：

// 替换profile-upload.php中文件上传后的处理逻辑
if (move_uploaded_file($_FILES['profile-image']['tmp_name'], $target)) {
    // 检查用户ID是否有效
    if (!isset($_SESSION['userid']) || empty($_SESSION['userid'])) {
        header("location: ../account.php?error=nouserid");
        exit();
    }
    $userId = $_SESSION['userid'];

    // 检查用户是否已有profile记录
    $checkStmt = $conn->prepare("SELECT usersId FROM profile WHERE usersId = ?");
    $checkStmt->bind_param("i", $userId);
    $checkStmt->execute();
    $checkResult = $checkStmt->get_result();

    // 存储相对于网站根目录的路径，适配前端访问
    $dbPath = "uploads/" . basename($target);

    // 无记录则插入，有记录则更新
    if ($checkResult->num_rows > 0) {
        $sql = "UPDATE profile SET image = ? WHERE usersId = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("si", $dbPath, $userId);
    } else {
        $sql = "INSERT INTO profile (usersId, image) VALUES (?, ?)";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("is", $userId, $dbPath);
    }

    // 执行并验证数据库操作结果
    if ($stmt->execute()) {
        header("location: ../account.php?success=imageuploaded");
        exit();
    } else {
        error_log("数据库操作失败: " . $conn->error);
        header("location: ../account.php?error=databaseerror");
        exit();
    }
}

2. 辅助调试建议 #

• 直接在数据库执行SELECT image FROM profile WHERE usersId = [你的用户ID]，确认路径是否正确存入
• 查看前端页面图片元素的src属性，检查路径是否可访问
• 开启PHP错误日志，捕获未显示的数据库或文件操作错误

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