Shortcode returns only first value for a loop

Question

the shortcode given below returns only the first value:

function completed_quiz(){
    global $wpdb;
    $current_user = wp_get_current_user();
    $userID = $current_user->ID;
    $fetch22 = $wpdb->get_results("MySQL Query");
    foreach($fetch22 as $item){
    return "Quiz ID: $item->quiz_id Percentage: $item->result <br>";
    }
}   
add_shortcode('show_completed_quiz', 'completed_quiz');

However if I use "echo" it gives all the values. What am I missing here?

Vish · Accepted Answer · 2013-09-30 08:50:05Z

1

In foreach ,store all the value in some variable and then return that variable after foreach loop

    function completed_quiz(){
      global $wpdb;<br/>
       $current_user = wp_get_current_user();
       $userID = $current_user->ID;
       $fetch22 = $wpdb->get_results("MySQL Query");

       $returnVal ='';

       foreach($fetch22 as $item){

        $returnVal .= "Quiz ID: $item->quiz_id Percentage: $item->result <br>";

       }

       return $returnVal ;
     }

add_shortcode('show_completed_quiz', 'completed_quiz');

edited Sep 30, 2013 at 8:50

answered Sep 30, 2013 at 8:44

Vish

661 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

Shortcode returns only first value for a loop

1 Answer 1

In foreach ,store all the value in some variable and then return that variable after foreach loop

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

In foreach ,store all the value in some variable and then return that variable after foreach loop

Comments

Your Answer

Sign up or log in

Post as a guest

Related