I didn’t entirely resolved my problem. My client changed his mind and didn’t want the sorting anymore. But concerning the paging, I managed to have it working by adding a new arg in my query, here is the code that made it worked for me : <?php $paged = (get_query_var(‘paged’)) ? get_query_var(‘paged’) : 1; $args … Read more
Why don’t you directly echo the $num as it will contain the count of rows already…Here’s the edited part.. //To show number of rows in table function DB_Tables_Rows() { global $wpdb; $table_name = $wpdb->prefix . ‘mydata’; $count_query = “select count(*) from $table_name”; $num = $wpdb->get_var($count_query); echo $num . ‘Rows Found’; }
Before we look at pagination, from what I have picked up in your question, you only need terms starting with A. If so, you can make use of the name__like parameter in get_terms to get terms only that starts with A. Just a note on that, the operation of the parameter was changed in WordPress … Read more
Here is another way of doing it, specially if you need to work with the query object. The issue with merging queries is that you loose the correctness of the query object. My idea here is to run two separate queries, one very lean one to get post ID’s from the date_query query and then … Read more
Yes, it’s possible to loop all publish posts and change their post status to draft. add_action(‘admin_init’,’wpse_244394′); function wpse_244394(){ $args = array(‘post_type’=> ‘post’, ‘post_status’ => ‘publish’, ‘posts_per_page’=>-1 ); $published_posts = get_posts($args); foreach($published_posts as $post_to_draft){ $query = array( ‘ID’ => $post_to_draft->ID, ‘post_status’ => ‘draft’, ); wp_update_post( $query, true ); } }
It is possible, using the date_query argument. By default this uses the publication date, but you can tell it to use the modified date by using the column argument. So if you wanted to query all posts modified after June 30th 2019, you’d use: ‘date_query’ => [ ‘column’ => ‘post_modified’, ‘after’ => [ ‘year’ => … Read more
See this codex page. in wp-config.php: define(‘SAVEQUERIES’, true); then in your template: if (current_user_can(‘administrator’)){ global $wpdb; echo “<pre>”; print_r($wpdb->queries); echo “</pre>”; } or without the above SAVEQUERIES, you can still see just the main query: global $wp_query; echo $wp_query->request; or to see all of $wp_query: <pre> <?php print_r($wp_query); ?> </pre>
You should read in this answer it explains it in depth. in short, $wp_query is the variable that holds a copy of $wp_the_query global query that could/can be modified by plugins and themes $wp_the_query is the variable that holds an unmodified copy of the global query object and used to reset the $wp_query object when … Read more
I got the same problem. Try this ! Works for me <?php $featured_query = new WP_Query( array( ‘tax_query’ => array( array( ‘taxonomy’ => ‘product_visibility’, ‘field’ => ‘name’, ‘terms’ => ‘featured’, ‘operator’ => ‘IN’ ), ), ) ); ?>
tax_query is a 2-dimensional array, each sub-array can be considered to be a taxonomy query, typical its of the form: array( ‘taxonomy’ => ‘people’, ‘field’ => ‘slug’, ‘terms’ => ‘bob’ ) (e.g. posts in with the term with slug ‘bob’, of the ‘people’ taxonomy). The fact that tax_query is a two dimensional array means that … Read more