How to Display the list of wordpress categories with their ids

3 comments

1. The WordPress function wp_list_categories will return a list of all the categories. If you set the hierarchical flag to true you will get the whole hierarchy. Read the codex article in the link above for details.

   There is also a get_categories function that returns an unformatted result. You could use this in your own PHP code.

   A third choice is to read the database, there are three tables wp_terms, wp_term_taxonomy and wp_term_relationships that contain the category tree. Here’s the database structure.

   Edit: Here’s a shortcode that will produce a listing like that as a nested collection of lists:

   function show_categories($atts, $content) {
       extract( shortcode_atts( array('taxonomy' => 'category'), $atts ) );
       $cats = get_categories(array('taxonomy' => $taxonomy,'hide_empty' => 0, 'hierarchical' => 0, 'parent' => 0));
       return show_categories_level($cats, '', '', $taxonomy);
   }
   
   function show_categories_level($cats, $names, $ids,$taxonomy) {
       $res = '<ul>';
       foreach ($cats as $cat) {
           if($names)$n = "$names, $cat->name"; else $n = $cat->name;
           if($ids)$i = "$ids, $cat->term_id"; else $i = $cat->term_id;    
           $res = $res."<li>$n : $i</li>";
           $kittens = get_categories(array('taxonomy' => $taxonomy,'hide_empty' => 0, 'hierarchical' => 0, 'parent' =>$cat->term_id));
           if($kittens) {
               $res .= ("<li>".show_categories_level($kittens, $n, $i, $taxonomy)."</li>");
           }
       }
       return $res."</ul>";
   }
   add_shortcode('show-categories', 'show_categories');
   

   To use this add this code to your functions.php and add the shortcode wherever you want it to display:

   <h2>Default Categories</h2>
   [show-categories]
   

   or you can specify a taxonomy that you want listed

   <h2>My Taxonomy Categories</h2>
   [show-categories taxonomy="my_taxonomy"]
   

   This isn’t the most efficient way to get this result, but it works here. If you started with the hierarchical version of get_categories or used the database you could get a faster version of this.

   Log in to Reply

2. Where do you want to display this? inside loop? outside? in single.php? category.php? …..?

   If you want to display it in a separate place, include first wp-load.php, like this

   <? php
   
   
   header('Content-Type: text/html; charset: UTF-8');
   require( '../../../../wp-load.php' ); // use the path which will fit your situation
   
   $my_query = new WP_Query();
   $my_query->query(array(
             'post_type' => 'post',
             'orderby'   => 'title',
             'order'     => 'ASC',
           ));
   
   if ($my_query->have_posts()) : while ($my_query->have_posts()) : $my_query->the_post(); 
   
   // use your code here after checking codex
   
   endwhile;
   endif;
   ?>
   

   Log in to Reply

3. What i want to do is this:
   The steps I Followed (please check this link)

   I only want to change this code:

   <ul> <?php wp_list_categories('show_count=1&title_li=&hide_empty=0'); ?></ul>
   

   so that the list of of all the categories and their childs will be displayed along with their ids in this format:

   Example:
   Europe,United Kingdom,London, East Ham : 25,28,34,36
   this is just one parent category (Europe) and its childs (Uk)
   the child of UK is London, and the child of london is East Ham.
   25 is the id of Europe, 28 is the id of UK, 34 is the id of London, 36 is the id of East Ham

   Please note: I just want to display this list on a page as described in the link above.
   Thank you so much

   Log in to Reply