PHP count rows from foreach loop

Question

I'm using a "foreach" loop in PHP to create tables from my MySQL data

What I'm trying to achieve is to count the amount of rows being returned by the loop

The loop is creating new tables for each "machine" and fills the "contracts" as new rows but whenever I try to count the rows it returns the count from all tables together instead of only the a single one.

Here's my code:

<?php

foreach ($this->datatitle as $head) {

    $cards = 1;

    echo '<table id="cards" class="cards">';

    echo '<tr>';

    foreach ($this->datacount as $datacount) {

        echo '<td>' . $head->machine_text . ' ' . $head->machine_name . ' [' . $datacount->count . ']</td>';

    }

    echo '</tr>';
    echo '<tr>';
    echo '<td>';
    echo '<ul id="sortable" class="connectedSortable">';

    foreach ($this->data as $body) {

        if ($head->machine_text == $body->machine_text) {

            echo '<li class="ui-state-default">Auftrag: ' . $body->aufnr;
            echo '<br>' . $body->matnr . ' ' . $body->matxt;
            echo '<br>Menge ' . $body->gamng;
            echo '<br><br>';
            echo 'Start: ' . $body->gstrp;
            echo '<br>Ende: ' . $body->ssavd . '</li>';

            if ($cards++ == 10) {
                break;
            }

        } else {

        }

    }

    echo '</td>';
    echo '</tr>';
    echo '</table>';

}

?>

The $cards defines the amount of rows want to display, but i want to count the rows which aren't displayed aswell.

tl;dr create tables with foreach, want to count rows from single table

mbomb007 · Accepted Answer · 2022-09-16 19:42:11Z

4

Above youre foreach loop, define a counter.

$count = 0

Then in your foreach loop:

$count = $count + 1

After your foreach loop:

echo $count

Example:

<?php

foreach ($this->datatitle as $head) {

$count = 0;
$cards = 1;

echo '<table id="cards" class="cards">';

echo '<tr>';

foreach ($this->datacount as $datacount) {
    $count = $count + 1;
    echo '<td>' . $head->machine_text . ' ' . $head->machine_name . ' [' . $datacount->count . ']</td>';

}

echo '</tr>';
echo '<tr>';
echo '<td>';
echo '<ul id="sortable" class="connectedSortable">';

foreach ($this->data as $body) {

    if ($head->machine_text == $body->machine_text) {

        echo '<li class="ui-state-default">Auftrag: ' . $body->aufnr;
        echo '<br>' . $body->matnr . ' ' . $body->matxt;
        echo '<br>Menge ' . $body->gamng;
        echo '<br><br>';
        echo 'Start: ' . $body->gstrp;
        echo '<br>Ende: ' . $body->ssavd . '</li>';

        if ($cards++ == 10) {
            break;
        }

    } else {

    }

}

echo '</td>';
echo '</tr>';
echo '</table>';
echo $count;
}
?>

edited Sep 16, 2022 at 19:42

mbomb007

4,3913 gold badges51 silver badges79 bronze badges

answered Aug 17, 2014 at 23:11

Nick Prozee

2,9234 gold badges27 silver badges49 bronze badges

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

10 Comments

B0oMi Over a year ago

Thanks for your reply! I'm only getting the row count from all tables together that way instead of the count for each table individually

Nick Prozee Over a year ago

try the example, maybe you need to move the Count+1 were you need it

B0oMi Over a year ago

okay now it's looking really good, is it possible to echo out the count in the table header?

Nick Prozee Over a year ago

Sure, just place the 'echo $count' in the header where you need it

kiwixz Over a year ago

What about $count++;

|

Typewar · Accepted Answer · 2022-01-31 19:35:46Z

1

i think this will help.

<?php

$count = 0;

foreach ($names as $name){
    echo  "<td>".$count."</td>
           <td>".$name."</td>";

    $count += 1;
}

?>

edited Jan 31, 2022 at 19:35

Typewar

9931 gold badge18 silver badges34 bronze badges

answered Apr 12, 2017 at 15:21

Developer Kwame

1681 gold badge7 silver badges15 bronze badges

Collectives™ on Stack Overflow

PHP count rows from foreach loop

2 Answers 2

10 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related