PHP 'json_decode' Working for First Item Only

Question

I'm decoding JSON format, my API Endpoint is https://api.reliableserver.host/api/recent_activities (No Auth)

I've already managed to display the values of the first item like this:

<?php
$url2 = "https://api.reliableserver.host/api/recent_activities";
$obj2 = json_decode(file_get_contents($url2), true);
?>

<tr class="css-xlbdcw">

    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: left;">
        <div class="vx_text-body-md" style="color: rgb(44, 46, 47); padding-top: 7px; padding-bottom: 7px;">
            <div role="button">
                <?php echo $obj2['data'][0]['activity_date']; ?>
            </div>
        </div>
    </td>

    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: left;">
    <div data-testid="verticalList">
        <a tabindex="0" href="/activity/payment/87J62844XL761054H"><?php echo $obj2['data'][0]['activity_title']; ?></a>
        <div style="color: rgb(44, 46, 47); font-size: 11px;"><?php echo $obj2['data'][0]['activity_status']; ?></div>
    </div>
    </td>

    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: right;">
        <div class="vx_text-body-md" style="color: rgb(44, 46, 47); padding-top: 7px; padding-bottom: 7px;">
            <div role="button"><?php echo $obj2['data'][0]['activity_amount']; ?></div>
        </div>
    </td>

</tr>

This is working for the first item, how do i make it go through each item using foreach - I tried but couldn't get it working.

Thanks

u_mulder · Accepted Answer · 2020-10-28 07:10:10Z

1

Iterate over $obj2['data']:

$url2 = "https://api.reliableserver.host/api/recent_activities";
$obj2 = json_decode(file_get_contents($url2), true);

foreach ($obj2['data'] as $item) {?>
<tr class="css-xlbdcw">

    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: left;">
        <div class="vx_text-body-md" style="color: rgb(44, 46, 47); padding-top: 7px; padding-bottom: 7px;">
            <div role="button">
                <?php echo $item['activity_date']; ?>
            </div>
        </div>
    </td>

    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: left;">
        <div data-testid="verticalList">
            <a tabindex="0" href="/activity/payment/87J62844XL761054H"><?php echo $item['activity_title']; ?></a>
            <div style="color: rgb(44, 46, 47); font-size: 11px;"><?php echo $item['activity_status']; ?></div>
        </div>
    </td>

    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: right;">
        <div class="vx_text-body-md" style="color: rgb(44, 46, 47); padding-top: 7px; padding-bottom: 7px;">
            <div role="button"><?php echo $item['activity_amount']; ?></div>
        </div>
    </td>
</tr>
<?php
}

answered Oct 28, 2020 at 7:10

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

2 Comments

Reliable Themes Over a year ago

superb, its working - ill accept the answer in 9 minutes as the system won't allow me now

STA Over a year ago

Ths answer is more accurate than the other one

jibsteroos · Accepted Answer · 2020-10-28 07:36:31Z

If you wanted to allow yourself flexibility in rendering items, you could use a filter array ($filter), as follows:

<?php
$response = file_get_contents('https://api.reliableserver.host/api/recent_activities');
$response = json_decode($response, true);
$filter = ['id', 'activity_amount']; // select which items to show
foreach ($response['data'] as $record) {
    echo '<tr class="css-xlbdcw">'; // open row
    foreach ($record as $key => $item) {
        if (in_array($key, $filter)) { // show filtered items only
            echo <<<HEREDOC
    <td style="width: unset; max-width: unset; padding: 5px 20px; text-align: left;">
        <div class="vx_text-body-md" style="color: rgb(44, 46, 47); padding-top: 7px; padding-bottom: 7px;">
            <div role="button">
                $item
            </div>
        </div>
    </td>
HEREDOC;
        }
    }
    echo '</tr>'; // close row
}

We use HEREDOC as it allows us to elegantly render HTML with variable(s) (e.g. $item) injected.

Collectives™ on Stack Overflow

PHP 'json_decode' Working for First Item Only

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related