-
Notifications
You must be signed in to change notification settings - Fork 0
/
view_all_jobs.php
98 lines (67 loc) · 2.29 KB
/
view_all_jobs.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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<!DOCTYPE html>
<html lang="en">
<head>
<title>All Jobs</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="https://cloud.tinymce.com/stable/tinymce.min.js"></script>
<script>tinymce.init({ selector:'textarea' });</script>
<style type="text/css">
.jobs_link a{
text-decoration: none;
}
#link a{
text-decoration:none;
}
.jumbotron:hover{
background: #fffbc7;
}
</style>
</head>
<body>
<?php include('navbar.php'); ?>
<br>
<div class="container">
<div class="col-md-10 col-md-offset-1">
<?php
include('database.php');
$sql="SELECT * FROM all_jobs";
$select =mysqli_query($connect,$sql);
if (mysqli_num_rows($select) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($select))
{
?>
<div class="jobs_link">
<a style="text-decoration: none;" href="view_details.php?job_id=<?php echo $row['all_jobs_id'] ?>"
target="_blank">
<div class="jumbotron">
<h3 style="color: green"><?php echo $row["company_name"] ?></h3>
<h3 style="color: purple"><?php echo $row["position_name"] ?></h3>
<table>
<tr>
<td><h5 style="font-weight: bold;">Education</h5></td>
<td>:</td>
<td>      <?php echo $row["educational_requirements"] ?></td>
</tr>
<tr>
<td><h5 style="font-weight: bold;">Experience</h5></td>
<td>:</td>
<td>      <?php echo $row["experience_requirement"] ?></td>
</tr>
</table>
</div>
</a>
</div>
<?php
}
}
?>
</div>
</div>
<?php include('footer.php'); ?>
</body>
</html>