function fetch_rss_feeds() {
global $wpdb;
$feeds = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}post_generator_feeds");
foreach ($feeds as $feed) {
include_once(ABSPATH . WPINC . '/feed.php');
$rss = fetch_feed($feed->feed_url);
if (!is_wp_error($rss)) {
$items = $rss->get_items();
foreach ($items as $item) {
$title = $item->get_title();
$content = $item->get_content();
$author = $item->get_author() ? $item->get_author()->get_name() : 'Unknown';
$insert_result = $wpdb->insert(
$wpdb->prefix . 'post_generator_content',
[
'source_id' => $feed->id,
'title' => $title,
'content' => $content,
'author' => $author,
'date' => $item->get_date('Y-m-d H:i:s')
],
['%d', '%s', '%s', '%s', '%s']
);
if ($insert_result === false) {
error_log('Error inserting content for feed ID ' . $feed->id);
}
}
}
}
}
Shania Twain News Today » Yours Truly
