Search form code

[graham23s]

Hi Guys,

 

i think i have found a way to piece together a search query using a plain form, if the user select "Search All" which has the value 0 i do this:

 

<?php
  ## gender options #################################################
  if($gender == 'M' || $gender =='F') {
  
  $searchquery .= "WHERE `gender`='$gender' "; 
  
  } elseif($gender == 0) {
  
  // do nothing with the query
  
  }
  ## gender options #################################################
?>

 

what i'm wondering is, if this would work for all the fields, if it's X then search X from the database else carry on (ie select all)

 

just curious before i do a lot of editing that might not work.

 

cheers guys

 

Graham

[pocobueno1388]

Yes, you are doing it correctly...just to make sure, here is an example.

 

<?php

$query = "SELECT col FROM table WHERE";

if (isset($gender)) $query .= " AND gender='$gender'";
if (isset($country)) $query .= " AND country='$country'";

//...and so on

?>

[graham23s]

Hi Poco,

 

ah yeah the isset so instead of

 

  if($gender == 'M' || $gender =='F') {
  
  $searchquery .= "WHERE `gender`='$gender' "; 
  
  } elseif($gender == 0) {
  
  // do nothing
  
  }

 

i could do

 

if(isset($var)) {
  // query here etc
}

 

thanks mate

 

Graham