get_users() is a convenience wrapper around WP_User_Query. Maybe you can use that directly, e.g. $user_search = new WP_User_Query( array( ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘meta_key’ => ‘last_login’, //’meta_value’ => ‘DATE_SUB(NOW(),INTERVAL 7 DAY)’, ‘meta_value’ => date(‘Y-m-d H:i’, strtotime(‘-7 days’)), ‘meta_compare’ => ‘<=’, ‘type’ => ‘DATE’, ), array( ‘meta_key’ => ’email_not_logged’, ‘meta_compare’ => ‘NOT EXISTS’, … Read more
You can use a meta_query in addition to your tax_query : https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters I have in which if statement you want to use it so I put it in the of the code. $names = array( ‘fields’ => ‘names’ ); $prac_names = get_terms(‘attorney-practice’, $names); $prac_matches = array_shift(preg_grep (‘(‘. $search .’)’, $prac_names)); $off_names = get_terms(‘office-location’, $names); $off_matches … Read more
As I wrote I expected it to be something I overlooked and it was. If you replace esc_url( get_pagenum_link( $big ) ) with html_entity_decode( get_pagenum_link( $big ) ) it does what it needs to do.
I was able to come up with a solution according to advice from the comments. Working code: function import_shows() { $olddb = new wpdb(constant(“DB_USER”),constant(“DB_PASSWORD”),”THE_DB”,constant(“DB_HOST”)); $sql = “SELECT * FROM shows”; $rows = $olddb->get_results($sql); foreach($rows as $obj) { error_log($obj->name); } return; }
The problem is strictly with your query… or to be more precise, with your misunderstanding of your query 😉 You’ve put || in there and you assume it is OR operator, but… depending on configuration of server it can act as OR or… string concatenation 😉 So change it to OR and it should work … Read more
Pulling an ACF into a query
Problem was that I had a plugin installed that deals with the searches, it’s called Better Search. function query_1($query){ $query .= “,wp_postmeta.meta_value as total_saless “; return $query; } add_filter( ‘bsearch_posts_match_field’, ‘query_1′ ); function query_2($query){ $query .= “AND wp_postmeta.meta_key=’total_sales’ “; return $query; } add_filter( ‘bsearch_posts_where’, ‘query_2’ ); function query_3($query){ $query = ” CAST(total_saless AS INTEGER) > … Read more
This works the same way Google etc work, to search for an exact phrase, wrap it in quotes e.g. online books vs “online books”
Jon, what kind of backup do you have? Often it is the sql statements that would be needed to recreate the content of the site. You could view them in a text editor to see what’s there. if you search for ‘posts’ for example you would find the insert statements to recreate the pages & … Read more
Is there any way to get all custom posts and all custom terms with it’s meta in few queries?