Your question it make sense to me my friend but the get_categories don’t have the option to order by “meta_value_num” and then order by custom fields. What you can do is order after you get the array using the usort php function: $all_subcategories = array(‘parent’ => $categoryID); $categories = get_categories( $all_subcategories ); function order_categories($a, $b) … Read more
There may not be a need for a custom query, but I’d recommend it rather than hitting the database: – once for the WP_Query – once more for each post entry And then manually working out the math in PHP. Do it all at once with one MySQL statement. select sum(PM.meta_value) from wp_postmeta PM join … Read more
This line is wrong: ‘meta_key’ => ‘adminscore’ + ‘user_like’ + ‘_count-views_all’ + ‘comment_count’, ‘meta_key’ only accepts string value. What you need is an additional meta key, e.g. “totalscore” that holds the total value of the scores you have for all the meta values. You can manually run a php function that calculates and store the … Read more
This works. The filters are tied to a custom ‘orderby’ term and removed after the query. $args = array( ‘post_type’ => ‘artworks’, ‘posts_per_page’ => -1, ‘no_found_rows’ => true, ‘order’ => ‘ASC’, ‘orderby’ => ‘artist_name_artwork_title’, ); add_filter(‘posts_join’, ‘name_join’, 10, 2 ); add_filter(‘posts_orderby’, ‘orderby_artist_name_artwork_title’, 10, 2); // query $wp_query = new WP_Query( $args ); remove_filter(‘posts_join’, ‘name_join’, 10 … Read more
Please try using (blank space) instead of \s and . instead of \w For further details on supported operators and characters please check this link: https://dev.mysql.com/doc/refman/5.7/en/regexp.html
If you’re inside the while loop, use get_the_ID(). // returns an array as this is a multicheck field in Magic Fields 2 if(get_post_meta(get_the_ID(), ‘services’, true)){ $services = get_post_meta(get_the_ID(), ‘services’, true); $services = maybe_unserialize($services); // foreach item in the array foreach ($services as $service) { if ( sanitize_title($service_title) == sanitize_title($service) ) { echo ‘<p>’ . esc_attr($service) … Read more
This looks right, I have very similar code that works as expected: function price_query_test() { update_post_meta( 7, ‘_price’, 10 ); update_post_meta( 12, ‘_price’, 20 ); update_post_meta( 18, ‘_price’, 30 ); update_post_meta( 72, ‘_price’, 40 ); $test = new WP_Query( array( ‘post_type’ => ‘page’, ‘meta_query’ => array( array( ‘key’ => ‘_price’, ‘value’ => array( ’10’, ’25’ … Read more
Think of them as array key/value pairs (kinda). These tables are used to store additional data about particular posts, comments, or users. The meta_key is the name by which the meta_value is retrieved, plus you have associations with particular posts, comments, or users by means of IDs. As far as structure goes, that is about … Read more
You have to use the posts_orderby filter to do this at the mo, eg function wpse159469_posts_orderby( $orderby, $query ) { return implode( ‘ DESC,’, explode( ‘,’, str_replace( array(‘ ASC’, ‘ DESC’ ), ”, $orderby ) ) ) . ‘ DESC’; } then around your query: add_filter( ‘posts_orderby’, ‘wpse159469_posts_orderby’, 10, 2 ); $query = new WP_Query( … Read more
If you want to show custom field values, you can’t use WP_Query that select posts. It seems to me that the only available way is to write a sql query and execute it in $wpdb. global $wpdb; if ( isset($_POST[‘search’]) == false || empty($_POST[‘search’]) ) wp_send_json_success( $array() ); $s = $_POST[‘search’]; $meta_keys = [‘PLZ’, ‘ort’, … Read more