ansaurus

Question

Answer 1

+4 A:

Maybe like this?

<?php $firstline=true; foreach ($products->result() as $row): ?>
    <?php if ($firstline) {
        $firstline=false;
    } else {
        echo '<div class="divider"></div>';
    }?>
    <h3><?= $row->header; ?></h3>
    <p><?= $row->teaser; ?> </p>
    <a href="">Read More</a>
<?php endforeach; ?>

thejh 2010-10-31 21:37:12

I want the div to show underneath every record except the last one.

Kory 2010-10-31 21:41:35

This is exactly what it does - you could also say that the div gets put over every record except the first one, it's basically the same.

thejh 2010-10-31 21:45:13

Ahh.. gotcha, thanks.

Kory 2010-10-31 21:48:03

Haha, clever. Putting the div _above_ the content.

kijin 2010-10-31 21:48:31

It's a clever solution indeed. I have always had problems with that, especially while pulling the content out of a MySQL database (I had to execute `SELECT COUNT(*)` first). Actually I've never thought about putting the separator over the content, instead of putting it under the content. Thanks ;)

rhino 2010-10-31 22:00:14

Answer 2

A:

<?php foreach ($products->result() as $row): ?>
    <h3><?= $row->header; ?></h3>
    <p><?= $row->teaser; ?> </p>
    <a href="">Read More</a>    

    <?php if($row!=end($products->result())
    <!-- DONT DISPLAY THIS LAST LINE IF ITS THE LAST RECORD -->
    <div class="divider"></div> 
    <?php } ?>  

 <?php endforeach; ?>

should do it

Ross 2010-10-31 21:40:33

This won't work if another row has the same value as the last row.

willell 2010-10-31 21:44:07

Answer 3

A:

Another way to do it:

<?php $results = $products->result();
      $count = count($results);
      $current = 0;
      foreach ($results as $row): ?>

    <h3><?= $row->header; ?></h3>
    <p><?= $row->teaser; ?> </p>
    <a href="">Read More</a>

    <?php if (++$current < $count): ?>
        <div class="divider"></div>   
    <?php endif; ?>

<?php endforeach; ?>

Technically, things like dividers should be done with CSS, using the :first-child and :last-child pseudo-classes. But IE doesn't support it :(

kijin 2010-10-31 21:47:12

I don't understand this code... how can `++$count<$count` EVER return true? __EDIT__: Ahh, you have probably made a mistake. I guess you meant `++$current`, not `++$count`...

rhino 2010-10-31 21:51:31

@rhino Yeah, that was a mistake. Fixed. Thanks.

kijin 2010-10-31 22:29:52

ansaurus

tags:

views:

answers:

Checking for last record in PHP

related questions