StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHierarchical dropdown menu from array?
primarykey
Id
14127335
data
AcceptedAnswerId
14185746
AnswerCount
3
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-01-02T18:39:55.720
FavoriteCount
1
LastActivityDate
2013-01-08T08:33:59.217
LastEditDate
2013-01-05T22:47:10.403
LastEditorUserId
910737
OwnerUserId
910737
ParentId
0
PostTypeId
1
Score
0
ViewCount
1537
LastEditorDisplayName
text
Body
I have the following code which fetches fields from my database and places them into an html form's dropdown menu for Formats. In it's current form, I am fetching from my database 3 times, how the code works is explained in the comments of the code: <pre><code>$getSolos = $wpdb->get_results($wpdb->prepare(" SELECT * FROM wp_terms p LEFT OUTER JOIN wp_term_taxonomy t ON p.term_id = t.term_id WHERE t.taxonomy = 'format' AND t.parent = 0 AND t.term_id NOT IN (SELECT parent FROM wp_term_taxonomy WHERE taxonomy = 'format' AND parent > 0) ORDER BY t.parent ")); // This fetches all rows that do not have children or parents. $getParents = $wpdb->get_results($wpdb->prepare(" SELECT * FROM wp_terms p LEFT OUTER JOIN wp_term_taxonomy t ON p.term_id = t.term_id WHERE t.taxonomy = 'format' AND t.parent = 0 AND t.term_id IN (SELECT parent FROM wp_term_taxonomy WHERE taxonomy = 'format' AND parent > 0) ")); // This fetches all rows that have children $getChildren = $wpdb->get_results($wpdb->prepare(" SELECT * FROM wp_terms p LEFT OUTER JOIN wp_term_taxonomy t ON p.term_id = t.term_id WHERE t.taxonomy = 'format' AND t.parent > 0 ORDER BY t.parent AND p.name ")); //This fetches all rows that ARE children <select name="format"> //start the dropdown <option value="empty"></option> //default field is empty <?php foreach ($getSolos as $solo) { //start loop through solos for output echo "<option value='".$solo->name."'>".$solo->name."</option>"; // output solos as options in the dropdown } foreach ($getParents as $parent) { //start loop through parents for output echo "<optgroup label='".$parent->name."'>"; // Spit out parent as an optgroup foreach ($getChildren as $child) { //Start loop through children for output if ($child->parent == $parent->term_id) { // if child's parent value matches the ID of the parent echo "<option value='".$child->name."'> ".$child->name."</option>"; //Spit out the child as an option } } echo "</optgroup>"; //close the optgroup } ?> </select> // end the dropdown </code></pre> The output is as follows: <pre><code>Entry Form Twitter Facebook - Entry Form - Page </code></pre> The combined table from the database looks like this: <pre><code>term_id name slug taxonomy parent 1 Entry Form entry-form format 0 2 Page page format 3 3 Facebook facebook format 0 4 Entry Form facebook-entry-form format 3 5 Twitter twitter format 0 </code></pre> There is a problem with this method however. 1) It is inefficient to access the database 3 times. 2) It is ineffective if a child also has a child. While the children of children do all go into $getChildren, the code will only spit out 1st level children and ignore the rest. For demonstration purposes, if I have 6th row: <pre><code>term_id name slug taxonomy parent 6 Single single format 2 </code></pre> Then the code would do this: <pre><code>Entry Form Twitter Facebook - Entry Form - Page </code></pre> Notice that Single is completely ignored, ALTHOUGH it is contained inside the $getChildren array. So how can this code be made better?
Tags
<php><html><arrays><forms><drop-down-menu>
Title
Hierarchical dropdown menu from array?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSweepster
UserOwnerUserId
1. USSweepster
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
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHierarchical dropdown menu from array?
 UserUserId
 USSweepster
 VoteTypeVoteTypeId
 VTBountyStart
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.