StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16305236
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2013-04-30T16:59:50.417
FavoriteCount
0
LastActivityDate
2013-04-30T17:13:23.633
LastEditDate
2013-04-30T17:13:23.633
LastEditorUserId
2261774
OwnerUserId
2261774
ParentId
16304442
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
It is not outright trivial, but what I did is actually the same as you (the same way as in your edited question), but I also keep track of those arrays to rename the keys. And that's what I do afterwards then: <pre><code>$separator = [' ', '|']; $buffer = file_get_contents($file); $entries = explode($separator[0], $buffer); $result = []; $named[] = &$result; ######## foreach ($entries as $entry) { $each = explode($separator[1], $entry); $pointer = & $result; while ($current = array_shift($each)) { if (!isset($pointer[$current])) { unset($children); $children = []; $named[] = &$children; ######## $pointer[$current] = ['name' => $current, 'children' => &$children]; } $pointer = & $pointer[$current]['children']; } } foreach($named as $offset => $namedArray) { $keys = array_keys($namedArray); foreach($keys as $key) { $named[$offset][] = &$namedArray[$key]; unset($named[$offset][$key]); } } print_r($result); </code></pre> <a href="http://eval.in/18420" rel="nofollow">See it in action.</a> You probably might want to modify this by checking in the later foreach if children are empty (leaf-nodes) and then removing the children entry as well. Here the modified foreach at the end and json output: <pre><code>foreach($named as $offset => $namedArray) { $keys = array_keys($namedArray); foreach($keys as $key) { if (!$namedArray[$key]['children']) { unset($namedArray[$key]['children']); } $named[$offset][] = &$namedArray[$key]; unset($named[$offset][$key]); } } echo json_encode($result, JSON_PRETTY_PRINT); </code></pre> Output: <pre><code>[ { "name": "Brazil", "children": [ { "name": "SaoPaulo", "children": [ { "name": "Diadema", "children": [ { "name": "RuadaFe" }, { "name": "RuadoLimoeiro" } ] }, { "name": "SaoCaetano", "children": [ { "name": "RuadasLaranjeiras" } ] } ] }, { "name": "Parana", "children": [ { "name": "Curitiba", "children": [ { "name": "ComendadorAraujo" } ] } ] } ] }, { "name": "USA", "children": [ { "name": "NewJersey", "children": [ { "name": "JerseyCity", "children": [ { "name": "WhashingtonBoulervard" }, { "name": "RiverCourt" } ] } ] } ] } ] </code></pre> The full code-example at a glance: <pre><code><?php /** * PHP - Nested array keys based on string lines * @link http://stackoverflow.com/a/16305236/2261774 */ $file = 'data://text/plain;base64,' . base64_encode('Brazil|SaoPaulo|Diadema|RuadaFe Brazil|SaoPaulo|Diadema|RuadoLimoeiro Brazil|SaoPaulo|SaoCaetano|RuadasLaranjeiras Brazil|Parana|Curitiba|ComendadorAraujo USA|NewJersey|JerseyCity|WhashingtonBoulervard USA|NewJersey|JerseyCity|RiverCourt'); $separator = [' ', '|']; $buffer = file_get_contents($file); $entries = explode($separator[0], $buffer); $result = []; $named[] = &$result; foreach ($entries as $entry) { $each = explode($separator[1], $entry); $pointer = & $result; while ($current = array_shift($each)) { if (!isset($pointer[$current])) { unset($children); $children = []; $named[] = &$children; $pointer[$current] = ['name' => $current, 'children' => &$children]; } $pointer = & $pointer[$current]['children']; } } unset($pointer); foreach($named as $offset => $namedArray) { $keys = array_keys($namedArray); foreach($keys as $key) { if (!$namedArray[$key]['children']) { unset($namedArray[$key]['children']); } $named[$offset][] = &$namedArray[$key]; unset($named[$offset][$key]); } } unset($named); echo json_encode($result, JSON_PRETTY_PRINT); </code></pre> <hr> your question JSON: <pre><code>{ "name": "Brazil", "children": [ { "name": "SaoPaulo", "children": [ { "name": "Diadema", "children": [ {"name": "RuadaFe"}, {"name": "RuadoLimoeiro"} ] }, </code></pre> My Answer JSON: <pre><code>[ { "name": "Brazil", "children": [ { "name": "SaoPaulo", "children": [ { "name": "Diadema", "children": [ { "name": "RuadaFe" }, { "name": "RuadoLimoeiro" } ] }, </code></pre> The only difference I can spot is that the root-nodes are wrapped inside an array in my answer, but it should be trivial to fetch them out there if that really is your issue ;)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP - Nested array keys based on string lines
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USM8R-1jmw5r
UserOwnerUserId
1. USM8R-1jmw5r
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

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.