prepare('SELECT s.*, u.username AS uploader_name
FROM sounds s
LEFT JOIN users u ON u.id = s.uploaded_by
WHERE s.id = ?
');
$stmt->execute([$_GET['id']]);
$sound = $stmt->fetch(PDO::FETCH_ASSOC) ?: null;
} else {
$stmt = $db->prepare('SELECT * FROM sounds ORDER BY uploaded_at DESC');
$stmt->execute();
$sounds = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
?>
<?= INSTANCE_NAME ?>