Search by Custom field(s) WordPress

salocine comments:

This seems to go in the right way but I will need the ability to search on individual text field only without a taxonomy selected. So $s only or $s and custom field or custom field only

Daniele Raimondi comments:

It should be just a matter of adding if-else statements here and there:

<?php

global $wp_query;

$continent=mysql_real_escape_string($_GET['continent']);
$size=mysql_real_escape_string($_GET['size']);
$population=mysql_real_escape_string($_GET['population']);

$args = array(
'post_type'=> 'country'
);

if (!empty( $continent ) ) {
$args ['continent'] = $continent;
}

if ( !empty( $size) ) {
$args['meta_query']= array(
array(
'key' => 'size',
'value' => $size,
'type' => 'numeric',
'compare' => 'use one of the available compare operations listed here http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters'
)
);
}
if ( !empty( $population ) ) {
$args['meta_query']= array(
array(
'key' => 'population',
'value' => $population,
'type' => 'numeric',
'compare' => 'use one of the available compare operations listed here http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameter'
)
);
}
$args = array_merge( $wp_query->query, $args );
query_posts($args);
?>


<strong>Remember</strong>: if your search term is <strong>empty</strong>, WP redirect your users to the homepage! So, to avoid redirection, use an input tag like this on search form:

<input class="text" type="text" value="<?php if(trim(wp_specialchars($s,1))!='') echo trim(wp_specialchars($s,1));else echo ' ';?>" name="s" id="s" />
<div class="button">

as suggested [[LINK href="http://accessites.org/site/2009/01/wordpress-empty-searches/"]]here
[[/LINK]]

Daniele Raimondi comments:

if you wanna see a live example of exact the same situation, on this WP site

[[LINK href="http://www.real-dreams.it/"]]http://www.real-dreams.it/[[/LINK]]

made by my webagency (sorry but english is not available for now), there's a search form in home page where you can:

1) search in a custom post type (announcements)
2) search (optionally) on a custom taxonomy (named tipologia with 2 terms, boats and cars)
3) use 2 custom fields with a min and a max price for filtering the posts

it uses the same code logic described above and if you leave all fields empty, it returns all announcements (for both terms in taxonomy "tipologia", cars and boats); and you can make a search with every combination of values and fields .

salocine comments:

Thanks Daniele,
I will try this tomorrow and let you know

salocine comments:

Daniele, I cant get it to work.
I tried your website and it doesn't seem to find any result when searching by price (custom field)

Could you post the full code, including the search form and the search template with loop?

Daniele Raimondi comments:

The first field is the min price, while the second is the max price. Just insert a min value only, a max value only or a range (with min<max of course) and you should view a list of results.

Try for example a max price of 130000 and you should find 3 cars (no boats under 130000 euros, sorry ;D )

here you can find the code for the form template file

http://pastebin.com/Jctkjajk

and here the code for the serach results template file

http://pastebin.com/BJ1vu2WS