RSS feeds from database + associated data (skip NULL in MySQL output) (Page 4 of 4)

$query="SELECT id, firstname, username, rssfeed FROM members WHERE rssfeed!=''";
$result=mysql_query($query);

$feeds = array();
$id_array = array();
$first = array();

while ($cur_feed = mysql_fetch_assoc($result))
{
    $feeds[] = $cur_feed['rssfeed'];
    $id_array[] = $cur_feed['id'];
    $first[] = $cur_feed['firstname'];
}

// This array will hold the items we'll be grabbing.
$first_items = array();
 
// Let's go through the array, feed by feed, and store the items we want.

$ix = 0;

foreach ($feeds as $url)
{
    $user_id = $id_array[$ix];
    $firstname = $first[$ix];
    $ix++;

    // Use the long syntax
    $feed = new SimplePie();
    $feed->set_feed_url($url);
    $feed->init();

<?php

// Include the SimplePie library 
require_once 'simplepie.inc';
require 'shorten.php';

// Because we're using multiple feeds, let's just set the headers here.
header('Content-type:text/html; charset=utf-8');

// These are the feeds we want to use
mysql_connect(localhost,$db_username,$db_password);
@mysql_select_db($db_name) or die( "Unable to select database");

$query="SELECT id, firstname, username, rssfeed FROM members WHERE rssfeed!=''";
$result=mysql_query($query);

$feeds = array();

$i = 0;
$xf = 0;
$xi = 0;
$xx = 0;

while ($cur_feed = mysql_fetch_assoc($result))
{
    $feeds[$i][uid] = $cur_feed['id'];
    $feeds[$i][feed] = $cur_feed['rssfeed'];
    $feeds[$i][fname] = $cur_feed['firstname'];
    $feeds[$i][uname] = $cur_feed['username'];
    $i++;
}

// This array will hold the items we'll be grabbing.
$first_items = array();
 
// Let's go through the array, feed by feed, and store the items we want.

while ($xi <= $i)
{
    $url = $feeds[$xi][feed];
    
    // Use the long syntax
    $feed = new SimplePie();
    $feed->set_feed_url($url);
    $feed->init();

    // How many items per feed should we try to grab?
    $items_per_feed = 1;
 
    // As long as we're not trying to grab more items than the feed has, go through them one by one and add them to the array.
    for ($x = 0; $x < $feed->get_item_quantity($items_per_feed); $x++)
    {
        $first_items[$xx][feed] = $feed->get_item($x);
        $first_items[$xx][uid] = $feeds[$xi][uid];
        $first_items[$xx][fname] = $feeds[$xi][fname];
        $first_items[$xx][uname] = $feeds[$xi][uname];
        $xx++;
    }
    $xi++;
    // We're done with this feed, so let's release some memory.
    unset($feed);
}
 
/*
// We need to sort the items by date with a user-defined sorting function.  Since usort() won't accept "SimplePie::sort_items", we need to wrap it in a new function.
function sort_items($a, $b)
{
    return SimplePie::sort_items($a, $b);
}
 
// Now we can sort $first_items with our custom sorting function.
usort($first_items, "sort_items");
*/

$counter = 0;

while ($xf <= $xx)
{
    $item = $first_items[$xf][feed];
    $user_id = $first_items[$xf][uid];
    $firstname = $first_items[$xf][fname];
    $username = $first_items[$xf][uname];

    $feed = $item->get_feed();

    $counter++;
    $xf++;

    if ($counter >= 10)
    {
        break;
    }

    if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$user_id.'.jpg'))
    {
        $avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/'.$user_id.'.jpg" alt="" />';
    }
    else
    {
        $avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/nopicture.png" alt="" />';
    }

    $picture = '<div id="feedpicture"><a href="member.php?id='.$user_id.'" title="'.$firstname.'\'s Member Page">'.$avatar_field.'</a></div>';

// Begin the (X)HTML page.
?>

<h3><?php echo $picture; ?><a href="<?php echo $item->get_permalink(); ?>" target="_blank"><?php echo html_entity_decode($item->get_title(), ENT_QUOTES, 'UTF-8'); ?></a></h3>

