getConnection();
// جلب إعدادات الموقع
try {
$query = "SELECT setting_key, setting_value FROM settings
WHERE setting_key IN ('site_name', 'logo_text')";
$stmt = $conn->prepare($query);
$stmt->execute();
$settings = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);
$site_name = $settings['site_name'] ?? 'Roz Skin';
$logo_text = $settings['logo_text'] ?? 'Roz Skin';
} catch (PDOException $e) {
$site_name = 'Roz Skin';
$logo_text = 'Roz Skin';
}
// الفلترة
$category = $_GET['category'] ?? '';
$search = $_GET['search'] ?? '';
$where = ["status = 'published'"];
$params = [];
if ($category) {
$where[] = "category = ?";
$params[] = $category;
}
if ($search) {
$where[] = "(title LIKE ? OR content LIKE ?)";
$params[] = "%$search%";
$params[] = "%$search%";
}
$where_clause = implode(' AND ', $where);
// جلب المنشورات
$stmt = $conn->prepare("SELECT * FROM posts WHERE $where_clause ORDER BY published_at DESC, created_at DESC");
$stmt->execute($params);
$posts = $stmt->fetchAll(PDO::FETCH_ASSOC);
// جلب الفئات
$categories = $conn->query("SELECT DISTINCT category FROM posts WHERE status = 'published' AND category IS NOT NULL AND category != '' ORDER BY category")->fetchAll(PDO::FETCH_COLUMN);
// إحصائيات
$total_posts = count($posts);
$total_categories = count($categories);
?>
روز فيد - Roz Feed | <?php echo htmlspecialchars($site_name); ?>
لا توجد منشورات
لم يتم نشر أي محتوى بعد