Try using sanitize_text_field instead of esc_html wp> $search_query = “Dalton’s Law <br/>”; string(18) “Dalton’s Law <br/>” wp> $query = apply_filters( ‘get_search_query’, $search_query ); string(18) “Dalton’s Law <br/>” wp> $esc_html = esc_html( $query ); string(29) “Dalton's Law <br/>” wp> $sanitized = sanitize_text_field( $query ); string(12) “Dalton’s Law” esc_html should be used to escape output before it … Read more
After a full investigation and a lot more debugging and code tempering I found out that using “date” as a meta field name generate a lot of “confusion” inside the wordrpess query itself as wordpress confuse the meta_query “date” field with the “date” itself, to avoid all this the solution is simply changing the name … Read more
What is missing? One tiny detail… And it’s easy to overlook… the_field(‘datum_event’); Prints the field using the format you’ve defined in field settings. But… It has nothing to do with how the value of that field is stored in DB. ACF uses YYYYMMDD format when storing date values in DB. And WP_Query doesn’t use field … Read more
Try removing they value from your meta query: $args = array( ‘orderby’ => ‘display_name’, ‘meta_query’ => array( array( ‘key’ => ‘member’, ‘compare’ => ‘!=’, ), ), ); $users = get_users($args);
First of all, just to clarify, in a normal situation without the specific order requirements, and assuming you are doing this on pre_get_posts hook, you would just do as follows: add_action(‘pre_get_posts’, function ($query) { // only perform for a given query // do your checks and return early if (! $query->is_main_query() || ! $query->is_home()) { … Read more
You can’t easily query inside arrays inside a meta value. This is because there’s no such thing as an array value in MySQL. Instead the value is stored as a serialized string. So an array like this: array( 0 => 29, 1 => 28, ); Is stored in the database as this string: a:2:{i:0;i:29;i:1;i:28;} So … Read more
You could try to use the REGEX compare option for the meta_query, like so: ‘meta_query’ => array( array( ‘key’ => ‘company_address_zip_code’, ‘value’ => ‘^29@’, ‘compare’ => ‘REGEXP’, ) )
It looks like it is the date format. I tried it with the format 2020/10/10 (YYYY/MM/DD) and it worked as expected. You can also use hyphens as delimiters (YYYY-MM-DD), or omit them entirely. Since you’ve already formatted the date, you don’t need to use the date() function. $metas[] = array( ‘key’ => ‘event_date’, ‘value’ => … Read more
Besides the plugin not being updated, this will not work because the meta_query arg is evaluated as a string: array(3) { [“post_type”] => string(7) “project” [“meta_query”] => string(96) “array(array(‘key’ => ‘state’, ‘value’ => ‘Completed’),array(‘key’ => ‘year’,’value’ => ‘2006’))” [“suppress_filters”] => string(5) “false” } I suggest you make a custom page template, where you would directly … Read more
Answer taken from here: meta_query: using BETWEEN with floats and/or casting to DECIMAL add_filter(‘get_meta_sql’,’cast_decimal_precision’); function cast_decimal_precision( $array ) { $array[‘where’] = str_replace(‘DECIMAL’,’DECIMAL(5,2)’,$array[‘where’]); return $array; }