You can access another database using the wpdb class and its associated methods. You will need to instantiate a new connection to the other database using the appropriate credentials. Here is the basic code to set up the new connection and query the database: $mydb = new wpdb(‘username’,’password’,’database’,’localhost’); $rows = $mydb->get_results(“<your SQL query here>”); Replace … Read more
How to efficiently find “duplicate” posts, where the titles are different, using metadata to match posts?
pre_get_posts is used to modify the query arguments before the query is run. The $query is passed in by reference, so any changes you make in your function will be reflected in the query that’s actually run. The return that you’re doing will be ignored. I think you might be making your problem worse here: … Read more
How to get posts that have certain meta key value and order based on another meta key’s value
Conclusion – In my case I tried below When I changed placement of last meta or at the first place worked perfectly. <?php $price_from = ’20’; $price_to = ‘700’; $meta_query_price[] = array( ‘relation’ => ‘OR’, array( ‘key’ => ‘price_type’, ‘value’ => ‘POA’, ‘type’ => ‘value’, ‘compare’ => ‘LIKE’ ), array( ‘relation’ => ‘AND’, array( ‘key’ … Read more
Why are you using wp_list_pluck? In your query, you use ‘fields’ => ‘ids’ so the return is an array of found post ids. From the codex: ‘ids’ – Return an array of post IDs. Try returning $post_query->posts;
Display Featured image from custom post type category (custom taxonomy) wise
Resolved. My error are there : $FirstDayThisMonth[] = date(‘Y-m-01 00:00:01’, mktime(0, 0, 0, $x, 1)); $LastDayThisMonth[] = date(‘Y-m-t 23:59:59’, mktime(0, 0, 0, $x, 1)); instead of : $datestart = strtotime(date(‘Y-‘.$nbofmonth.’-01 00:00:01′)); $dateend = strtotime(date(‘Y-‘.$nbofmonth.’-t 23:59:59′)); It’s always very annoying to have well written code and to realize that a small element breaks everything
How to prevent WP query searching in executed shortcodes
$args = array( ‘post_type’ => ‘event’, ‘meta_key’ => ‘start_date’, ‘meta_type’ => ‘DATE’, ‘orderby’ => array( ‘start_date’ => ‘ASC’, ‘menu_order’ => ‘ASC’, ) ); $posts = get_posts( $args );