StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12083725
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-08-23T01:53:33.110
FavoriteCount
0
LastActivityDate
2012-08-23T02:21:04.460
LastEditDate
2012-08-23T02:21:04.460
LastEditorUserId
1073758
OwnerUserId
1073758
ParentId
12083576
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
You have already proven to create an XML document by your syntax - just recreate the standard template. For example's sake, I will pretend your website info is stored in array such as: <pre><code>$yourSiteContent = array( array('permalink' => 'http://www.somesite.com/someurl1', 'updated' => '2012-08-11T04:08:53+01:00'), array('permalink' => 'http://www.somesite.com/someurl2', 'updated' => '2012-09-11T04:08:53+01:00'), array('permalink' => 'http://www.somesite.com/someurl3', 'updated' => '2012-10-11T04:08:53+01:00') ); </code></pre> Then sticking back to your example: <pre><code>$xml = new DomDocument('1.0', 'utf-8'); $xml->formatOutput = true; // creating base node $urlset = $xml->createElement('urlset'); $urlset -> appendChild( new DomAttr('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9') ); // appending it to document $xml -> appendChild($urlset); // building the xml document with your website content foreach($yourSiteContent as $entry) { //Creating single url node $url = $xml->createElement('url'); //Filling node with entry info $url -> appendChild( $xml->createElement('loc', $entry['permalink']) ); $url -> appendChild( $lastmod = $xml->createElement('lastmod', $entry['updated']) ); $url -> appendChild( $changefreq = $xml->createElement('changefreq', 'monthly') ); $url -> appendChild( $priority = $xml->createElement('priority', '0.5') ); // append url to urlset node $urlset -> appendChild($url); } $xml->save("data.xml"); </code></pre> The rest is up to you.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POphp how to create dynamic xml sitemap
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USmoonwave99
UserOwnerUserId
1. USmoonwave99
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POphp how to create dynamic xml sitemap
 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
 VTAcceptedByOriginator
CommentsPostId
1. COworks fine..please remove extra ")" from the following line "..ap/0.9')));"
 singulars
 PostPostId
 PO
 UserUserId
 USHannah Pink

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.