php: loop through a list of numbers

Question

I've got an array like so:

Array (
[0] => stdClass Object ( [ID] => 1 [user_id] => 1 [post_id] => 929,924,875,839,850,720,642,1109,917,935,911,1174,1173,1172,903,892,1189,865,1386 ) 
[1] => stdClass Object ( [ID] => 2 [user_id] => 75 [post_id] => 903,704,477,9,455 ) 
[2] => stdClass Object ( [ID] => 3 [user_id] => 78 [post_id] => 917,911 ) 
[3] => stdClass Object ( [ID] => 4 [user_id] => 80 [post_id] => 903,1109,642 )
)

I wrote a foreach loop to loop through each of the elements:

$apples = $wpdb->get_results("SELECT ID, user_id, post_id FROM table_name" );

foreach ( $apples as $apple ) 
    {
        $user_info = get_userdata($apple->user_id);
        $post_title = get_the_title($apple->post_id);

        echo '<ul><li>' . $user_info->user_login . '</li>';
        echo '<li>' . $post_title . '</li>';
        echo '</ul>';
    }

How do I loop through each of the ID's found in [post_id]? Right now it is only displaying the title of the first digit in [post_id]. I need it to loop through each of them, though. Any ideas?

Can you post the code for get_userdata asnd get_the_title ? — Moseleyi
– Moseleyi, Commented Dec 30, 2012 at 19:10

Jesperhag · Accepted Answer · 2012-12-30 19:17:21Z

2

Something like:

<?php
...
foreach( explode( ',', $apple->post_id ) as $post_id ) {
// Do your stuff
}

Would do

answered Dec 30, 2012 at 19:17

Jesperhag

3232 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Baba · Accepted Answer · 2012-12-30 19:19:27Z

0

You can try

foreach ( $apples as $apple ) {
    $user_info = get_userdata($apple->user_id);
    echo '<h4>' . $user_info->user_login . '<h4>';
    echo "<ul>";
    foreach ( explode(",", $apple->post_id) as $postID ) {
        printf('<li>%s</li>', get_the_title($postID));
    }
    echo '</ul>';
}

answered Dec 30, 2012 at 19:19

Baba

95.3k29 gold badges172 silver badges222 bronze badges

Collectives™ on Stack Overflow

php: loop through a list of numbers

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related