php - 在 foreach 查询中查找最后一行

Question

我怎么能找到最后一篇文章而不把<hr>在它下面？

<?php foreach($db->query("SELECT * FROM news") as $row): ?>
<div class="NewsHeadline">
<div class="NewsDate"><?php echo $date; ?> - </div>
<div class="NewsTitle"><?php echo $title; ?></div>
</div>

<div class="NewsBody">
<?php echo $body; ?>
</div>

<hr>
<?php endforeach ?>

Answer 1

设置一个等于 1 的计数器，它每轮递增，并检查它是否等于返回的 $query 数组的 count()。如果是，则您已进入最后一轮!

<?php 
    $counter = 1; 
    $total = count($db->query("SELECT * FROM news"));
?>
<?php foreach($db->query("SELECT * FROM news") as $row): ?>
    <div class="NewsHeadline">
        <div class="NewsDate"><?php echo $date; ?> - </div>
        <div class="NewsTitle"><?php echo $title; ?></div>
    </div>

    <div class="NewsBody">
        <?php echo $body; ?>
    </div>
    <?php if($counter != $total){
    ?>
        <hr>
    <?php
    }

   ?>

<?php $counter++; ?>
<?php endforeach ?>