I want to include a boolean search box in my existing script in the vResume_screen variable. I have altered the table for hte full text search and need your help.
if(!empty($_GET)){
$vResume_screen=$_REQUEST['vResume_screen'];
$date_screen=$_REQUEST['date_screen'];
$vFirstname=$_REQUEST['vFirstname'];
$vLastName=$_REQUEST['vLastName'];
$vJobTittle_screen=$_REQUEST['vJobTittle_screen'];
$vVisa=$_REQUEST['vVisa'];
$InterestP=$_REQUEST['InterestP'];
$VErecruitername=$_REQUEST['VErecruitername'];
$vLastName=$_REQUEST['vLastName'];
$where_clause=array();
if(!empty($vResume_screen))
{
$where_clause[]="resume_text like '%".$vResume_screen."%'";
}
if(!empty($_POST['vIndustry']))
{
foreach ($_POST['vIndustry'] as $data1=>$val1)
{
$industr .= $val1.",";
}
$industr=substr($industr,0,-1);
$where_clause[]="industry like '%".$industr."%'";
}
if(!empty($vFirstname))
{
$where_clause[]="first_name like '".$vFirstname."%'";
}
if(!empty($vLastName))
{
$where_clause[]="last_name like '".$vLastName."%'";
}
if(!empty($VErecruitername))
{
$where_clause[]="recruiter_name='".$VErecruitername."'";
}
if(!empty($InterestP))
{
$where_clause[]="cur_state like '%".$InterestP."%'";
}
if(!empty($vVisa))
{
$where_clause[]="visa_status='".$vVisa."'";
}
if(!empty($vJobTittle_screen))
{
$where_clause[]="job_title like '%".$vJobTittle_screen."%'";
}
if(!empty($vState_screen))
{
$where_clause[]="cur_state='".$vState_screen."'";
}
if(!empty($date_screen))
{
$where_clause[]="available_date=".$date_screen."";
}
$where=implode(" and ", $where_clause);
$query="select * from resumes where ".$where."ORDER BY $order";
$rowsPerPage = 50;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$query="select * from resumes where ".$where." ORDER BY $order limit $offset,$rowsPerPage";
$result=mysql_query($query);
if($query=="select * from resumes where "){
exit();
}
$res=mysql_query($query);
$count=@mysql_num_rows($res);
?>
Thanks in advance.