Does tax_query beats meta_query even in situations like this? No. Taxonomies are appropriate if you have a common set of values that are shared by many posts, and you’re doing a simple comparison based on whether the post has or does not have a particular value. They are not appropriate if you need to perform … Read more
You’ll need to setup the post for the query by changing the following line to get rid of the infinite loop. <?php while ($query->have_posts()) : $query->the_post(); ?> If your looking for a custom post type, you’ll need to specify that in the query arguments: <?php $query = new WP_Query( array( “post-type” => “yourposttype”, “tag” => … Read more
The wpdb class is the interface with the database. WP_Query uses wpdb to query the database. You should use WP_Query when dealing with the native WordPress tables, to integrate your code properly with the WordPress environment. Use wpdb directly when you need to access data in your own tables.
To get them broken down by Category, you need to loop through the list of categories and then query on each category: $categories = get_categories( array (‘orderby’ => ‘name’, ‘order’ => ‘asc’ ) ); foreach ($categories as $category) { echo “Category is: $category->name <br/>”; $catPosts = new WP_Query( array ( ‘category_name’ => $category->slug, ‘orderby’ => … Read more
I’m not sure if this is a bug, but it need further investigation. I’ve run a few quick tests on the name field in a tax_query, and whenever a term name has got a special character or have more than one word, the tax_query is excluded from the SQL query TEST 1 I have use … Read more
You can try the custom _meta_or_tax argument in WP_Query (PHP 5.4+): $args = [ ‘post_type’ => ‘post’, ‘_meta_or_tax’ => true, // <– our new custom parameter ‘tax_query’ => […], // <– our tax query ‘meta_query’ => […], // <– our meta query ]; $query = new WP_Query( $args ); where we use the following plugin … Read more
Well, get_posts() actually instantiates a new WP_Query object, so if you’re comfortable using WP_Query directly, don’t even bother with get_posts(); get_posts will only return the results from the database, whereas WP_Query gives you the whole functionality of the class.
As you haven’t stated what you are trying to achieve and have just mentioned you need to fetch associated data. You have two options to query your custom table: You need to do a custom query separately using the post id from the post object while iterating over the posts. Modify the joins of main … Read more
No. Parameters given to the WP_Query object only need to be escaped for the database query – this is handled by WordPress.
To do this you have first get all the category in ascending order by get_categories then you have to pass the cat_id in WP_Query to get the post related with that category. $args_cat = [ ‘orderby’ => ‘name’, ‘order’ => ‘ASC’, ‘hide_empty’ => 0, ]; $categories = get_categories($args_cat); //print_r($categories); if (!empty($categories)): foreach ($categories as $category): … Read more