query - Read For Learn

Hook into the Admin Dashboard and redirect users

How to create a filter and add query params to all links

Assuming you mean $post->ID, you can use the post_link and post_type_link filters to append your query string. We’re using the add_query_arg() function to do this: /** * Modify the posts navigation WHERE clause * to include our acceptable post types * * @param String $post_link – Post URL * @param WP_Post $post – Current Post … Read more

How can I get posts by 2 meta keys, prioritising one of them?

custom sorting media with multiple filters – error: not unique table/alias: wp_postmeta

Okay, I found the problem by debugging the query. It was a generic LEFT JOIN added with the posts_join filter that has not alias the $wpdb->postmeta table which finally leads to the error. So the sorting is working now without problems.

Add rewrite rule for archive search

add_action( ‘init’, function() { add_rewrite_rule( ‘(.+)/search/(.+)/?$’, ‘index.php?post_type=$matches[1]&s=$matches[2]’, ‘top’ ); } ); It works done.

Display data from phpMyAdmin with WordPress

if you are trying to query from the same database in which your WordPress is installed then there is a great way to do sql query with ease. WordPress has a database access abstraction class called wpdb that allows you to run raw mysql query without any issue. You can start using it like one … Read more

How to sort by two meta keys in admin area?

I can’t find any examples that combine the $query->set(‘property’, ‘value’) syntax with an array assuming that’s the correct method In your $args array, you defined both meta_query and orderby as arrays, and they are each an arg for WP_Query (or a value for the “property” above), hence in your custom function (set_post_order_in_admin()), just use $query->set( … Read more