HTML table

[bundyxc]

I have 1,000+ rows of data that are all in the exact same format:

 

      <tr>
        <td>lastName, firstName</td>

        <td>email</td>

        <td>var1</td>

        <td>var2</td>
      </tr>

 

I need to be able to extract the data from that, so that I have five variables:

 

$lastName

$firstName

$email

$var1

$var2

 

How would I go about extracting this data? Is this a regex problem, or something that could just be solved with string functions? Thanks for your time.

[thebadbad]

So those variables should hold arrays, or..? Have a look at the output of this:

 

<?php
preg_match_all('~<tr>\s*<td>([^,]+), ([^<]+)</td>\s*<td>([^<]+)</td>\s*<td>([^<]+)</td>\s*<td>([^<]+)</td>\s*</tr>~', $html, $matches);
array_shift($matches);
echo '<pre>' . print_r($matches, true) . '</pre>';
?>

 

The regex pattern should be pretty straight forward if you have a look at a reference.