PHP: sort multi-dimensional array based on key for AJAX with WP_Query

Question

I have a WP_Query that I'm using for a custom post type filter through AJAX. Every post type has a custom post taxonomy (category), but only one. In the filter process I want the result to be based on the names of the categories, THEN on the names of the products, but I haven't found the right documentation for using methods like usort or ksort with these types of arrays.

Here's my PHP:

$args = array(
    'posts_per_page'    => -1,
    'post_type'             => 'product',
    'orderby'                   => 'title',
    'order'                     => 'ASC',
    'tax_query' => array(
        array(
            'taxonomy'  => 'products_tag',
            'field'         => 'slug',
            'terms'         => $taxonomy,
            'operator'  => 'AND',
        ),
    ),
);

$filter_query = new WP_Query($args);
$num_posts = $filter_query->found_posts;

if( $filter_query->have_posts() ):

    while( $filter_query->have_posts() ) : $filter_query->the_post();

        $titles[] = get_the_title();
        $ids[] = get_the_ID();
        $product_categories = get_the_terms( get_the_ID(), 'products_category' );
        $product_category = array_pop( $product_categories );
        $categories[] = $product_category->name;
        $permalinks[] = get_permalink();
        $image_field = get_field('images');
        $images[] = $image_field[0]['url'];
        $descriptions[] = get_field('short-description');

    endwhile;

endif;

wp_reset_postdata();

$response = array(
    'success' => true,
    'titles' => $titles,
    'ids' => $ids,
    'categories' => $categories,
    'permalinks' => $permalinks,
    'images' => $images,
    'descriptions' => $descriptions,
    'taxonomy' => $taxonomy,
    'num_posts' => $num_posts
);

So before the $results variable is declared, I want all the arrays to follow the $categories array in an easy way, but haven't a method how to. I might have misinterpreted the documentation completely, but I haven't seen my case appear in the php.net manuals.

@RutwickGangurde thanks, but from what I've interpreted, this is not doable for custom taxonomies. Edit: and I'd be damned, how wrong was I. It worked! Thanks! — Erik Blomqvist
– Erik Blomqvist, Commented May 30, 2016 at 12:31
Awesome! I'll add this as an answer so that you can accept it. — Rutwick Gangurde
– Rutwick Gangurde, Commented May 30, 2016 at 12:53

Community · Accepted Answer · 2017-05-23 12:07:59Z

1

This should work, though I have not tried it.

$query = new WP_Query( array( 'post_type' => 'page', 'orderby' => 'title menu_order', 'order' => 'ASC' ) );

Notice how orderby has 2 parameters separated by a space.

Follow this thread for more info: How to order by two different things at once in a query in WordPress

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered May 30, 2016 at 12:54

Rutwick Gangurde

4,93212 gold badges56 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP: sort multi-dimensional array based on key for AJAX with WP_Query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related