feedback_list.php

<?php
include 'includes/db.php';

// Fetch latest feedbacks
$sql = "SELECT f.*, u.profile_photo, u.name AS user_name
        FROM feedback f
        LEFT JOIN users u ON f.user_id = u.id
        ORDER BY f.created_at DESC";
$result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
 while ($row = $result->fetch_assoc()) {
  $photo = !empty($row['profile_photo']) ? $row['profile_photo'] : 'assets/default_user.png';
  $name = htmlspecialchars($row['user_name'] ?: $row['name']); // fallback to submitted name
  $comment = htmlspecialchars($row['comment']);
  $rating = (int)$row['rating'];
  $time = date('d M Y, H:i', strtotime($row['created_at']));
  $screenshot = !empty($row['screenshot']) ? "<img src='{$row['screenshot']}' class='mt-2 rounded-lg max-w-full border border-gray-300'>" : '';

  echo "
        <div class='bg-gray-100 dark:bg-gray-800 p-4 rounded-xl shadow-sm border border-gray-200 dark:border-gray-700 flex space-x-4'>
            <img src='{$photo}' class='w-12 h-12 rounded-full object-cover border-2 border-indigo-500'>
            <div class='flex-1'>
                <div class='flex justify-between items-center mb-1'>
                    <span class='font-semibold text-gray-800 dark:text-gray-200'>{$name}</span>
                    <span class='text-gray-500 text-sm'>{$time}</span>
                </div>
                <div class='flex space-x-1 text-amber-400 mb-2'>";
  for ($i = 1; $i <= 5; $i++) {
   if ($i <= $rating) echo "<i class='bx bxs-star'></i>";
   else echo "<i class='bx bxs-star text-gray-300 dark:text-gray-600'></i>";
  }
  echo "</div>
                <p class='text-gray-700 dark:text-gray-300'>{$comment}</p>
                {$screenshot}
            </div>
        </div>
        ";
 }
} else {
 echo "<p class='text-gray-500 italic'>No feedback yet. Be the first to submit!</p>";
}