HTML File extract and array handling ...

[Theberge43]

Hi, I'm not a PHP programmer at all and I've been looking for an answer for my problem :

I have an HTML file from which I want to extract part of the info :

Here is the link to the file : http://qcfl.ehmqc.com/includes/rosters/scoring.html

I'd like to extract only the first 5 lines of the first table (actually columns #2, 3 4, 5, 6 & 7 of the first 5 lines).

I know it's possible to extract the whole file into an array with :

$information = file('http://qcfl.ehmqc.com/include/rosters/scoring.html');
foreach ($information as $ligne) {
	echo $ligne;

But I don't know how to select part of the file at all ... thanks in advance !

[mjax]

I took some time writing this code for you. It extracts the complete first table into a PHP array. You could apply this mechanism to every other table in the file as well:

<?
$html = file_get_contents('http://qcfl.ehmqc.com/include/rosters/scoring.html');

$data = array();

if(preg_match('/(<h3>.*LEAGUE SCORING LEADERS.*<table width=600.*<\/table>)/Uis', $html, $matches)) {
	$table = $matches[1];

$rows = array_slice(explode('</tr>', $table), 1, -1);

for($i_row = 0 ; $i_row < count($rows) ; $i_row++) {

	$cols = array_splice(explode('</td>', $rows[$i_row]), 0, -1);

	for($i_col = 0 ; $i_col < count($cols) ; $i_col++) {
		$data[$i_row][$i_col] = trim(strip_tags($cols[$i_col]));
	}
}

echo 'Extracted data:<br>'.print_r($data, true);
}
?>