StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16788048
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-28T09:05:48.693
FavoriteCount
0
LastActivityDate
2013-05-28T09:05:48.693
LastEditDate
LastEditorUserId
0
OwnerUserId
1355539
ParentId
16777767
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I cannot take credit for this solution. I was answered on another site by an 'expert.' However, I really feel that this topic is important enough to repost this solution on this 'stack' site. SOLUTION: <pre><code><?php define('TAB', "\t"); define('TAB2', "\t\t"); // Open the input file $file = fopen('lines.csv', 'rt'); // ignore the first line fgets($file); // Get the next line into an array splitting on the pipe $line = fgetcsv($file, 255, '|'); // set the initial section value $section = $line[0]; // Initialise batch array $current = array(); // Loop through all lines in the file do { // If this line contains a section that is not the same as the previous line then dump the last section if ($section != $line[0]) { dump_categories($current, $section); // Set our section flag to the next section $section = $line[0]; // Clear the array of batched items to dump $current = array(); } // Add the line to the batch $current[] = $line; } while($line = fgetcsv($file, 255, '|')); // Remember to dump batch that has built up dump_categories($current, $section); fclose($file); function dump_categories(& $lines, $section) { // Set our category flag $category = $lines[0][1]; // initialise batch array $current = array(); // Start a new seection echo '<ul class="section">' . PHP_EOL; echo TAB . '<li>' . $section . PHP_EOL; // If there are categories in this section then process them - don't want empty bullets here if (!empty($lines[0][1])) { foreach($lines as $l) { // if this is a new category then dump category and services for this category if ($category != $l[1]) { dump_services($current, $category); // set our category flag $category = $l[1]; // ... and clear the batch array $current = array(); } // add to batch $current[] = $l; } // and dump batched lines dump_services($current, $category); } echo TAB . '</li>' . PHP_EOL; echo '</ul>'; } // Services we assume is the end of the line so output the service if it exists. function dump_services(& $lines, $category) { echo TAB2 . '<ul class="category">' . PHP_EOL; echo TAB . TAB2 . '<li>' . $category . PHP_EOL; if (!empty($lines[0][2])) { echo TAB2 . TAB2 . '<ul class="service">' . PHP_EOL; foreach($lines as $l) { if (!empty($l)) { echo TAB . TAB2 . TAB2 . '<li>' . $l[2] . '</li>' . PHP_EOL; } } echo TAB2 . TAB2 . '</ul>' . PHP_EOL; } echo TAB . TAB2 . '</li>' . PHP_EOL; echo TAB2 . '</ul>' . PHP_EOL; } ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP - Create UL Nested Lists From Flatfile
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USmar2195
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.