I made some fixes to this code as it doesn’t work anymore. The following code will search the terms to be LIKE the title OR the content OR the meta_value : function custom_search_where( $where ) { if ( is_search() ) { global $wpdb; // Overwrite the existing WHERE clause. $where=””; // Store all search terms … Read more
I’ve done exactly something similar. First, use get_comment_meta for getting the per comment rating, you don’t need the SQL for it. Then get the average rating (addition of individual comment ratings on a single post / number of comments on this post). Then store this average value as post meta for this post. Use WP_Query … Read more
As this is too much for a comment, I’ll post here and delete later: http://example.org // domain ?json=get_recent_posts // controller # Arguments for the query start here &post_type=mytype &custom_fields=myfield &include=title,custom_fields &meta_key=myfield &meta_value=myvalue Have you tried the following? Debug the response: http://www.example.org/api/get_page_index/?dev=1 Widget-style JSONP output: http://www.example.org/api/get_recent_posts/?callback=show_posts_widget&read_more=More&count=3 Redirect on error: http://www.example.org/api/posts/create_post/?callback_error=http%3A%2F%2Fwww.example.org%2Fhelp.html And could you post what you … Read more
use php’s implode to join array elements with a string: <?php if( $bands = get_post_meta($post->ID, ‘band’) ): ?> <strong>Band:</strong> <?php echo implode( $bands, ‘, ‘ ); ?><br /> <?php endif; ?> EDIT- another version of above, pluralizing the label depending on single or multiple meta values: <?php if( $bands = get_post_meta($post->ID, ‘band’) ): $label = … Read more
I changed this line: $wp_rewrite->add_rewrite_tag( ‘%selected_meta%’, ‘([^&]+)’, ‘?meta=” ); Into: $wp_rewrite->add_rewrite_tag( “%selected_meta%’, ‘([^&]+)’, ‘post_type=ervaring&meta=” ); Wich was for both issue 1 and 2 enough to work with.
Solved it with: function myedit_posts_orderby($orderby_statement) { $orderby_statement = “wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC”; return $orderby_statement; } add_filter(‘posts_orderby’, ‘myedit_posts_orderby’); WP_Query… …for some reason WP_Query only applied DESC order to date, and not to meta value.
You code is generating a broken meta_query. You code will produce something like this: array(1) { [“meta_query”]=> array(2) { [0]=> array(2) { [“relation”]=> string(2) “OR” [0]=> array(3) { [“key”]=> string(4) “test” [“value”]=> string(10) “test_value” [“compare”]=> string(4) “LIKE” } } } It should look like this: array(1) { [“meta_query”]=> array(2) { [“relation”]=> string(2) “OR” [0]=> array(3) … Read more
To help you understanding how forms work: They add to the $_POST array by a form fields name argument. <input type=”text” name=”foo” value=”Fooo!” /> would produce $_POST (array) => foo => Fooo! while <input type=”text” name=”foo[bar]” value=”Bar.” /> <input type=”text” name=”foo[baz]” value=”Baz.” /> would produce $_POST (array) => foo => (array) => bar => Bar. … Read more
You are usgin an undefined $post->ID variable because there is no reference to any $post object in your code; instead, use the $post_ID variable retrieved in the function: function on_jobs_publish( $post_ID ) { global $wpdb; $wpdb->insert( ‘iCrewzWp_postmeta’, array( ‘post_id’ => $post_ID, ‘meta_key’ => ‘_yoast_wpseo_sitemap-include’, ‘meta_value’ => ‘always’ ), array( ‘%d’, ‘%s’, ‘%s’ ) ); } … Read more
You just need to add a DISTINCT to your SQL query, something like: $cities = $wpdb->get_col(“SELECT DISTINCT(meta_value) FROM $wpdb->usermeta WHERE meta_key = ‘my_cities_meta_key'” ); Alternatively, if you want to do it with php for some reason (if you want to know that a city is listed twice before displaying only unique entries) $cities = $wpdb->get_col(“SELECT … Read more