-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAdmin-Homepage.php
More file actions
49 lines (48 loc) · 1.69 KB
/
Copy pathAdmin-Homepage.php
File metadata and controls
49 lines (48 loc) · 1.69 KB
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
<?php require 'Admin-Dashboard.php';
if(!isset($_SESSION['adminid'])){
header('Location: Admin-Login.php');
}
?>
<div class="box">
<table class="table table-hover">
<thead>
<tr>
<th scope="col">Id</th>
<th scope="col">Job Id</th>
<th scope="col">User Id</th>
<th scope="col">Candidate Name</th>
<th scope="col">Company</th>
<th scope="col">Position</th>
<th scope="col">Qualification</th>
<th scope="col">Stream</th>
<th scope="col">Percentage</th>
<th scope="col">Year</th>
</tr>
</thead>
<tbody>
<?php
require 'PHP/db.php';
$query = "SELECT * FROM CAPPLIED";
$result = mysqli_query($conn,$query);
while($row = mysqli_fetch_assoc($result)){
echo "Hello";
$jid = $row['JID'];
$que = "SELECT * FROM CAREERS WHERE JID = '$jid'";
$ans = mysqli_query($conn,$que);
$roww = mysqli_fetch_assoc($ans);
echo "<tr>
<th scope='row'>".$row['AID']."</th>
<td>".$row['JID']."</td>
<td>".$row['ID']."</td>
<td>".$row['FULLNAME']."</td>
<td>".$roww['COMPANYNAME']."</td>
<td>".$roww['POSITION']."</td>
<td>".$row['QUAL']."</td>
<td>".$row['STREAM']."</td>
<td>".$row['GPA']."</td>
<td>".$row['YEAR']."</td>";
}
?>
</tbody>
</table>
</div>