Parsing an entire html table

[soltek]

Hello again,

 

I'm trying to scrape a table from another website using preg_match, especifically, using this code:

<?php 
$data = file_get_contents('http://tvcountdown.com/index.php');
$regex = '/[color=red]<table class="episode_list_table">[/color] (.+?) [color=red]</table>[/color]/';
preg_match($regex,$data,$match);
var_dump($match); 
echo $match[0];
?>

 

Heres the thing. It doesnt work 

I think it's because the first and second anchors are html tags, 'cause if I parse some other stuff without any tag, there's no problemo.

 

Any hints, mates?

Thanks

[BlueSkyIS]

if you are actually looking for [ and ], you'll need to escape them since they are special reg-ex characters. the same goes for backslash, if you are using it as your open/close delimiters. so your regex should be more like

 

$regex = '/\[color=red\]<table class="episode_list_table">\[/color\] (.+?) \[color=red\]<\/table>\[\/color\]/';

[soltek]

Oh I got it! Dumb me.

 

Now I'm not getting any warning, though, the array is still giving me nothing but «array(0) { } ».

I'm using this:

<?php 
$data = file_get_contents('http://tvcountdown.com/index.php');
$regex = '/<table class="episode_list_table" style="width:848px;margin-top:6px">  (.+?) <\/table>/';
preg_match($regex,$data,$match);
var_dump($match); 
echo $match[1];
?>

 

Maybe I'm doing something else wrong. I wanted to scrape evertything from <table class="episode_list_table" style="width:848px;margin-top:6px"> to </table>.

 

 

I'm seeing the source of http://tvcountdown.com/index.php and that data is there :s

<table class="episode_list_table" style="width:848px;margin-top:6px"> 
<tr> 
    <td class="c1 hr">Show</td> 
    <td class="c2 hr">Ep</td> 
    <td class="c3 hr">Title</td> 
    <td class="c4 hr">Countdown</td> 
    <td class="c5 hr" id="air_time_header"><div>Airtime (local)</div></td> 
[...]
<td class="c3"><a href="http://www.tvrage.com/Conan/episodes/1064999912">Jason Segel, Reggie Watts</a></td><td class="c4"><div id="c442_S01E28"></div></td><td class="c5"><div id="cc442_S01E28"></div></td></tr></table>

 

[soltek]

Any one? 

[johnny86]

preg_match('#<table class="episode_list_table"[^>]+>([\w\W]*)</table>#i', file_get_contents('http://tvcountdown.com/index.php'), $match);

 

Try it =)

[johnny86]

Woops, tried that myself. This works:

preg_match('#<table class="episode_list_table"[^>]+>[\w\W]*?</table>#i', file_get_contents('http://tvcountdown.com/index.php'), $match);

[soltek]

Great, now 'I' got it parsed. Thanks!

 

Is there any way to do this? I'm getting an error:

 

[color=red]$url = http://tvcountdown.com/index.php;[/color]
preg_match('#<table class="episode_list_table"[^>]+>[\w\W]*?</table>#i', file_get_contents('[color=red]$url[/color]'), $match);

 

 

[johnny86]

What do you exactly want to do? Turn all text red in that table or what? Because then you have to go trough the whole table and make <td style="color: red"> or give them id="red" and then apply #red to your sites stylesheet.

 

But what do you want to do exactly? =)

[soltek]

What do you exactly want to do? Turn all text red in that table or what? Because then you have to go trough the whole table and make <td style="color: red"> or give them id="red" and then apply #red to your sites stylesheet.

 

But what do you want to do exactly? =)

 

Sorry, I didnt noticed that BBcode couldnt be used inside the code tag.

The red parts were just to highlight what I intented to do.

 

 

$url = http://tvcountdown.com/index.php;
preg_match('#<table class="episode_list_table"[^>]+>[\w\W]*?</table>#i', file_get_contents('$url'), $match);

 

 

 

 

 

[johnny86]

You asked me to read your last reply on this topic.. So do you need some more help for this matter? Please give me some specific information on what you want to do and what are the problems related to that. Thanks =)

[laffin]

I think he's trying to scrape the page with the info from the tables.

the problem I seen was that the final 2 columns (countdown and aittime) are done via a javascript.

[soltek]

Everything is working nicely, but I wanted to change this part:

 

preg_match('#<table class="episode_list_table"[^>]+>[\w\W]*?</table>#i', file_get_contents('http://tvcountdown.com/index.php'), $match);

 

to something like this:

 

$url = http://tvcountdown.com/index.php;

preg_match('#<table class="episode_list_table"[^>]+>[\w\W]*?</table>#i', file_get_contents('$url'), $match);

 

 

I tried that, but it didnt work very well 

Thanks for passing by.

[johnny86]

$url = "http://tvcountdown.com/index.php";

preg_match('#<table class="episode_list_table"[^>]+>[\w\W]*?</table>#i', file_get_contents($url), $match);

 

You were trying to load string '$url' not http://tvcountdown.com/index.php.