StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15741465
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-01T10:09:08.473
FavoriteCount
0
LastActivityDate
2013-04-01T10:21:32.787
LastEditDate
2017-05-23T12:20:35.417
LastEditorUserId
-1
OwnerUserId
367456
ParentId
15708638
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
As <code>SimpleXMLElement</code> is a <code>Traversable</code>, you can do the pagination with a <a href="http://php.net/LimitIterator" rel="nofollow noreferrer"><code>LimitItertor</code></a> which ships with PHP. To get the total number of product elements you can use the <code>SimpleXMLElement::count()</code> function. Pagination works like outlined in the hundreds of other questions, I preferable use the <a href="https://gist.github.com/hakre/4469154" rel="nofollow noreferrer"><code>LimitPagination</code> type</a> for it. It takes the current page, the total amount of elements and elements per page as arguments (see as well: <a href="https://stackoverflow.com/a/14184729/367456">PHP 5.2 and Pagination</a>). It also has a helper function to provide the <code>LimitIterator</code>. Example: <pre><code>$products = $xml->product; // pagination $pagination = new LimitPagination($_GET['page'], $products->count(), 20); foreach ($pagination->getLimitIterator($products) as $product) { ... } </code></pre> If you want to output a pager that allows to navigate between the pages, the <code>LimitPagination</code> has more to offer to make that a bit easier, e.g. for just all pages highlighting the current page (here exemplary with brackets): <pre><code>foreach ($pagination->getPageRange() as $page) { if ($page === $pagination->getPage()) { // current page printf("[p%d] ", $page); } else { printf("p%d ", $page); } } foreach ($pagination->getPageRange() as $page) { if ($page === $pagination->getPage()) { // current page printf("[p%d] ", $page); } else { printf("p%d ", $page); } } </code></pre> Interactive online demo: <a href="http://codepad.viper-7.com/OjvNcO" rel="nofollow noreferrer">http://codepad.viper-7.com/OjvNcO</a> Less interactive online demo: <a href="http://eval.in/14176" rel="nofollow noreferrer">http://eval.in/14176</a> 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POXML pagination with PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. UShakre
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
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.