ansaurus

Question

What's the most effective way to match out data from <table > with PHP?

Answer 1

+5 A:

Use an HTML or XML parser like DOMDocument or SimpleXML. Then you can simply traverse the DOM and fetch the data you want.

Gumbo 2009-09-15 07:52:48

Can both of them be used to parse HTML?

Shore 2009-09-15 08:04:31

@Shore: SimpleXML can only parse XML. But DOMDocument can parse both HTML and XML.

Gumbo 2009-09-15 08:21:08

Answer 2

+2 A:

You could use some simple regular expressions:

$values = array();
if (preg_match_all("/<tr>(.*?)<\/tr>/is", $html, $matches)) {
 foreach($matches[1] as $match) {
  if (preg_match_all("/<td[^>]*>([^<]+)<\/td>/is", $match, $tds))
   array_push($values, $tds[1]);
 }
}

var_dump($values);

It is a lot simpler when separate the patterns instead of one single large pattern.

bucabay 2009-09-15 17:13:12

Answer 3

+1 A:

You should try the lesser known PHP Simple HTML DOM Parser. It lets you do stuff like this:

// Create DOM from URL or file
$html = file_get_html('http://www.google.com/');

// Find all images
foreach($html->find('img') as $element)
       echo $element->src . '<br>';

// Find all links
foreach($html->find('a') as $element)
       echo $element->href . '<br>';

// Create DOM from string
$html = str_get_html('<div id="hello">Hello</div><div id="world">World</div>');

$html->find('div', 1)->class = 'bar';

$html->find('div[id=hello]', 0)->innertext = 'foo';

echo $html; // Output: <div id="hello">foo</div><div id="world" class="bar">World</div>

ryeguy 2009-09-15 17:17:54

ansaurus

tags:

views:

answers:

What's the most effective way to match out data from <table > with PHP?

related questions