calculating difference between array values php

Question

I have this small section of code.

<?php foreach($last_activity as $activity) : ?>
<tr>
    <td><?= $activity['category'];?></td>
    <td><?= $activity['activity'];?></td>
    <td><?= $activity['datetime'];?></td>
    <td><?= $activity[''];?></td>
</tr>
<?php endforeach; ?>

This runs a loop populating table rows with data from query. What I want to be able to do providing possible this way...is in the final column in the row is calculate the difference between the datetime column in its present row with that of the row above.

is this possible (e.g by putting a snippet of php script in my final <td> column?

raina77ow · Accepted Answer · 2012-08-15 15:09:16Z

1

I suppose it can be done with something like this:

<?php $recent_datetime = null;
      foreach($last_activity as $activity): ?>
<tr>
    <td><?=$activity['category'];?></td>
    <td><?=$activity['activity'];?></td>
    <td><?=$activity['datetime'];?></td>
    <td><?= ($recent_datetime 
              ? $activity['datetime'] - $recent_datetime 
              : $activity['datetime'] );
         ?></td>
</tr>
<?php $recent_datetime = $activity['datetime']; endforeach; ?>

answered Aug 15, 2012 at 15:09

raina77ow

107k16 gold badges205 silver badges240 bronze badges

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

Collectives™ on Stack Overflow

calculating difference between array values php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related