Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP Table into array
    primarykey
    data
    text
    <p>I´m trying to read a table from a HTML file into an array, I'm stuck. Any help would be appreciated.</p> <p>Every table element should be stored into 1 array value</p> <p>example: <code>$arr[1]= DER HE1 ges 1</code></p> <p>PHP</p> <pre><code>&lt;?php libxml_use_internal_errors(true); $i=0; // new dom object $dom = new DOMDocument(); //load the html $html = $dom-&gt;loadHTMLFile("106642new.html"); //discard white space $dom-&gt;preserveWhiteSpace = false; //the table by its tag name $tables = $dom-&gt;getElementsByTagName('table'); //get all rows from the table $rows = $tables-&gt;item(0)-&gt;getElementsByTagName('tr'); // $test = $tables-&gt;item(0)-&gt;getElementsByTagName('td'); // loop over the table rows foreach ($rows as $row) { // get each column by tag name $cols = $row-&gt;getElementsByTagName('td'); $i= $i + 1 ; $value = "Nummer: ".$i.": ".$cols-&gt;item(0)-&gt;nodeValue.PHP_EOL; // $value = "test: ".$i.": ".$cols-&gt;item(0)-&gt;nodeValue.PHP_EOL; $cols = array(1, 2, 3, 4, 5); echo $value; // $cols[$i] = $row; // echo the values //echo $cols-&gt;item(0)-&gt;nodeValue ; } ?&gt; </code></pre> <p>HTML:</p> <pre><code>&lt;body bgcolor="#FFFFFF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0"&gt; &lt;div align=left&gt; &lt;table BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%" height="100%"&gt; &lt;tr&gt;&lt;td valign="top"&gt;&amp;nbsp&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td valign="top"&gt; &lt;p font class="Header"&gt;Basisrooster schooljaar 2011 2012 (m.i.v. 12-09-11)&lt;/font&gt;&lt;/p&gt; &lt;br&gt;&lt;div font class="lNameHeader"&gt; &lt;/font&gt; &lt;/div&gt;&lt;table border=1&gt; &lt;tr class="AccentDark"&gt; &lt;td align="left" width="65" class="tableHeader"&gt;&lt;/td&gt; &lt;td align="center" width="auto" class="tableHeader"&gt;Maandag&lt;/td&gt; &lt;td align="center" width="auto" class="tableHeader"&gt;Dinsdag&lt;/td&gt; &lt;td align="center" width="auto" class="tableHeader"&gt;Woensdag&lt;/td&gt; &lt;td align="center" width="auto" class="tableHeader"&gt;Donderdag&lt;/td&gt; &lt;td align="center" width="auto" class="tableHeader"&gt;Vrijdag&lt;/td&gt; &lt;/tr&gt;&lt;tr&gt; &lt;td align="left" width="50" class="tableHeader"&gt;1e uur&lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;WAS&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE09&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;econ&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;5&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;WIK&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC17&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;biol&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;4&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;OTT&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC01&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;dutl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;6&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left" width="50" class="tableHeader"&gt;2e uur&lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;KEJ&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC02&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;wisA&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;3&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;BRT&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE05&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;netl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;OTT&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC01&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;dutl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;6&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;BAU&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HG01&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;lo&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;MET&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HD02&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;entl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left" width="50" class="tableHeader"&gt;3e uur&lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;WAS&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE07&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;econ&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;5&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;MET&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HD02&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;entl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;WAS&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE05&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;econ&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;5&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;BAU&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HG01&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;lo&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;KEJ&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC02&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;wisA&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;3&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left" width="50" class="tableHeader"&gt;4e uur&lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;DER&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE08&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;ges&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;1&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;KEJ&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC06&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;wisA&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;3&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;DER&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE10&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;ges&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;1&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;CHR&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HB15&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;ckv&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left" width="50" class="tableHeader"&gt;5e uur&lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;DOC&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE09&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;m&amp;o&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;2&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;MET&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HD02&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;entl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;BRT&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HE05&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;netl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;OTT&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC03&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;dutl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;6&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="left" width="50" class="tableHeader"&gt;6e uur&lt;/td&gt; &lt;td align="left" width="auto" class="tableCell"&gt;&lt;table border="0" cellpadding="0" cellspacing="0" &gt; &lt;tr&gt; &lt;td align="left" width="41" class="tableCell"&gt;OTT&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="75" class="tableCell"&gt;HC03&lt;/td&gt; &lt;td align="left" width="3" class="tableCell"&gt;&amp;nbsp&lt;/td&gt; &lt;td align="left" width="73" class="tableCell"&gt;dutl&lt;/td&gt; &lt;td align="left" width="9" class="tableCell"&gt;6&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload