-
Notifications
You must be signed in to change notification settings - Fork 0
/
JobQuery.php
48 lines (41 loc) · 2.05 KB
/
JobQuery.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<?php
include 'connection.php';
$Freelance = $_POST['Freelance'];
$FreelanceType = $_POST['FreelanceType'];
$HireType = $_POST['HireType'];
$PriceCheck = $_POST['PriceCheck'];
$HourlyMinRate = $_POST['HourlyMinRate'];
$HourlyMaxRate = $_POST['HourlyMaxRate'];
$PaymentVerified = $_POST['PaymentVerified'];
if($HourlyMinRate && $HourlyMaxRate){
$hourly = " hourly_rate_min >= '".$HourlyMinRate."' and hourly_rate_max <= '".$HourlyMaxRate."' ";
}
elseif($HourlyMinRate && !$HourlyMaxRate){
$hourly = " hourly_rate_min >= '".$HourlyMinRate."' ";
}
elseif(!$HourlyMinRate && $HourlyMaxRate){
$hourly = " hourly_rate_max <= '".$HourlyMaxRate."' ";
}
else{
$hourly = "hourly_rate_min is not null and hourly_rate_max is not null";
}
$query = 'select * from jobs where '.$Freelance.' and '.$FreelanceType.' and '.$hourly.' and '.$PaymentVerified.' and '.$HireType.' ';
$result = mysqli_query($conn,$query);
while($data = mysqli_fetch_row($result))
{
echo "<a href='#' onclick='openJob()' class='title font-weight-bold'>". $data[1] ."</a>";
echo "<p class='insight'>Hourly $ " .$data[7]." - "." $ ".$data[8]." | Freelancer Level : ".$data[6]." | Est Time : ".$data[9]." | Posted : ". date("F j, Y, g:i a", strtotime($data[25]))."</p>";
echo "<div class='detail'>".$data[4]."</div>";
echo "<br>";
echo "<div class='skill-tags'>";
echo "<p class='tag border rounded-pill'>".$data[16]."</p>";
echo "<p class='tag border rounded-pill'>".$data[17]."</p>";
echo "<p class='tag border rounded-pill'>".$data[18]."</p>";
echo "<p class='tag border rounded-pill'>".$data[19]."</p>";
echo "<p class='tag border rounded-pill'>".$data[20]."</p>";
echo "<p class='tag border rounded-pill'>".$data[21]."</p>";
echo "</div>";
echo "<p>proposals less than <b></b>".$data[24]."</b></p>";
echo "<p>payment : ".$data[23]." - $".$data[14]." spent - Location : ".$data[15]."</p>";
}
?>