<!-- get_content() prefers full content over summaries -->
<? echo trim(substr((str_replace("\n", ' ', str_replace("\r", ' ', strip_tags($item->get_description())))),0,300)); ?>
... <i>more</i></a><br />

<p class="footnote"><a href="member.php?id=<?php echo $user_id; ?>" title="<?php echo $firstname.'\'s Member Page'; ?>"><?php echo $username; ?></a> | <a href="<?php echo $feed->get_permalink(); ?>" target="_blank"><?php echo $feed->get_title(); ?></a> | <?php echo $item->get_date('M j, Y | g:i a'); ?></p><br />

<?php

}

?>

<?php
// Include the SimplePie library 
require_once 'simplepie.inc';
require 'shorten.php';

// Because we're using multiple feeds, let's just set the headers here.
header('Content-type:text/html; charset=utf-8');

// These are the feeds we want to use
mysql_connect(localhost,$db_username,$db_password);
@mysql_select_db($db_name) or die( "Unable to select database");

$query = "SELECT id, firstname, username, rssfeed FROM members WHERE rssfeed != ''";
$result = mysql_query($query);

$feeds = array();
$id_array = array();
$first = array();
$user = array();

$userinfo = array();

while ($cur_feed = mysql_fetch_assoc($result))
{
    $feeds[] = $cur_feed['rssfeed'];
    $userinfo[$cur_feed['rssfeed']] = $cur_feed;
}

// This array will hold the items we'll be grabbing.
$first_items = array();
 
// Let's go through the array, feed by feed, and store the items we want.
$ix = 0;

foreach ($feeds as $url)
{
    $user_id = $id_array[$ix];
    $firstname = $first[$ix];
    $username = $user[$ix];
    $ix++;

    // Use the long syntax
    $feed = new SimplePie();
    $feed->set_feed_url($url);
    $feed->init();

    // How many items per feed should we try to grab?
    $items_per_feed = 1;
 
// As long as we're not trying to grab more items than the feed has, go through them one by one and add them to the array.
    for ($x = 0; $x < $feed->get_item_quantity($items_per_feed); $x++)
    {
        $first_items[] = $feed->get_item($x);
    }
 
    // We're done with this feed, so let's release some memory.
    unset($feed);
}
 
// We need to sort the items by date with a user-defined sorting function.  Since usort() won't accept "SimplePie::sort_items", we need to wrap it in a new function.
function sort_items($a, $b)
{
    return SimplePie::sort_items($a, $b);
}
 
// Now we can sort $first_items with our custom sorting function.
usort($first_items, "sort_items");

$counter=0;
foreach($first_items as $item)
{
    $feed = $item->get_feed();
    $info = $userinfo[$item->feed->feed_url];
    
    $counter++;
    if($counter >= 10)
        break;
    
    if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.jpg'))
    $avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/'.$id.'.jpg" alt="" />';
    else
    $avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/nopicture.png" alt="" />';
    
    $picture = '<div id="feedpicture"><a href="member.php?id='.$user_id.'" title="'.$firstname.'\'s Member Page">'.$avatar_field.'</a></div>';
    
    // Begin the (X)HTML page.
    ?>
    
    <h3><?php echo $picture; ?><a href="<?php echo $item->get_permalink(); ?>" target="_blank"><?php echo html_entity_decode($item->get_title(), ENT_QUOTES, 'UTF-8'); ?></a></h3>
    
    <!-- get_content() prefers full content over summaries -->
    <? echo trim(substr((str_replace("\n", ' ', str_replace("\r", ' ', strip_tags($item->get_description())))),0,300)); ?>
    ... <i>more</i></a><br />
    
    <p class="footnote"><a href="member.php?id=<?php echo $info['id']; ?>" title="<?php echo $info['firstname'].'\'s Member Page'; ?>"><?php echo $info['username']; ?></a> | <a href="<?php echo $feed->get_permalink(); ?>" target="_blank"><?php echo $feed->get_title(); ?></a> | <?php echo $item->get_date('M j, Y | g:i a'); ?></p><br />
    <?php
}
?>

$userinfo[$cur_feed['rssfeed']] = $cur_feed;

$userinfo[the feed url][id]
$userinfo[the feed url][firstname]
$userinfo[the feed url][username]
$userinfo[the feed url][rssfeed]

$info = $userinfo[$item->feed->feed_url];