Based on the comments I think I’d implement this outside of the query itself, and use PHP to filter the results. I’ll give you a second solution as well, but I think this first one is easier to understand (when you come back to it later on). Since I don’t know the specifics of your … Read more
This might not solve your problem, but it will help you in future to create custom queries. Paginating more than one query can get extremely tricky. By default the build in pagination in WordPress don’t have this logic to paginate multiple queries. You will have to run multiple queries and merge them in some way. … Read more
WordPress standard query sucks with multiple meta queries when orderby is set to meta key. After a lot of headaches and time lost I wrote a custom class that allow me to better handle that sort of things. Here there is a simplified version of my class, but it hould work for your purposes: class … Read more
Try this: $yoursearchquery = ‘This is my search’; $users = new WP_User_Query(array( ‘search’ => $yoursearchquery, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘shoe_size’, ‘value’ => $yoursearchquery, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘shoe_color’, ‘value’ => $search_operation, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘shoe_maker’, ‘value’ => $yoursearchquery, ‘compare’ => ‘=’ ) ) … Read more
It looks like this section: AND (wptom_posts.post_status=”publish” OR wptom_posts.post_author = 1 AND wptom_posts.post_status=”private”) is not tied in at all to the two different query conditions… Perhaps the original code should be three conditions for part 1: array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘category’, ‘field’ => ‘slug’, ‘operator’ => ‘IN’), array( ‘taxonomy’ => ‘post_tag’, ‘field’ … Read more
I can see from above query that you are willing to do following thing. Get all post if property_size is 15 AND property-type is marla OR Kanal. The SQL will be like %marla% OR like %Kanal% this is equivalent to like %marla Kanal% this will not make much difference (I assume) So you can minimize … Read more
Fixed: Search and result the all keys; <?php $the_keys = preg_split(‘/\s+/’, str_replace(‘-‘,’ ‘,get_query_var(‘s’)),-1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE); $total_keys = count($the_keys); $the_query = new WP_Query(array(‘post_type’=>’nothing’)); if($total_keys>1){ for($i = 0; $i<=$total_keys; $i++) { $the_query_mask = new WP_Query(array(‘s’ => $the_keys[$i])); $the_query->post_count = count( $the_query->posts ); $the_query->posts = array_merge( $the_query->posts, $the_query_mask->posts ); } } else { $the_query= new WP_Query(array(‘s’ => … Read more
WordPress is also provide more filters to change custom queries. https://codex.wordpress.org/Custom_Queries add_filter(‘posts_join’, ‘custom_query_join’ ); $premium = new WP_Query( $premium_args); remove_filter(‘posts_join’, ‘custom_query_join’ ); // remove filter bcz not effect to another query to use after this query. function custom_query_join( $join ){ $join .= ‘Put here join to table’; return $join; }
First you will need the slug of the current category: $cat = get_query_var(‘cat’); $currentcat = get_category ($cat); Then you can use the same loop. Just add the following to $query_args to limit the outcome to the current category: ‘category_name’ => $currentcat->slug,
Make sure that your wordpress url in the settings at your admin dashboard is starting with https://. It is not enough to simply open the website with the https link. WordPress has to know that your website is ssl secured.