StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP foreach / while / loop - how to traverse entire category hierarchy without database
primarykey
Id
10576395
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-05-14T00:43:24.757
FavoriteCount
0
LastActivityDate
2012-05-14T06:09:24.087
LastEditDate
2012-05-14T06:09:24.087
LastEditorUserId
613453
OwnerUserId
613453
ParentId
0
PostTypeId
1
Score
0
ViewCount
776
LastEditorDisplayName
text
Body
I need to fetch the whole category tree hierarchy(ebay API) and print each category value without to use any database (i.e. mysql ). I've tried several approaches using foreach and while but my script dies after the top categories or at most after the first set of child categories . Here is my script : <pre><code>set_time_limit('0'); error_reporting(E_ALL); ## get categories allow us to traverse through categories //getcategorycall call to return the categories based on the category id function GetCategoryInfo($id) { $URL = "api.example.com"; $response = json_decode(file_get_contents($URL), true); //check if the request is returned with success $Ack = $response['Ack']; if ($Ack !== 'Success') { echo "error $Ack"; exit(); } //get category array $CategoryArray = $response['CategoryArray']['Category']; return $CategoryArray; } $CategoryID_top = '-1'; $CategoryInfo = GetCategoryInfo($CategoryID); //traverse top categories //we need to count the categories and start from 1 due the fact the requested category(e.g. root) is included in the response $top_count = count($CategoryInfo); $top_i = 1; while ($top_i <= $top_count) { $Category = $CategoryInfo[$top_i]; # print_r($Category); # exit(); $CategoryID = $Category['CategoryID']; $CategoryName = $Category['CategoryName']; $LeafCategory = $Category['LeafCategory']; echo " Top category:: $CategoryID\n $CategoryName\n $LeafCategory\n "; //traverse child categories that are not leaf until it reaches the leaf categories if (empty($LeafCategory)) { echo "this is not a leaf category"; $CategoryInfo = GetCategoryInfo($CategoryID); $child_count = count($CategoryInfo); $child_i = 1; while ($child_i <= $child_count) { $Category = $CategoryInfo[$child_i]; $CategoryID = $Category['CategoryID']; $CategoryName = $Category['CategoryName']; $LeafCategory = $Category['LeafCategory']; echo " Child category :: $CategoryID\n $CategoryName\n $LeafCategory\n "; $child_i++; } } $top_i++; } </code></pre>
Tags
<php><foreach><while-loop><ebay>
Title
PHP foreach / while / loop - how to traverse entire category hierarchy without database
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USthemihai
UserOwnerUserId
1. USthemihai
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPHP foreach / while / loop - how to traverse entire category hierarchy without database
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
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.