How to get td data from a table in PHP

Question

I am currently stuck at this problem right now where I don't seem to have any idea how to implement this. I have this table which is populated from a csv file in php and I want to get the data logged in order to calculate the daylight hours.

How can I get the data from the td "dateLogged", I did that in jquery before using children but I do not seem to be able to do that in php

//print out uploaded file.csv
            echo "<html><body><table BORDER=1>\n\n";
            echo "  <tr><th>AvgCrown</th><th>MinCrown</th><th>MaxCrown</th><th>dateLogged</th><th>DaylightHours</th></tr>";
            $f = fopen("./uploads/" . $_FILES["uploadedfile"]["name"], "r");

        while (($line = fgetcsv($f)) !== false) {
                echo "<tr>";
                foreach ($line as $cell) {
                        echo "<td>" . htmlspecialchars($cell) . "</td>";
                }
                echo "<td>" . calcDaylight() . "</td>";

                echo "<tr>\n"; 


        }
        fclose($f);
        echo "\n</table></body></html>";

Here is a sample how the table looks like

Here is a sample how the table looks like Any help will be most welcome.

I think you are better off parsing the table with the CSV rather than trying to parse the HTML. If you had to parse the HTML, you would need to split the contents between each and return the content inside. Check out http://stackoverflow.com/questions/3966033/extract-content-from-each-first-td-in-a-table if it helps! — Ben Ashton, Jun 28 '12 at 19:44

score 1 · Accepted Answer · answered Jun 28 '12 at 19:57

There's no need to parse the HTML if you can just grab the data while you're generating it. Something like this should be all you need:

while (($line = fgetcsv($f)) !== false) {
    echo "<tr>";
    foreach ($line as $cell) {
        // Save the value before you output
        $lastColValue = htmlspecialchars($cell);
        echo "<td>" . $lastColValue . "</td>";
    }
    // If you want to store all log dates in an array:
    $logDates[] = $lastColValue;
    // Or if you want to do something with that value in calcDaylight:
    echo "<td>" . calcDaylight( $lastColValue ) . "</td>";
    echo "<tr>\n"; 
}
fclose($f);

Incidentally, if you do find you need to parse the HTML and are only familiar with jQuery, this library may strike your fancy:

http://code.google.com/p/phpquery/

score 1 · Answer 2 · answered Jun 28 '12 at 20:10

this?

while (($line = fgetcsv($f)) !== false) {
   echo "<tr>";
   foreach ($line as $cell) {
      echo "<td>".htmlspecialchars($cell)."</td>";
   }
   echo "<td>" . calcDaylight( $cell[3] ) . "</td>";
   echo "<tr>\n"; 
}

i might be wrong but 4th column is the field you want, no?

How to get td data from a table in PHP

2 Answers2