fetchAll("SELECT * FROM {$db->table('channel')} WHERE channel_type = 1 AND is_show = 1 ORDER BY list_order ASC, id ASC"); // 当前选中栏目 $curChannelId = isset($_GET['channel_id']) ? intval($_GET['channel_id']) : 0; // 按栏目筛选文章 $sql = "SELECT a.*, c.channel_name FROM {$db->table('article')} a LEFT JOIN {$db->table('channel')} c ON a.channel_id=c.id WHERE a.status=1"; $params = []; if ($curChannelId > 0) { $sql .= " AND a.channel_id = ?"; $params[] = $curChannelId; } $sql .= " ORDER BY a.create_time DESC"; $allArticles = $db->fetchAll($sql, $params); ?>

暂无文章