Limit results in PHP using while loop

Question

I have a list of returned subcategories. I only have access to the template display and not to the MySQL query so no, I can't limit the query.

Right now all the results are returned. I would like to limit the list to 5, and then add a "more" link if there are more than 5 results.

I know I did this wrong because I don't think count is actually tied to the foreach:

<ul class="sub-categories">
    <?php
    while (count($category->getChildren()) <= 5) { // line I added for while loop
        foreach ($category->getChildren() as $child) {
            if (!$child->totalItemCount())
                continue;

            $link = $this->app->route->category($child);
            $item_count = ($this->params->get('template.show_sub_categories_item_count')) ? ' <span>('.$child->totalItemCount().')</span>' : '';
                echo '<li><a href="'.$link.'" title="'.$child->name.'">'.$child->name.'</a>'.$item_count.'</li>';
        }
    } // line I added for while loop
    ?>
</ul>

0b10011 · Accepted Answer · 2012-07-19 17:42:17Z

1

Keep track within the foreach and break; when you've reached the limit:

<ul class="sub-categories">
    <?php
        $i = 0;
        foreach ($category->getChildren() as $child) {
            if (!$child->totalItemCount()) continue;
            $i++; if($i>5) break;
            $link = $this->app->route->category($child);
            $item_count = ($this->params->get('template.show_sub_categories_item_count')) ? ' <span>('.$child->totalItemCount().')</span>' : '';
            echo '<li><a href="'.$link.'" title="'.$child->name.'">'.$child->name.'</a>'.$item_count.'</li>';
        }
    ?>
</ul>

edited Jul 19, 2012 at 17:42

answered Jul 19, 2012 at 17:08

0b10011

18.9k4 gold badges69 silver badges90 bronze badges

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

4 Comments

liz Over a year ago

which is considered "better form" and why?

Eric Robinson Over a year ago

normally I would use a for loop instead of a foreach or while when you need to iterate through objects.

0b10011 Over a year ago

@liz, you may want to move the increment after the if (!$child->totalItemCount()) continue; line, so you always have 5 results.

0b10011 Over a year ago

@liz, sorry about that, I was just throwing out code and didn't think about it too much. The second solution wouldn't work because it loops through all of the items before it tests the while expression again.

Collectives™ on Stack Overflow

Limit results in PHP using while loop

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related