StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17817392
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-23T17:48:14.513
FavoriteCount
0
LastActivityDate
2013-07-30T14:56:15.320
LastEditDate
2013-07-30T14:56:15.320
LastEditorUserId
605849
OwnerUserId
605849
ParentId
10498632
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>I've adapted a simple class based on the code found on this thread that now handles <code>colspan</code> and <code>rowspan</code>. Not heavily tested and I'm sure it could be optimized.</p> <p>Usage:</p> <pre><code>require_once('table2csv.php'); $table = '<table border="1"> <tr> <th colspan=2>Header 1</th> </tr> <tr> <td>row 1, cell 1</td> <td>row 1, cell 2</td> </tr> <tr> <td>row 2, cell 1</td> <td>row 2, cell 2</td> </tr> <tr> <td rowspan=2>top left row</td> <td>top right row</td> </tr> <tr> <td>bottom right</td> </tr> </table>'; table2csv($table,"sample.csv",true); </code></pre> <p>table2csv.php</p> <pre><code><?php //download @ http://simplehtmldom.sourceforge.net/ require_once('simple_html_dom.php'); $repeatContentIntoSpannedCells = false; //-------------------------------------------------------------------------------------------------------------------- function table2csv($rawHTML,$filename,$repeatContent) { //get rid of sups - they mess up the wmus for ($i=1; $i <= 20; $i++) { $rawHTML = str_replace("<sup>".$i."</sup>", "", $rawHTML); } global $repeatContentIntoSpannedCells; $html = str_get_html(trim($rawHTML)); $repeatContentIntoSpannedCells = $repeatContent; //we need to pre-initialize the array based on the size of the table (how many rows vs how many columns) //counting rows is easy $rowCount = count($html->find('tr')); //column counting is a bit trickier, we have to iterate through the rows and basically pull out the max found $colCount = 0; foreach ($html->find('tr') as $element) { $tempColCount = 0; foreach ($element->find('th') as $cell) { $tempColCount++; } if ($tempColCount == 0) { foreach ($element->find('td') as $cell) { $tempColCount++; } } if ($tempColCount > $colCount) $colCount = $tempColCount; } $mdTable = array(); for ($i=0; $i < $rowCount; $i++) { array_push($mdTable, array_fill(0, $colCount, NULL)); } //////////done predefining array $rowPos = 0; $fp = fopen($filename, "w"); foreach ($html->find('tr') as $element) { $colPos = 0; foreach ($element->find('th') as $cell) { if (strpos(trim($cell->class), 'actions') === false && strpos(trim($cell->class), 'checker') === false) { parseCell($cell,$mdTable,$rowPos,$colPos); } $colPos++; } foreach ($element->find('td') as $cell) { if (strpos(trim($cell->class), 'actions') === false && strpos(trim($cell->class), 'checker') === false) { parseCell($cell,$mdTable,$rowPos,$colPos); } $colPos++; } $rowPos++; } foreach ($mdTable as $key => $row) { //clean the data array_walk($row, "cleanCell"); fputcsv($fp, $row); } } function cleanCell(&$contents,$key) { $contents = trim($contents); //get rid of pesky &nbsp's (aka: non-breaking spaces) $contents = trim($contents,chr(0xC2).chr(0xA0)); $contents = str_replace("&nbsp;", "", $contents); } function parseCell(&$cell,&$mdTable,&$rowPos,&$colPos) { global $repeatContentIntoSpannedCells; //if data has already been set into the cell, skip it while (isset($mdTable[$rowPos][$colPos])) { $colPos++; } $mdTable[$rowPos][$colPos] = $cell->plaintext; if (isset($cell->rowspan)) { for ($i=1; $i <= ($cell->rowspan)-1; $i++) { $mdTable[$rowPos+$i][$colPos] = ($repeatContentIntoSpannedCells ? $cell->plaintext : ""); } } if (isset($cell->colspan)) { for ($i=1; $i <= ($cell->colspan)-1; $i++) { $colPos++; $mdTable[$rowPos][$colPos] = ($repeatContentIntoSpannedCells ? $cell->plaintext : ""); } } } ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POConverting HTML Table to a CSV automatically using PHP?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UScapikaw
UserOwnerUserId
1. UScapikaw
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.