Forums

WordPress › Support » Plugins and Hacks

Testing and obtaining category_parent ID (6 posts)

  1. elfin
    Member
    Posted 5 years ago #

    I haven't used Wordpress for long, and know nowt about php. So I am having to ask for help.
    I am working on this function
    function get_here($current){
    $current = $_GET[cat];
    echo $current;
    }

    Which returns whichever category id you happen to be in. Which is fine when they are not 'children'. When they are it is causing problems, soI need to amend it to test for the existence of a category_parent(greater than 0 anyway), and return the relevant ID.
    Can anyone help me with this? I have been playing with it all day and got absolutely nowhere.
    All help appreciated...

  2. StewartUgelow
    Member
    Posted 5 years ago #

    get_the_category() returns the category of the current post.
    get_the_category_parents(get_the_category()) will return the parent of the current category.
    Take a look at wp-includes/template-functions-category.php for more options.

  3. andrew_h
    Member
    Posted 5 years ago #

    I don't seem to have the get_the_category_parents function (v1.2), but anyway to offer a little help, this is the raw material of a solution, it lists each category and it's parent status.
    <?php
    $catp = $wpdb->get_results("SELECT cat_ID, category_parent FROM $tablecategories");
    foreach($catp as $tcatp) {
    $tid = $tcatp->cat_ID;
    $tpid = $tcatp->category_parent;
    print "id $tid p $tpid<br>";
    }
    ?>
    Andrew

  4. elfin
    Member
    Posted 5 years ago #

    hmm from what I have tried this doesn't work, I shall be calling the function from within the <head> which might explain my difficulty.
    So is it me being dumb?
    I have been through that file, but didn't find what I was looking for.
    Am I missing something painfully obvious here?

  5. elfin
    Member
    Posted 5 years ago #

    hmm, thanks Andrew I'll have a look at using that.
    Steep learning curve here, so maybe I should say 'attempt' to utilise it.

  6. boby
    Member
    Posted 4 years ago #

    Hello!

    I was searching for something like this too and I wrote my own function because I didn't found anything useful :( or didn't knew how to use the "get_the_category_parents()" function...

    So here it is:
    <?php
    function get_parent_category($id)
    {
    global $wpdb;

    $category = $wpdb->get_results("SELECT cat_ID, cat_name, category_nicename, category_description, category_parent FROM ".$wpdb->categories." WHERE cat_ID=".$id);

    if( isset($category) && !empty($category) ) :
    $category_output = array();
    $category_output['cat_ID'] = $category[0]->cat_ID;
    $category_output['cat_name'] = $category[0]->cat_name;
    $category_output['category_nicename'] = $category[0]->category_nicename;
    $category_output['category_description'] = $category[0]->category_description;
    $category_output['category_parent'] = $category[0]->category_parent;
    return $category_output;
    else :
    return FALSE;
    endif;
    }
    ?>

    You will use it like this for example:
    <?php
    if( $cat > 0 ) :
    $this_category = get_parent_category($cat);
    ?>
    <h2><?php echo $this_category['cat_name']; ?></h2>
    <?php echo $this_category['category_description']; ?>
    <?php endif; ?>

    Hope you'll understand. You will get "cat_ID", "cat_name", "category_nicename", "category_description" and "category_parent" in the variable that you assign the results of the "get_parent_category()" function.
    "get_parent_category($cat)" is the call of the function, where "$cat" is the current category_ID and is usually direct available.

    Hope this works. Maybe you'll have to change it a bit, this is what I needed for my page.

    Cheers, Boby!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.