What is the fastest way to convert html table to php array ?

Question

are there build in functions in latest versions of php specially designed to aid in this task ?

Answer 1

you could use the explode-function to turn the table cols and rows into arrays.

see: php explode

Answer 2

i dont know if this is the faster , but you can check this class (using preg_replace)

http://wonshik.com/snippet/Convert-HTML-Table-into-a-PHP-Array

Answer 3

If you want to convert the html-description of a table, here's how I would do it:

• remove all closing tags (</...>) ( http://php.net/manual/de/function.str-replace.php)
• split string at opening tags (<...>) using a regular expression ( http://php.net/manual/en/function.split.php)

You have to work out the details on your own, since I do not know if you want to handle different lines as subarrays or you want to merge all lines into one big array or something else.

Answer 4

Use a DOM parser like SimpleXML to split the HTML code into nodes, and walk through the nodes to build the array.

For broken/invalid HTML, SimpleHTMLDOM is more lenient (but it's not built in).

Answer 5

String replace and explode would work if the HTML code is clean and always the same, as soon as you have new attributes it will brake. So only dependable solution would be using regular expressions or XML/HTML parser. Check http://php.net/manual/en/book.dom.php

Answer 6

An alternative to using a native DOM parser could be using YQL. This way you dont have to do the actual parsing yourself. The YQL Web Service enables applications to query, filter, and combine data from different sources across the Internet.

For instance, to grab the HTML table with the class example given at

http://www.w3schools.com/html/html_tables.asp

you can do

$yql = 'http://tinyurl.com/yql-table-grab';
$yql = json_decode(file_get_contents($yql));
print_r( $yql->query->results );

I've deliberated shortened the URL so it does not mess up the answer. $yql actually links to the YQL API, adds some options and contains the query:

select * from html 
    where xpath="//table[@class='example']" 
    and url="http://www.w3schools.com/html/html_tables.asp"

YQL can return JSON and XML. I've made it return JSON and decoded this then, which then results in a nested structure of stdClass objects and Arrays (so it's not all arrays). You have to see if that fits your needs.

You try out the interactive YQL console to see how it works.