基于登录用户权限动态输出项目关联图片的技术咨询

Got it, let's walk through how to replace those fixed image paths with dynamic variables that pull the right images based on the logged-in user's permissions and associated projects. Here's a practical breakdown:

1. First, map users to their projects & images #

You need a way to link each user (and their permission level) to their specific projects and corresponding images. You can use an array for small-scale setups, or a database for larger apps.

Example with an array (quick setup): #

// User -> Projects -> Image Path mapping
$userProjectImages = [
    'Test' => [
        'Community Sports Hall' => 'sporthal_test.jpg',
        'Downtown Library' => 'library_test.jpg',
        'City Park Renovation' => 'park_test.jpg',
        'Public Pool Upgrade' => 'pool_test.jpg'
    ],
    'Admin' => [
        'All City Infrastructure' => 'infra_admin.jpg',
        'Budget Planning Dashboard' => 'budget_admin.jpg'
        // Add more admin-specific projects/images here
    ]
    // Add other users and their mappings as needed
];

2. Fetch the logged-in user & validate their access #

Assuming you already have the logged-in username stored (like in a session), grab that value and check if they have associated projects:

// Get the logged-in username (adjust this to match your auth system)
$name = $_SESSION['logged_in_user'];

// Check if the user has configured projects/images
if (isset($userProjectImages[$name])) {
    $userAssignedProjects = $userProjectImages[$name];
} else {
    // Fallback for users with no permissions or missing config
    $userAssignedProjects = ['Default Project' => 'default_image.jpg'];
}

3. Replace fixed images with dynamic variables #

Now loop through the user's projects and output each associated image instead of the static sporthal.jpg:

// Loop through projects and render images dynamically
foreach ($userAssignedProjects as $projectTitle => $imagePath) {
    echo "<h4>$projectTitle</h4>";
    // Output the image using the dynamic path variable
    echo "<img src='/your-image-directory/$imagePath' alt='$projectTitle' />";
}

For larger apps: Use a database setup #

If you have lots of users/projects, a database is more scalable. Create 3 linked tables:

• users: Stores user ID, username, permission_level
• projects: Stores project ID, project_name, required_permission
• project_images: Stores project ID, image_file_path

Then query the data with a JOIN (use prepared statements to avoid SQL injection!):

SELECT p.project_name, pi.image_file_path
FROM users u
JOIN projects p ON u.permission_level = p.required_permission
JOIN project_images pi ON p.project_id = pi.project_id
WHERE u.username = ? -- Use a prepared statement placeholder here

Then in your code, loop through the query results to render each project's image just like the array example.

Quick notes to avoid headaches: #

• Make sure all image files are stored in a consistent directory (like /public/assets/images/) so your dynamic paths work correctly
• Handle edge cases: What if a user has no projects? Or an image file is missing? Add fallback logic to avoid broken images or errors
• Always sanitize user input (especially when using databases) to prevent security risks

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