read html table with php

j_70

Any suggestions on how to read an html table with PHP and parse it. I have numerous web pages, each containing one html table and with one .gif graph. I want to parse the html table and insert as a record into mysql. Unfortunately, it is not in XML which would make this easier. TIA.

Installer

If it's a simple, basic html table, this code will put all the text in the cells into a comma-delimited file, one row per line. Then you can use file(), explode() and/or list(), and your query to do the rest.

$remote_url = 'http://example.com/page.html'; 
$local_file = 'whatever.txt'; 

$ch = curl_init($remote_url); 
curl_setopt($ch, CURLOPT_HEADER, 0); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
$str = curl_exec($ch); 
curl_close($ch); 

$table_start = strpos($str, '<table>'); 
$table_end = strpos($str, '</table>') + strlen('</table>'); 
$table_len = $table_end - $table_start; 
$table = substr($str, $table_start, $table_len);

$data = str_replace('</td>', ',', $table);
$data = str_replace(',</tr>', "\n", $data);
$data = strip_tags($data);

$fp = fopen($local_file, 'w'); 
fwrite($fp, $data); 
fclose($fp);