PHP foreach, if statement

Question

I have a table listing several elements, and their expiration date.

I need a function that says, "If the expiration date is later than today (for each element), then don't show".

It seems pretty simple, but I'm stuck!

Edit

<?php foreach($codes->result_array() as $row):?>
<tr>
    <td><?php print $row['description']?></td>
    <td><?php print $row['credits']?></td>
    <td><?php print $row['code']?></td>
    <td><? echo date("F jS, Y", strtotime($row['exp_date']));?></td>
    <td><? echo date("F jS, Y", strtotime($row['create_date']));?></td>
    <td>
        <!-- Icons -->
         <a href="<? echo base_url()?>admin/home/editCode/<?php print $row['id']?>" title="Edit"><img src="<? echo base_url()?>assets/images/icons/pencil.png" alt="Edit" /></a>
         <a href="<? echo base_url()?>admin/home/deleteCode/<?php print $row['id']?>" title="Delete" class="delete-code"><img src="<? echo base_url()?>assets/images/icons/cross.png" alt="Delete" /></a> 
    </td>
<?php endforeach;?>

Maybe you should show what you have so far. By table I assume you mean database table -- how are you storing that in your script? Generally people are not going to write your code for you if you can't at least show some details. — Erik
– Erik, Commented Jan 22, 2010 at 5:45

Ikke · Accepted Answer · 2010-01-22 05:45:02Z

7

This is a very basic example.

foreach($elements as $element)
{
    if(strtotime($element['expiration_date']) < now())
    {
        echo $element['expiration_date'];
    }
}

answered Jan 22, 2010 at 5:45

Ikke

102k23 gold badges101 silver badges121 bronze badges

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

Comments

Trav L · Accepted Answer · 2010-01-22 11:55:38Z

2

Seperate your concerns will help you see your question clearer.

In your controller:

<?php
$result_array = $codes->result_array();
$results = array();
$today = time();

foreach($codes->result_array() as $row)
{
    if(strtotime($row['exp_date']) <= $today)
    {//-- Keep this
        $results[] = $row;
    }
}
?>

In your view:

<?php foreach($results as $result): ?>
<tr>
    <td><?php print $result['description']?></td>
    <td><?php print $result['credits']?></td>
    <td><?php print $result['code']?></td>
    <td><? echo date("F jS, Y", strtotime($result['exp_date']));?></td>
    <td><? echo date("F jS, Y", strtotime($result['create_date']));?></td>
    <td>
        <!-- Icons -->
         <a href="<? echo base_url()?>admin/home/editCode/<?php print $result['id']?>" title="Edit"><img src="<? echo base_url()?>assets/images/icons/pencil.png" alt="Edit" /></a>
         <a href="<? echo base_url()?>admin/home/deleteCode/<?php print $result['id']?>" title="Delete" class="delete-code"><img src="<? echo base_url()?>assets/images/icons/cross.png" alt="Delete" /></a> 
    </td>
<?php endforeach;?>

edited Jan 22, 2010 at 11:55

answered Jan 22, 2010 at 6:27

Trav L

15.3k6 gold badges34 silver badges39 bronze badges

2 Comments

nikc.org Over a year ago

Side note: to get todays time, you don't need to use strtotime(). If you insist on getting the time for midnight today, you can use mktime(), and thus avoid the necessity for string parsing. But as the comparison is for dates, it shouldn't matter if the current time of day is included as well, as the date will be smaller or larger anyway, so in this case time() would've been sufficient.

Trav L Over a year ago

You right, that is redundant since it isn't necessary. Thanks for side note.

Sampson · Accepted Answer · 2010-01-22 05:44:12Z

1

Of course depending on what your expiration format is, the comparison below would change:

foreach ($items as $item) {
  if ($item["expiration"] < $today) {
    print $item["name"];
  }
}

answered Jan 22, 2010 at 5:44

Sampson

269k76 gold badges546 silver badges570 bronze badges

Comments

Ignacio Vazquez-Abrams · Accepted Answer · 2010-01-22 05:45:06Z

0

Here's something quick and probably non-working, but it'll give you an idea:

foreach($table as $entry)
{
  if($entry->expdate <= $today)
  {
    showentry($entry);
  }
}

answered Jan 22, 2010 at 5:45

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Comments

aslum · Accepted Answer · 2010-01-22 07:58:51Z

<?php 
// format this so that it's in the same format as your exp_date field.
$today = mktime(); 

foreach($codes->result_array() as $row):
// If you want it to show expired elements use a < instead of > in the if below.
if ($row['exp_date']>$today) {?>
<tr>
<td><?php print $row['description']?></td>
<td><?php print $row['credits']?></td>
<td><?php print $row['code']?></td>
<td><? echo date("F jS, Y", strtotime($row['exp_date']));?></td>
<td><? echo date("F jS, Y", strtotime($row['create_date']));?></td>
<td>
    <!-- Icons -->
     <a href="<? echo base_url()?>admin/home/editCode/<?php print $row['id']?>" title="Edit"><img src="<? echo base_url()?>assets/images/icons/pencil.png" alt="Edit" /></a>
     <a href="<? echo base_url()?>admin/home/deleteCode/<?php print $row['id']?>" title="Delete" class="delete-code"><img src="<? echo base_url()?>assets/images/icons/cross.png" alt="Delete" /></a> 
</td>
<?php }
else {
// If you want to display a blank table or warning or something, that woudl go here.
} endforeach;?>

neoMagic · Accepted Answer · 2023-08-15 18:46:44Z

0

You may use array_filter for a more elegant solution:

array_filter($codes->result_array(), function ($row) {
    return strtotime($row['exp_date']) <= time();
});

answered Aug 15, 2023 at 18:46

neoMagic

4304 silver badges10 bronze badges

Collectives™ on Stack Overflow

PHP foreach, if statement

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related