Altering search results to handle a post meta field not working in current WordPress

I got this working through the following combination of functions (credit to this post): function search_join_custom( $join ) { global $wpdb; if ( is_search() ) { $join .=’ LEFT JOIN ‘.$wpdb->postmeta. ‘ ON ‘. $wpdb->posts . ‘.ID = ‘ . $wpdb->postmeta . ‘.post_id ‘; } return $join; } add_filter(‘posts_join’, ‘search_join_custom’ ); function search_where_custom( $where ) … Read more

WordPress search with more input fields?

Sorry, it’s unclear to me what your goal is, if you could clarify your question more and additional information like what kind of options you’re trying to use (are they custom fields, are they categories, tags, or other taxonomies, or another characteristic like post author?) First, the select inputs should not have blank name values. … Read more

What are the available options for “Name” in WP search?

There are two name‘s: The name query variable The name attribute in an input tag The Query Variable name represents the post slug. For example, I have a blog post on my site: https://tomjn.com/2018/07/23/deployment-and-wordpress/ It has this post name: deployment-and-wordpress I can also visit this URL: https://tomjn.com/?name=deployment-and-wordpress I could also find it via WP_Query in … Read more

Form for search pages by meta datas

Take a look at https://developer.wordpress.org/reference/classes/wpdb/get_col/ On your result page, receive the query as follows <?php if(isset($_POST[‘name’]) || isset($_POST[’email’])){ $name=”%” . $wpdb->esc_like( $_POST[‘name’] ) . ‘%’; $email=”%” . $wpdb->esc_like( $_POST[’email’] ) . ‘%’; global $wpdb; $prepare = $wpdb->get_col( $wpdb->prepare( ” SELECT post_id FROM “.$wpdb->prefix.”postmeta AS M WHERE M.meta_value LIKE ‘%s’ OR M.meta_value LIKE ‘%s’ “, $name, … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)