['accent'=>'#8B5E3C','bg'=>'#FFFBF2'],
'hijau' => ['accent'=>'#2D4A3E','bg'=>'#F2F7F4'],
'marun' => ['accent'=>'#6B2C3E','bg'=>'#FDF2F4'],
'biru' => ['accent'=>'#1E3A5F','bg'=>'#F2F6FB'],
'senja' => ['accent'=>'#8B5A2B','bg'=>'#FFFAF0']
];
$accent = $themes[$theme]['accent'] ?? '#8B5E3C';
$cats = $conn->query("SELECT * FROM categories ORDER BY id ASC");
$filter = $_GET['kategori'] ?? 'all';
$where = $filter != 'all' ? "WHERE c.slug='". $conn->real_escape_string($filter) ."' AND p.status='published'" : "WHERE p.status='published'";
$q = $conn->query("SELECT p.*, c.name as cat_name, c.slug as cat_slug, c.color as cat_color FROM posts p LEFT JOIN categories c ON p.category_id=c.id $where ORDER BY p.created_at DESC LIMIT 30");
$featured = $conn->query("SELECT p.*, c.name as cat_name FROM posts p LEFT JOIN categories c ON p.category_id=c.id WHERE p.status='published' ORDER BY p.views DESC LIMIT 4");
?>
Syamil.id - Tulisan yang Menemani Sepi | Khanif Pena