[Resolved] String functions . . .

DeadFly

I'm trying to take an HTML table, and extract the data inside the cells.

<tr bgcolor="#E1D8B9">
	<td class="HEADLINEGRAPH"><a href="/lineups/team/nyi/index.html">NY ISLANDERS</a></td>
	<td class="HEADLINEGRAPH" align="right">60</td>
	<td class="HEADLINEGRAPH" align="right">28</td>
	<td class="HEADLINEGRAPH" align="right">22</td>
	<td class="HEADLINEGRAPH" align="right">8</td>
	<td class="HEADLINEGRAPH" align="right">2</td>
	<td class="HEADLINEGRAPH" align="right" bgcolor="#AFB088">66</td>
</tr>

ie; I want to extract "NY ISLANDERS", "60", "28", etc. but I don't want any of the HTML.

Does anyone know an easy way to do that, which can be run through a loop to extract the similar cells from 30 different rows (where the team name matches one in the database).

jebster

[man]preg_match_all[/man]

DeadFly

i hate regular expressions !
🙁

jebster

There incredibly useful. Read a couple tutorials about them and the manual pages for each 😉

yelvington

If you familiarize yourself with the PHP string library, which is documented here:
http://www.php.net/strings

... you will discover the strip_tags() function.

DeadFly

Can i get some help with regular expressions ?

Here is the piece of code I want to pull out form a full website :
Test2 @ SportsPoolHQ.com

Now the website is very complex, and has quite a few tables. If I try to do a simple regex it grabs the data put from every damn table there is. Is there a way i could do a specific match for this table alone ?

The original site it is pulling from is :
NHL Standing @ NHL.com

jebster

What exactly do you want to do? Just grab that table? Grab the information out of the table? Grab the information and generate a html document that matches your site? If your wanting it to do it each time someone visits your page, NHL.com might not like that.

Also it might be easier to grab the info from their printer friendly version cause it would have less code.

DeadFly

Basically, I want to grab the information, and then insert/update my database, once a day.

DeadFly

Nevermind helping, this is obviously too difficult for me.
I'll find another way to do it.

Thanks for the other help though.
🙂