Count the rows in a html table using php

Question

I am looping through a html file using htmldomparsing looking for a table e.g

foreach($html->find('table') as $table)
{
  foreach($table->find('tr') as $tr)
  {
    $count = count($tr);
    $test = explode(" ",$count);
    echo $count;
  }
 }

I am trying to count the number of rows in the table, but everytime I use the count function it returns: 1111111 etc.

When counting the rows , is there any way I can count each row and the count would increment rather than throw out "1111...." etc. Any ideas?

foreach($html->find('table') as $table){ foreach($table->find('tr') as $tr) { $count = count($tr); $test = explode(" ",$count); echo $count; } } — Elbento
– Elbento, Commented Mar 10, 2012 at 12:55
I am parsing using htmldom parsing the user submits a url into a form and it will then parse through the code looking for specific things for one of them I need to know how to get the number of rows in a table — Elbento
– Elbento, Commented Mar 10, 2012 at 12:56
It is doing what I said above I have specific guidelines which I need to follow as part of my project and for one of the guidelines I need to count the number of rows in a html table and then the number of <th> tags to check if they need to include an id attribute in the <th tag> — Elbento
– Elbento, Commented Mar 10, 2012 at 13:08

Shiplu Mokaddim · Accepted Answer · 2012-03-10 13:13:00Z

4

This will work

foreach($html->find('table') as $table){ 
     // returns all the <tr> tag inside $table
     $all_trs = $table->find('tr');
     $count = count($all_trs);
     echo $count;
}

edited Mar 10, 2012 at 13:13

answered Mar 10, 2012 at 12:59

Shiplu Mokaddim

57.5k20 gold badges147 silver badges193 bronze badges

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

3 Comments

Elbento Over a year ago

Hi it seems to echo out ArrayArrayArray when I follow that code maybe its to do with HTMLDomParsing I don't know any clue

Shiplu Mokaddim Over a year ago

Oops!! It should be echo $count. Updated!

Elbento Over a year ago

Alrite that seems to do the job but can I ask another quick question if there are two tables in the html page is there any way I could do that loop for each table so say for the first table it will echo out 5 which is the number of rows and for the second it will echo 2

Jake · Accepted Answer · 2012-03-10 13:18:15Z

I was working on this for a while, but someone beat me to the punch. My solution is not elegant, but if you wanted to get away from using whatever library that is you could write the same thing natively.

function count_tr($data, $p=0)
{
//$data is a string that we assume to have some html in it.  
//$p is an indicator of where we are in the string
//$table_counts is an array of numRows
//$numRows is the number of rows we've counted this table
//$z is an indicator of where the next </table> tag is
$numRows = 0;
$table_counts = array();
$z = $p;
//First lets loop through it until we find a <table tag
while($p < strlen($data))
{
    //we will break under the condition that we have found the end of the data

    //If table is found, count its <tr tags.  Else, break
    if($p = strpos("<table", $data, $p) != FALSE)
    {
        //if we find a </table tag we want to know where it is.
        //else we need to stop execution.
        if($z = strpos("</table", $data, $p) != FALSE)
        {
            $numRows = 0;
            while($p < strlen($data))
            {
                //find the position of the next <tr
                if($p=strpos("<tr", $data, $p) != FALSE)
                {
                    //if the <tr tag is within this <table tag then we count it
                    //else we break to the next iteration
                    if($p<$z)
                    {
                        $numRows++;
                    }
                    else
                    {
                        //This will take us to the next <table iteration.
                        break;
                    }
                }
            }
            $table_counts[] = $numRows; 
        }
        else
        {
            die("The data is not formatted correctly.  That is beyond the scope of this snipped.  Please write a validation script.");
        }

    }
    else
    {
        die("There is not a <table tag.");
    }
}
}

Imrul Ahsan · Accepted Answer · 2018-08-12 18:51:26Z

0

If you have a database associated with the table then you can use the following code:

`$result = mysql_query("SELECT * FROM table1", $link); $num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n"; `

answered Aug 12, 2018 at 18:51

Imrul Ahsan

1

Comments

Moinak Ghosh · Accepted Answer · 2021-03-30 21:42:28Z

0

Why just not use a simple count variable for that?

$count = 0;
foreach($res as $value){
   $count++;
}

answered Mar 30, 2021 at 21:42

Moinak Ghosh

363 bronze badges

1 Comment

Scratte Over a year ago

I think it would be better if you did not use a rhetorical question when posting an Answer.

Collectives™ on Stack Overflow

Count the rows in a html table using php

4 Answers 4

3 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related