prepare("SELECT * FROM entry_view WHERE language = ? ORDER BY created_at DESC LIMIT 20;"); $stmt->execute([$_REQUEST["l"]]); } else { $stmt = $db->prepare("SELECT * FROM entry_view WHERE created_at >= NOW() - INTERVAL 2 DAY ORDER BY created_at DESC;"); $stmt->execute([$_REQUEST["l"]]); } $result = $stmt->fetchAll(); $feed = new Feed(); $channel = new Channel(); $channel ->title("GHRSS") ->description("Trending Repos from Github") ->url( "https://www.maximilianmoehring.com/tools/ghrss/" ) ->pubDate(strtotime(date("r", time()))) ->lastBuildDate(strtotime(date("r", time()))) ->ttl(5) ->appendTo($feed); foreach($result as $item) { $item_out = new Item(); $item_out ->title($item["title"]) ->description( "

" . $item["synopsis"] . "
" . $item["language"] . " / " . $item["update_period"] . " / " . $item["stars"] . " Stars

" ) ->url($item["url"]) ->pubDate(strtotime(date($item["created_at"]))) ->author($item["owner"]) ->appendTo($channel); } echo $feed;