query - Read For Learn

Add query string variables to all hyperlinks URL matching a specified domain

Sorry I read your question wrong. You probably want to use WP_Rewrite and do something like: add_filter( ‘rewrite_rules_array’,’my_insert_rewrite_rules’ ); add_filter( ‘query_vars’,’my_insert_query_vars’ ); add_action( ‘wp_loaded’,’my_flush_rules’ ); // flush_rules() if our rules are not yet included function my_flush_rules(){ $rules = get_option( ‘rewrite_rules’ ); if ( ! isset( $rules[‘(argument_1=test&argument_2=test2)$’] ) ) { global $wp_rewrite; $wp_rewrite->flush_rules(); } } // … Read more

Filter multiple different main queries on custom pages

You can’t alter a page query via pre_get_posts (in any fashion I’ve tried) to something other than a page query. If you look at the generated SQL, it’s trying to query all your post types for a pagename of new. If you set pagename to null, it’ll return posts, but it will disregard any taxonomy … Read more

Adding Category Argument into an Array for WordPress Query

You need to add Category Parameters to your query array. $arguments = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘paged’ => $paged, ‘showposts’ => $postcount, ‘category_name’=> ‘your-category-slug’ );

Creating pages and getting their values from the database table

WordPress does not have relationship support among the posts. So for you to do that you have create a new table to store the post id and the linked post id. You need to do custom query every time that table needs to be updated.

Using wp_list_table how to trigger update function “inline”?

ok not the most handsome solution but it works i transported the update function to update.php also wp-load.php $(“.col_visitor”).click(function(){ visitorID = $(this).attr(‘id’); //alert(‘testing ‘+visitorID); $.ajax({ url: ‘update.php’, data: {action: visitorID}, type: ‘post’, success: function(output) { //alert(output); window.location.reload(); //reload so we see the updated values } }); });//#end click

learn to run wpdb class

Arbitrary SQL query can be run via wpdb by using get_results() method: $results = $wpdb->get_results( $query ); You can work through documentation for wpdb at Codex to gain basic understanding of how it works.

Custom post types loop on a page template

I’m not sure this is possible. Why do you need a page template? Why can’t you use a custom post type archive, which is built-in to WordPress ( if you register the post type with has_archive set to true). I’m ignoring all your other possible $args, because I don’t know how you are registering this … Read more

Mysql query and odd results

You have to enclose the OR part to brackets: $sql = “SELECT ID,post_title,post_content,post_date,post_type FROM {$wpdb->posts} WHERE (post_content LIKE {$stuff}) AND post_status=”publish” AND post_type=”{$post_type}” AND ID != {$post->ID} LIMIT {$limit}”; $results= $wpdb->get_results($sql); Try this one: SELECT ID,post_title,post_content,post_date,post_type FROM wp_posts WHERE (post_content LIKE ‘%Battery%’ OR post_content LIKE ‘%Watcher%’ OR post_content LIKE ‘%Widget%’ OR post_content LIKE ‘%matches%’ OR … Read more

Modify query after meta value

Here’s an example using WP_Query‘s meta_query to query posts between two meta key values: $meta_query = array( array( ‘key’ => ‘event_date’, ‘value’ => array( $date_start, $date_end ), ‘compare’ => ‘BETWEEN’ ) ); $args = array( ‘posts_per_page’ => -1, ‘meta_key’ => ‘event_date’, ‘orderby’ => ‘meta_value’, ‘meta_query’ => $meta_query ); $results = new WP_Query( $args );

wordpress category.php query for featured news item, broken pagination and repeating posts

Well first of all, we can get rid of all the query_posts business in the template. There’s always a better method than using query_posts. If the primary goal is to have 5 posts on the first page and 4 on all subsequent pages, we can do that very easily before the query happens via a … Read more

+ More