-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathapply.php
128 lines (97 loc) · 3.75 KB
/
apply.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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
session_start();
if(empty($_SESSION['id_user'])) {
header("Location: dashboard_candidate.php");
exit();
}
require_once("db.php");
?>
<!doctype html>
<html lang="en">
<head>
<title>Candidate Dashboard</title>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
<link rel="stylesheet" href="assets/vendor/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/vendor/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="assets/vendor/linearicons/style.css">
<link rel="stylesheet" href="assets/vendor/chartist/css/chartist-custom.css">
<link rel="stylesheet" href="dashboard.css">
<link rel="stylesheet" href="assets/css/main.css">
<link rel="stylesheet" href="assets/css/demo.css">
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700" rel="stylesheet">
<link rel="apple-touch-icon" sizes="76x76" href="assets/img/apple-icon.png">
<link rel="icon" type="image/png" sizes="96x96" href="assets/img/favicon.png">
</head>
<body>
<div id="wrapper">
<div id="sidebar-nav" class="sidebar">
<div class="sidebar-scroll">
<nav>
<ul class="nav">
<li><a href="dashboard_candidate.php" class="active"><i class="lnr lnr-home"></i> <span>Dashboard</span></a></li>
<li><a href="page-profile.php" class=""><i class="lnr lnr-user"></i> <span>Profile</span></a></li>
<li><a href="edit-profile.php" class=""><i class="lnr lnr-pencil"></i>Edit Profile</span></a></li>
<li><a href="applied-jobs.php" class=""><i class="lnr lnr-calendar-full"></i></span>Applied Jobs</span></a></li>
<li><a href="jobs.php" class=""><i class="lnr lnr-briefcase"></i> <span>Available Jobs</span></a></li>
<li><a href="logout.php"><i class="lnr lnr-arrow-right-circle"></i> Logout</span></a></li>
</ul>
</nav>
</div>
</div>
<div class="main">
<?php
session_start();
if(empty($_SESSION['id_user'])) {
header("Location: index.php");
exit();
}
require_once("db.php");
if(isset($_GET)) {
$sql = "SELECT * FROM job_post WHERE id_jobpost='$_GET[id]'";
$result = $conn->query($sql);
if($result->num_rows > 0)
{
$row = $result->fetch_assoc();
$id_company = $row['id_company'];
}
$sql1 = "SELECT * FROM apply_job_post WHERE id_user='$_SESSION[id_user]' AND id_jobpost='$row[id_jobpost]'";
$result1 = $conn->query($sql1);
if($result1->num_rows == 0) {
$sql = "INSERT INTO apply_job_post(id_jobpost, id_company, id_user) VALUES ('$_GET[id]', '$id_company', '$_SESSION[id_user]')";
if($conn->query($sql)===TRUE) {
$_SESSION['jobApplySuccess'] = true;
header("Location: applied-jobs.php");
exit();
} else {
echo "Error " . $sql . "<br>" . $conn->error;
}
$conn->close();
} else {
header("Location: jobs.php");
exit();
}
} else {
header("Location: jobs.php");
exit();
}?>
</div>
<!-- END MAIN -->
<div class="clearfix"></div>
<footer>
<div class="container-fluid">
<p class="copyright">© 2018 <a href="#" target="_blank">Job-Portal</a>. All Rights Reserved.</p>
</div>
</footer>
</div>
<!-- END WRAPPER -->
<!-- Javascript -->
<script src="assets/vendor/jquery/jquery.min.js"></script>
<script src="assets/vendor/bootstrap/js/bootstrap.min.js"></script>
<script src="assets/vendor/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<script src="assets/vendor/jquery.easy-pie-chart/jquery.easypiechart.min.js"></script>
<script src="assets/vendor/chartist/js/chartist.min.js"></script>
<script src="assets/scripts/klorofil-common.js"></script>
</body>
</html>