StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9201457
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
16
CommunityOwnedDate
CreationDate
2012-02-08T21:09:27.230
FavoriteCount
0
LastActivityDate
2012-02-09T21:37:48.210
LastEditDate
2012-02-09T21:37:48.210
LastEditorUserId
979007
OwnerUserId
979007
ParentId
9201261
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Start with something like this: <pre><code>$doc = simplexml_load_file("feedpage.xml"); </code></pre> Then (since I don't know what your XML file looks like), try: <pre><code>echo "<pre>".print_r($doc,true)."</pre>"; </code></pre> to see exactly how the resulting object is laid out. From there, you should be able to pick out the pieces you need to build what you want. Edit: If your output is: <pre><code>SimpleXMLElement Object ( [varOne] => SimpleXMLElement Object ( [varOne] => Title [varTwo] => A description [VarThree] => A Link [VarFour] => An Image ) ) </code></pre> You could do this to access the properties of each one: <pre><code>foreach($doc as $row) { $title = $row->varOne; $description = $row->varTwo; // etc. } </code></pre> So with the <code>foreach</code> loop, you can go through each main item and access each item's properties. And if you want to put code in comments, you can use the backtick (`) to surround your text, but it doesn't work well for code blocks (like the one you wanted to post). Best for variables or other short bits. FINAL EDIT: Let's take this example object: <pre><code>SimpleXMLElement Object ( [varOne] => SimpleXMLElement Object ( [varOne] => "Title" [varTwo] => "Description" [varThree] => "Link" [varFour] => "Image" [varFive] => SimpleXMLElement Object ( [varA] => "something" [varB] => SimpleXMLElement Object ( [varX] => "a string" ) [varC] => "another thing" ) ) ) </code></pre> Let's say the whole thing is contained in a variable <code>$obj</code>. Now let's say we wanted what's in <code>varX</code>. We'd access it like this: <pre><code>echo $obj->varOne->varFive->varB->varX; </code></pre> Beyond this, I don't know what else to tell you. You need to closely examine the objects you have and determine how they are structured. Extrapolate what you've learned here and apply it to your situation.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhat is the SimpleXML version of this DOMDocument XML?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCrontab
UserOwnerUserId
1. USCrontab
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWhat is the SimpleXML version of this DOMDocument XML?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.