PARSE HTML

[kidgeek_dfw]

Ok I have a site coming over to me that was originally done as a static web site...

Tons of tables of data on multiple pages.
The only good thing is that each field of data has a specific class in the <td> cell...

so for example: class="phone" would be the phone field...

Is there some way I can spider all these pages and collect the data into MySql? I really don't want to manually enter 10,000 rows of data... WHOA!

Thanks,

KidGeek

[Weedpacket]

Looping through each page, you'd probably find using preg_match() to be the most convenient method

Getting the contents of a cell of class="phone":

#<(\w+)[^>]*class\s*=\s*"phone"[^>]*>(.*?)</\\1>#s

And if you call the array collecting the matches $match, the contents of the cell are in $match[2].

[kidgeek_dfw]

ok now I feel like an idiot...

I've tried that a hundred ways and I can't get it to work...
Must be the long hours... needith sleepith..

[icaro]

i do hate this regexp strings - cause i cant understand it :glare:

in your case i would use the good and old brute force:

<td width="anything" colspan="whatever" class="phone">123123</td>
<td width="anything" colspan="whatever" class="state">zz</td>

use

$aFile = file('somefile.html');

for ($i=0;$i<count($aFile); $i++) {
  $aParts = explode('class="', $aFile[$i]);
  if (!aParts[1]) {
    // There is no such string in this line
    continue;  

  }
  // now $aParts[1] contains phone">123123</td>
  $aParts = explode('"', $aParts[1]);
  // now $aParts[0] contains phone
  $sColName = $aParts[0];
  // and $aParts[1] contains >123123</td>
  $aParts = explode('>', $aParts[1]);
  // $aParts[1] is 123123</td>
  $aParts = explode('<', $aParts[1]);
  $sValue = $aParts[0]; // wich contains 123123

  echo $sColName . ' is ' . $sValue . '<br>';
}

it may return:
phone is 123123
state is zz

good luck!

[kidgeek_dfw]

aaahhh yeah.... That's what I'm looking for....

Thank you very much icaro

😃