How to return a foreach inside a shortcode

Question

I have the following code

 function stock_agenda() {

        $days = json_decode(file_get_contents('json_file'));

        unset($days[0]);

        return  '<table class="table">
   <thead>
     <tr>
      <th> Title </th>
      <th>Content</th>
      <th>Date</th>
     </tr>
    </thead>
    <tbody>
     '. foreach($days as $day){.'
      <tr>
       <td>'.$day[0].'</td>
       <td>'.$day[1].'</td>
       <td>'.$day[2].'</td>
      </tr>
     '. }.'
     </tbody>
</table>' ;
    }

How to I assign it to a shortcode? If I write foreach inside the return method I get an error.

Answer 1

As I said in the comment you can use buffering like this

function stock_agenda() {
    $days = json_decode(file_get_contents('json_file'));
    unset($days[0]);
    ob_start(); // start buffer
    ?>
    <table class="table">
        <thead>
            <tr>
                <th> Title </th>
                <th>Content</th>
                <th>Date</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach($days as $day) { ?>
            <tr>
                <td><?php echo $day[0]; ?></td>
                <td><?php echo $day[1]; ?></td>
                <td><?php echo $day[2]; ?></td>
            </tr>
            <?php } ?>
        </tbody>
    </table>
    <?php
    $output = ob_get_clean(); // set the buffer data to variable and clean the buffer
    return $output;
}

Answer 2

You can use:

function stock_agenda() {

    $days = json_decode(file_get_contents('json_file'));

    unset($days[0]);


    $include_variable = '';
    foreach($days as $day){
        $include_variable  .= <<<EOD
            <tr>
            <td>$day[0]</td>
            <td>$day[1]</td>
            <td>$day[2]</td>
            </tr>
            EOD;
    }

    $str = <<<EOD
        <table class="table">
        <thead>
        <tr>
        <th> Title </th>
        <th>Content</th>
        <th>Date</th>
        </tr>
        </thead>
        <tbody>
        $include_variable 
        </tbody>
        </table>
    EOD;

    return $str;
}