StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8331234
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2011-11-30T18:48:54.320
FavoriteCount
0
LastActivityDate
2011-11-30T19:12:13.043
LastEditDate
2011-11-30T19:12:13.043
LastEditorUserId
711308
OwnerUserId
711308
ParentId
8329846
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I did just this a while ago, I can't see exactly whats going wrong. But I can provide the function I built for a site for you to look at. This function worked 100% fine and as expected. It created a perfect XML document and formatted it perfectly. I hope this helps you find your problem. <pre><code>function create_xml_file() { /* create a dom document with encoding utf8 */ $domtree = new DOMDocument('1.0', 'utf-8'); /* create the root element of the xml tree */ /* Data Node */ $xmlRoot = $domtree->createElement("data"); /* append it to the document created */ $xmlRoot = $domtree->appendChild($xmlRoot); /* Set our Prices in our <data> <config> node */ $config_node = $domtree->createElement("config"); $config_node = $xmlRoot->appendChild($config_node); // Add - node to config $config_node->appendChild($domtree->createElement('config_node', '123456')); $config_node->appendChild($domtree->createElement('some_other_data', '123456')); /* Create prices Node */ $price_node = $domtree->createElement('price'); $price_node = $config_node->appendChild($price_node); /* Black Price Node */ $black_node = $price_node->appendChild($domtree->createElement('black')); foreach ($p->List_all() as $item): if ($item['color'] == 'black'): $black_node->appendChild($domtree->createElement($item['type'], $item['price'])); endif; endforeach; /* Create galleries Node */ $galleries_node = $domtree->createElement("galleries"); $galleries_node = $xmlRoot->appendChild($galleries_node); foreach ($i->List_all() as $image): /* Our Individual Gallery Node */ $gallery_node = $domtree->createElement("gallery"); $gallery_node = $galleries_node->appendChild($gallery_node); $gallery_node->appendChild($domtree->createElement('name', $image['name'])); $gallery_node->appendChild($domtree->createElement('filepath', $image['filepath'])); $gallery_node->appendChild($domtree->createElement('thumb', $image['thumb'])); endforeach; /* Format it so it is human readable */ $domtree->preserveWhiteSpace = false; $domtree->formatOutput = true; /* get the xml printed */ //echo $domtree->saveXML(); $file = 'xml/config.xml'; $domtree->save($file); } </code></pre> I hope this helps you find your answer. I commented it well for easy understanding.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP building XML files using DOMDocument in batches
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAnil
UserOwnerUserId
1. USAnil
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. 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.