query - Read For Learn

Change Query String to pretty permalink

Try this rewrite rule in your functions.php function string_url_rewrite() { global $wp_rewrite; add_rewrite_tag(‘%pet-page%’, ‘([^&]+)’); //In the rewrite rule you need to enter page slug and page id add_rewrite_rule(‘^Enter_Page_slug/([0-9]+)/?’, ‘index.php?page_id=Enter_Page_ID&pet-page=$matches[1]’, ‘top’); $wp_rewrite->flush_rules(true); } add_action(‘init’, ‘string_url_rewrite’, 10, 0); Now you also need to change the format of URL in anchor tag. For example, your previous URL http://www.example.com/my-account/view-pet/?pet-page=2 … Read more

How to detect custom query inside `posts_where` hook?

If we have the query arguments like this $args = array( ‘queryid’ => ‘blackjack’, … ); $q = new WP_Query( $args ); Note we added one custom query argument that is not officially present in here. Now we can identify the exact query by that queryid if we use the second parameter of the posts_where … Read more

WP_query category__in not working, only pulls from first category

Following Milo‘s answer, I found another workaround that works and i’m more confortable with it. $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘category__in’ => array(15, 17), ‘posts_per_page’ => 4 ); $query = new WP_Query(); $items = $query->query($args);

How to speed up wp_query, took more 5s to run against 100k posts

Here’s the culprit: [meta_query] => Array ( [0] => Array ( [key] => city [value] => Las Vegas [compare] => = ) ) Meta queries are slow, and the only way to speed them up is to not use meta queries. The post meta table is optimised for fetching key/value pairs where the post ID … Read more

can’t get query to order posts by acf datepicker

You need to convert your saved format to the post_date format which is in Y-m-d H:i:s Only then will the comparators work properly with automatically generated query objects.

Get posts by category with pure SQL query

If you want to be able to get the category by name, this should work: SELECT DISTINCT substr(post_title, – instr(reverse(post_title), “https://wordpress.stackexchange.com/”) + 1) AS year FROM {$wpdb->posts} p LEFT JOIN {$wpdb->term_relationships} rel ON rel.object_id = p.ID LEFT JOIN {$wpdb->term_taxonomy} tax ON tax.term_taxonomy_id = rel.term_taxonomy_id LEFT JOIN {$wpdb->terms} t ON t.term_id = tax.term_id WHERE post_status=”publish” AND … Read more

WP database error for comments_popup_link()

Your template code includes $wpdb->print_error(). This function prints the last database error between [ and ] brackets, and the executed SQL code. But if there is no error, you just see the empty brackets and the SQL. $wpdb->show_errors() is used to enable displaying of database errors. If you want to see all database errors, you … Read more

Custom search page and search by title, content and tag

Search in WordPress is complicated matter because: WP doesn’t do it very well out of the box People tend to have varied expectations of how precisely search should work Even light (from human perspective) requirements for search tend to translate in complicated and involved code Building search from scratch is involved (I know because I … Read more

WordPress custom archive page

Of course it breaks. Pagination depends on the main query saved in the $wp_query object and you have overwritten that. When the next page load the ordinary wp_query that you have not overwritten will run and it won’t match the one you’ve altered. Create a filter for pre_get_posts to alter the main query. function pregp_wpse_97354($qry) … Read more

How can I display a specific user’s first published post?

The following query retrieves the oldest post of a specified user/author: $user_id = 42; // or whatever it is $args = array( ‘posts_per_page’ => 1, ‘post_status’ => ‘publish’, ‘author’ => $user_id, ‘orderby’ => ‘date’, ‘order’ => ‘ASC’, ); $first_post = new WP_Query($args); if ($first_post->have_posts()) { $first_post->the_post(); // Now you can use `the_title();` etc. wp_reset_postdata(); } … Read more

+ More