query("
SELECT p.*,
(SELECT image_url FROM project_images WHERE project_id = p.id AND is_primary = 1 LIMIT 1) as primary_image,
GROUP_CONCAT(s.tech_name SEPARATOR ',') as stack
FROM projects p
LEFT JOIN project_stack s ON p.id = s.project_id
GROUP BY p.id
ORDER BY p.created_at DESC
");
$projects = $stmt->fetchAll(PDO::FETCH_ASSOC);
$projectsHtml = '';
foreach ($projects as $project) {
$img = htmlspecialchars($project['primary_image'] ?? 'https://images.unsplash.com/photo-1551033406-611cf9a28f67?q=80&w=1000');
$title = htmlspecialchars($project['title']);
$category = htmlspecialchars($project['category']);
$desc = htmlspecialchars($project['description']);
$slug = htmlspecialchars($project['slug']);
$stackHtml = '';
if (!empty($project['stack'])) {
$techs = explode(',', $project['stack']);
foreach ($techs as $tech) {
$stackHtml .= '' . htmlspecialchars($tech) . '';
}
}
$privateBadge = $project['is_private'] ? '🔒 Private
' : '';
// Link wrapper replaces click handler for crawler
$projectsHtml .= '
';
}
// Inject the HTML into the div
$targetDiv = '';
$html = str_replace($targetDiv, $targetDiv . "\n" . $projectsHtml, $html);
} catch (Exception $e) {
// If DB fails, output raw HTML to let JS take over gracefully
}
echo $html;