Ok, so after deeper research I’ve found out that values of some custom fields created by ACF are stored in MySQL database with some additional information like a:5:{i:0;s:6:”Aerial”;i:1;s:6:”Nature”;i:2;s:4:”Nude”;i:3;s:6:”People”;i:4;s:8:”Wildlife”;}. This happens when a custom field can store multiple values (like chechboxes). So I’ve edited part of my query from this: if( !empty($_GET[‘theme’]) ) { $contestTheme = … Read more
1st query: $exclude_post_top_stories=””; // WP_Query arguments $args = array ( ‘post_status’ => array( ‘publish’ ), ‘posts_per_page’ => ‘-1’, ‘order’ => ‘DESC’, ‘orderby’ => ‘date’, ); // The Query $exclude_query = new WP_Query( $args ); // The Loop if ( $exclude_query->have_posts() ) { while ( $exclude_query->have_posts() ) { $exclude_query->the_post(); // do something $exclude_post_top_stories[] = get_the_id(); } … Read more
Okay anyone wanting to achieve this, the code works. Just save the values in the custom field without quotes. e.g. red, car <?php $list = get_field( “main_attributes” ); $array = explode(‘,’, $list); $args = array( ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘style_atrributes’, ‘value’ => $array, ‘compare’ => ‘IN’ ), array( ‘key’ => … Read more
I got it ! Here is my final code for people who will search for similar problem 🙂 in functions.php : function se190254_custom_sql_for_search( ) { global $wpdb; //For security escape the search parameter $search_string = esc_sql($_GET[‘s’]); //Build the SQL request with $wpdb->base_prefix for “portability” $sql = “SELECT SQL_CALC_FOUND_ROWS {$wpdb->base_prefix}posts.ID FROM {$wpdb->base_prefix}posts LEFT JOIN {$wpdb->base_prefix}icl_translations t … Read more
After long searches and tries I ended up with “Pods Framework”. It gives me a choice to store my custom field values to a custom table within wordpress database. Now i am able to query them with other sources (such as other web apps that shares the same database).
I have not tested this, but the idea is to find the post ID based on the post URL, and then update the meta field for that post. I would save that excel as csv format. Import it to a new table in your database. That way you can easily have access to that information, … Read more
If it’s created with ACF, then the way to call the field is like this: $can_download = get_field(‘enable_downloads’,$postid); so your code should look like: <?php global $wp_query; $postid = $wp_query->post->ID; $can_download = get_field(‘enable_downloads’,$postid); if ($can_download == ‘yes’) { ?> <?php } elseif ($can_download == ‘no’) { ?> <?php } elseif ($can_download == ‘other’) { ?> … Read more
It seems to me like this is just a regular addition to functions. Since you are asking, I think you may not be getting the result you are looking for. If this was my project, I would create a new plugin, install it into the regular plugin list so that it does not get overwritten … Read more
Your basic query logic looks fine assuming you want an AND relationship between the first, middle, and last names but query_posts is never, ever, ever the right way to do anything. Note: This function isn’t meant to be used by plugins or themes. As explained later, there are better, more performant options to alter the … Read more
EDIT: If you use $post in a function, you have to define it of course: function xyz(){ global $post; //Your code } Initial answer, might help others: It appears to me, you do not use it inside an action or if so, you use it to early. It should work inside the ‘init’ action. So … Read more