Search for results based on 3 parameters?

[Solarpitch]

Hey Guys,

 

I am trying to code a serarch for results page which will contain 3 parameters...

 

Category

Any

Apartment

Cottage

House

 

Location

Any

Dublin

Cork

Meath

 

Price

Any Price

20000 - 30000

40000 +

 

 

I just want to know whow I handle the sql statement if the search was like..

 

Category: Any

Location: Any

Price: 40000+

 

I am not quite sure how to construct the sql statement based on whether the user has choosen All/ Any of for a specific item as All/ Any would use Select * from..

 

Cheers

 

[Rhysyngsun]

I would generate your SQL statements by concatenating a conditional statement on only if the parameter was not equal to "Any". That way if they do chose "Any", you simply don't append that condition into your SQL statement. If they choose a specific option, then you simply append the relevant condition since that's the only one you're checking for.

[Solarpitch]

Yeah I was think of that alright... just use a switch statement or something. I'll give it a go anyway. cheers

[Solarpitch]

Umm.. I am trying this here but seem to be getting a little lost. Can anyone just show me a quick one line example?

[Rhysyngsun]

Say we assign each category, location, etc. choice an id for simplicity and extensibility ("Any" option will always be 0):

 

$hasWhere = false;
$q = "SELECT * FROM `table`";
if( $category != "0" ) {
if( !hasWhere ) $q .= " WHERE ";
$q .= " 'categoryid' = `$category`";
$hasWhere = true;
}

 

And so on...

 

You will have to make sure you keep track of whether or not you have WHERE in your query yet, as you should have it only once and only then if you have statements to go with it.

[fenway]

Easier to push() onto an array and join with AND at the end.