StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2414777
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-03-10T05:39:52.287
FavoriteCount
0
LastActivityDate
2010-03-11T12:16:44.193
LastEditDate
2010-03-11T12:16:44.193
LastEditorUserId
138475
OwnerUserId
138475
ParentId
2317220
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
Generating a DTD from an XML file is something I've not seen done quite often -- one of the main reasons being that you cannot be sure the XML file you used to generate the DTD will contain everything that the DTD should define. i.e. the generated DTD will only contain the elements and attributes that were present in that specific XML file -- which doesn't necessarily means all elements and attributes that should be accepted when using it later. That being said, I haven't found any PHP tool to create a DTD from an XML file... ... But I've found a JAVA one : <a href="http://saxon.sourceforge.net/dtdgen.html" rel="nofollow noreferrer">DTDGenerator - A tool to generate XML DTDs</a> (quoting) : <blockquote> DTDGenerator is a program that takes an XML document as input and produces a Document Type Definition (DTD) as output. The aim of the program is to give you a quick start in writing a DTD. The DTD is one of the many possible DTDs to which the input document conforms. Typically you will want to examine the DTD and edit it to describe your intended documents more precisely. </blockquote> A couple of nice things about this <code>DTDGenerator</code> program are : <ul> <li>There are some explanations on the website about the basic ideas of how this works</li> <li>The source code is provided</li> <li>It's only less that 600 lines long <ul> <li>which means one should be able to understand without too much efforts</li> <li>and possibly port it to PHP ?</li> <li>And there are some comments in the source code -- which would help.</li> </ul></li> <li>It's published under <a href="http://www.mozilla.org/MPL/MPL-1.0.html" rel="nofollow noreferrer">MPL</a> -- which means open source ; which is good, if you want to port it</li> </ul> Starting from that program's source code, it should be possible to write some PHP code (if you cannot execute JAVA, and really need this to be written in PHP) to do the same thing : the basic ideas are not that hard : <ul> <li>You have to go through the XML structure</li> <li>building a tree-representation of it, on each starting tag <ul> <li>which means elements</li> <li>that can have attributes</li> </ul></li> <li>And, when you've finished going through the XML document, you have to build the DTD from your reprensentation of the document <ul> <li>That might be the hard part -- looking at the source of the JAVA tool I linked to, it reprensents quite a large number of lines of code ^^</li> </ul></li> </ul> Nice thing of taking a look at this <a href="http://saxon.sourceforge.net/dtdgen.html" rel="nofollow noreferrer"><code>DTDGenerator</code></a> before starting is that its author already thought about this process -- and already identified some situations that you might not think about ;-)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POphp script to convert xml to dtd
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPascal MARTIN
UserOwnerUserId
1. USPascal MARTIN
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POphp script to convert xml to dtd
 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
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.