Search Job Postings

Use the form below to search through the job postings. You may search by region and/or keywords. Select the regions you would like to search and enter some keywords and click "Search" to continue. eof; $newaction="dosearch"; include("forms/searchForm.php"); break; //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //dosearch //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// case"dosearch": if (($post->searchwords=="") &&($post->region_array=="")){ print<<

Search Job Postings

You must enter at least a keyword or a region to do a search. Please try again.

Use the form below to search through the job postings. You may search by region and/or keywords. Select the regions you would like to search and enter some keywords and click "Search" to continue. eof; $newaction="dosearch"; include("forms/searchForm.php"); include("inc/foot.php"); exit; } $region_array = array(); $region_array = $post->region_array; $searchArray = array(); $searchArray = explode(" ",$post->searchwords); if ($post->region_array != ""){ foreach ($region_array AS $key=>$region_id){ $sqlPart .= " OR region_id='$region_id'"; } } if ($post->search_words !=""){ foreach($searchArray AS $key=>$word){ $sqlPart .= " OR job_description LIKE ('$word') OR job_title LIKE ('$word')"; } } $sql = "SELECT * FROM jobs WHERE job_id is null "; $sql .=$sqlPart." ORDER BY post_date DESC"; $result = $db->query($sql); $numResults = $result->numRows(); if ($numResults == 0){ print<<

Search Job Postings

Your search resulted in 0 matches.. Please try again.

Use the form below to search through the job postings. You may search by region and/or keywords. Select the regions you would like to search and enter some keywords and click "Search" to continue. eof; $newaction="dosearch"; include("forms/searchForm.php"); include("inc/foot.php"); exit; } print<<

Search Results

Your search resulted in $numResults matched jobs.

Click here to search again.

Below is a list of all matched jobs. Click on the job title to view the job posting. eof; $printed=1; while ($result->fetchInto($row)){ if ($printed%2!=0){$class="list1";}else{$class="list2";} $time=new timeConversion; $time->dbdate = $row->post_date; $post_date=$time->datetime2short(); $time->dbdate=$row->modified; $modified=$time->timestamp2short(); if ($row->active ==1){ $status = "Open"; }else{ $status="Filled"; } $region = $db->getOne("SELECT CONCAT(state, ' - ', region_name) FROM regions WHERE region_id='$row->region_id'"); print<< eof; $printed++; } $result->free(); print<<

Job Title	Status	Post Date	Modified	Region
$row->job_title	$status	$post_date	$modified	$region

eof; break; //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //homeregions //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// case"homeregion": $home_region = $db->getOne("SELECT home_region_id FROM users WHERE user_id='$s->suser_id'"); $homeRegion = $db->getOne("SELECT CONCAT(state, ' - ', region_name) FROM regions WHERE region_id='$home_region'"); print<<

Jobs in your Home Region

Your home region is set to $homeRegion.

Here are all the jobs posted in your home region.