|
Server : LiteSpeed System : Linux terra.hostitbro.com 5.14.0-611.54.3.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu May 7 16:31:24 EDT 2026 x86_64 User : outerorb ( 1091) PHP Version : 8.1.34 Disable Function : mail Directory : /home6/outerorb/career.outerorbittech.com/admin/ | |
|
Path: //home6/outerorb/career.outerorbittech.com/admin/data.php
Size: 30.61 KB
Permissions: 0644
<?php
ob_start();
session_start();
if($_SESSION['aid']!=session_id())
{
header("location:../login.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>ADMIN - DATA </title>
<!-- Meta -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="Portal - Bootstrap 5 Admin Dashboard Template For Developers">
<meta name="author" content="Xiaoying Riley at 3rd Wave Media">
<link href="../img/favicon.png" rel="icon">
<!-- FontAwesome JS-->
<script defer src="assets/plugins/fontawesome/js/all.min.js"></script>
<script defer src='http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js'></script>
<!-- App CSS -->
<link id="theme-style" rel="stylesheet" href="assets/css/portal.css">
</head>
<body class="app">
<header class="app-header fixed-top">
<div class="app-header-inner">
<div class="container-fluid py-2">
<div class="app-header-content">
<div class="row justify-content-between align-items-center">
<div class="col-auto">
<a id="sidepanel-toggler" class="sidepanel-toggler d-inline-block d-xl-none" href="#">
<svg xmlns="http://www.w3.org/2000/svg" width="30" height="30" viewBox="0 0 30 30" role="img"><title>Menu</title><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg>
</a>
</div><!--//col-->
<div class="search-mobile-trigger d-sm-none col">
<i class="search-mobile-trigger-icon fa-solid fa-magnifying-glass"></i>
</div><!--//col-->
<div class="app-search-box col">
<form class="app-search-form" action=" " method="POST">
<input type="search" placeholder="Search..." name="n" class="form-control search-input">
<button type="submit" name="s" class="btn search-btn btn-primary" value="Search"><i class="fa-solid fa-magnifying-glass"></i></button>
</form>
</div><!--//app-search-box-->
<div class="app-utilities col-auto">
<div class="app-utility-item app-notifications-dropdown dropdown">
<div class="app-utility-item app-user-dropdown dropdown" style="background-color:#F6F7EA ;">
<a class="dropdown-toggle" id="user-dropdown-toggle" data-bs-toggle="dropdown" href="" role="button" aria-expanded="false"><img src="assets/images/OOT1.png" alt="user profile"></a>
<ul class="dropdown-menu" aria-labelledby="user-dropdown-toggle">
<li><a class="dropdown-item" href="../end.php" style="color:red;font-weight:600; font-size: 30px;text-align:right; ">LOGOUT</a></li>
</ul>
</div><!--//app-user-dropdown-->
</div><!--//app-utilities-->
</div><!--//row-->
</div><!--//app-header-content-->
</div><!--//container-fluid-->
</div><!--//app-header-inner-->
<div id="app-sidepanel" class="app-sidepanel">
<div id="sidepanel-drop" class="sidepanel-drop"></div>
<div class="sidepanel-inner d-flex flex-column">
<a href="#" id="sidepanel-close" class="sidepanel-close d-xl-none">×</a>
<div class="app-branding">
<a class="app-logo" href="index.php"><span class="logo-text"><img src="assets/images/logo.png" width="80%" height="140%" alt="logo"></span></a>
</div><!--//app-branding-->
<nav id="app-nav-main" class="app-nav app-nav-main flex-grow-1">
<ul class="app-menu list-unstyled accordion" id="menu-accordion">
<li class="nav-item">
<!--//Bootstrap Icons: https://icons.getbootstrap.com/ -->
<a class="nav-link" href="index.php">
<span class="nav-icon">
<svg width="1em" height="1em" viewBox="0 0 16 16" class="bi bi-house-door" fill="currentColor" xmlns="http://www.w3.org/2000/svg">
<path fill-rule="evenodd" d="M7.646 1.146a.5.5 0 0 1 .708 0l6 6a.5.5 0 0 1 .146.354v7a.5.5 0 0 1-.5.5H9.5a.5.5 0 0 1-.5-.5v-4H7v4a.5.5 0 0 1-.5.5H2a.5.5 0 0 1-.5-.5v-7a.5.5 0 0 1 .146-.354l6-6zM2.5 7.707V14H6v-4a.5.5 0 0 1 .5-.5h3a.5.5 0 0 1 .5.5v4h3.5V7.707L8 2.207l-5.5 5.5z"/>
<path fill-rule="evenodd" d="M13 2.5V6l-2-2V2.5a.5.5 0 0 1 .5-.5h1a.5.5 0 0 1 .5.5z"/>
</svg>
</span>
<span class="nav-link-text">OVERVIEW</span>
</a><!--//nav-link-->
</li><!--//nav-item-->
<li class="nav-item">
<!--//Bootstrap Icons: https://icons.getbootstrap.com/ -->
<a class="nav-link" href="docs.php">
<span class="nav-icon">
<svg width="1em" height="1em" viewBox="0 0 16 16" class="bi bi-folder" fill="currentColor" xmlns="http://www.w3.org/2000/svg">
<path d="M9.828 4a3 3 0 0 1-2.12-.879l-.83-.828A1 1 0 0 0 6.173 2H2.5a1 1 0 0 0-1 .981L1.546 4h-1L.5 3a2 2 0 0 1 2-2h3.672a2 2 0 0 1 1.414.586l.828.828A2 2 0 0 0 9.828 3v1z"/>
<path fill-rule="evenodd" d="M13.81 4H2.19a1 1 0 0 0-.996 1.09l.637 7a1 1 0 0 0 .995.91h10.348a1 1 0 0 0 .995-.91l.637-7A1 1 0 0 0 13.81 4zM2.19 3A2 2 0 0 0 .198 5.181l.637 7A2 2 0 0 0 2.826 14h10.348a2 2 0 0 0 1.991-1.819l.637-7A2 2 0 0 0 13.81 3H2.19z"/>
</svg>
</span>
<span class="nav-link-text">Candidate</span>
</a><!--//nav-link-->
</li><!--//nav-item-->
<li class="nav-item">
<!--//Bootstrap Icons: https://icons.getbootstrap.com/ -->
<a class="nav-link active" href="data.php">
<span class="nav-icon">
<svg width="1em" height="1em" viewBox="0 0 16 16" class="bi bi-card-list" fill="currentColor" xmlns="http://www.w3.org/2000/svg">
<path fill-rule="evenodd" d="M14.5 3h-13a.5.5 0 0 0-.5.5v9a.5.5 0 0 0 .5.5h13a.5.5 0 0 0 .5-.5v-9a.5.5 0 0 0-.5-.5zm-13-1A1.5 1.5 0 0 0 0 3.5v9A1.5 1.5 0 0 0 1.5 14h13a1.5 1.5 0 0 0 1.5-1.5v-9A1.5 1.5 0 0 0 14.5 2h-13z"/>
<path fill-rule="evenodd" d="M5 8a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7A.5.5 0 0 1 5 8zm0-2.5a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7a.5.5 0 0 1-.5-.5zm0 5a.5.5 0 0 1 .5-.5h7a.5.5 0 0 1 0 1h-7a.5.5 0 0 1-.5-.5z"/>
<circle cx="3.5" cy="5.5" r=".5"/>
<circle cx="3.5" cy="8" r=".5"/>
<circle cx="3.5" cy="10.5" r=".5"/>
</svg>
</span>
<span class="nav-link-text">All Data</span>
</a><!--//nav-link-->
</li><!--//nav-item-->
<li class="nav-item">
<!--//Bootstrap Icons: https://icons.getbootstrap.com/ -->
<a class="nav-link" href="export.php">
<span class="nav-icon">
<svg xmlns="http://www.w3.org/2000/svg" width="1em" height="1em" fill="currentColor" class="bi bi-arrow-down-circle" viewBox="0 0 16 16">
<path fill-rule="evenodd" d="M1 8a7 7 0 1 0 14 0A7 7 0 0 0 1 8zm15 0A8 8 0 1 1 0 8a8 8 0 0 1 16 0zM8.5 4.5a.5.5 0 0 0-1 0v5.793L5.354 8.146a.5.5 0 1 0-.708.708l3 3a.5.5 0 0 0 .708 0l3-3a.5.5 0 0 0-.708-.708L8.5 10.293V4.5z"/>
</svg>
</span>
<span class="nav-link-text" style="color:green;">EXPORT</span>
</a><!--//nav-link-->
</li><!--//nav-item-->
<li class="nav-item">
<!--//Bootstrap Icons: https://icons.getbootstrap.com/ -->
<a class="nav-link" href="../end.php">
<span class="nav-icon">
<svg xmlns="http://www.w3.org/2000/svg" width="1em" height="1em" fill="currentColor" class="bi bi-x-circle" viewBox="0 0 16 16">
<path d="M8 15A7 7 0 1 1 8 1a7 7 0 0 1 0 14zm0 1A8 8 0 1 0 8 0a8 8 0 0 0 0 16z"/>
<path d="M4.646 4.646a.5.5 0 0 1 .708 0L8 7.293l2.646-2.647a.5.5 0 0 1 .708.708L8.707 8l2.647 2.646a.5.5 0 0 1-.708.708L8 8.707l-2.646 2.647a.5.5 0 0 1-.708-.708L7.293 8 4.646 5.354a.5.5 0 0 1 0-.708z"/>
</svg>
</span>
<span class="nav-link-text" style="color:red;font-weight:600;">LOG OUT</span>
</a><!--//nav-link-->
</li><!--//nav-item-->
</ul><!--//app-menu-->
</nav><!--//app-nav-->
<div class="app-sidepanel-footer">
<nav class="app-nav app-nav-footer">
<ul class="app-menu footer-menu list-unstyled">
</ul><!--//footer-menu-->
</nav>
</div><!--//app-sidepanel-footer-->
</div><!--//sidepanel-inner-->
</div><!--//app-sidepanel-->
</header><!--//app-header-->
<div class="app-wrapper">
<div class="app-content pt-3 p-md-3 p-lg-4">
<div class="container-xl">
<div class="row g-3 mb-4 align-items-center justify-content-between">
<div class="col-auto">
<h1 class="app-page-title mb-0">APPLICATION</h1>
</div>
<div class="col-auto">
<div class="page-utilities">
<div class="row g-2 justify-content-start justify-content-md-end align-items-center">
<div class="col-auto">
<div class="col-auto">
</div>
<div class="col-auto">
</div>
</form>
</div><!--//col-->
<div class="col-auto">
</div>
<div class="col-auto">
<a class="btn app-btn-secondary" href="../index.php" style="color:red;">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="red" class="bi bi-plus-square" viewBox="0 0 16 16">
<path d="M14 1a1 1 0 0 1 1 1v12a1 1 0 0 1-1 1H2a1 1 0 0 1-1-1V2a1 1 0 0 1 1-1h12zM2 0a2 2 0 0 0-2 2v12a2 2 0 0 0 2 2h12a2 2 0 0 0 2-2V2a2 2 0 0 0-2-2H2z"/>
<path d="M8 4a.5.5 0 0 1 .5.5v3h3a.5.5 0 0 1 0 1h-3v3a.5.5 0 0 1-1 0v-3h-3a.5.5 0 0 1 0-1h3v-3A.5.5 0 0 1 8 4z"/>
</svg>
ADD APPLICANT
</a>
</div>
<div class="col-auto">
<a class="btn app-btn-secondary" href="export.php">
<svg width="1em" height="1em" viewBox="0 0 16 16" class="bi bi-download me-1" fill="currentColor" xmlns="http://www.w3.org/2000/svg">
<path fill-rule="evenodd" d="M.5 9.9a.5.5 0 0 1 .5.5v2.5a1 1 0 0 0 1 1h12a1 1 0 0 0 1-1v-2.5a.5.5 0 0 1 1 0v2.5a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2v-2.5a.5.5 0 0 1 .5-.5z"/>
<path fill-rule="evenodd" d="M7.646 11.854a.5.5 0 0 0 .708 0l3-3a.5.5 0 0 0-.708-.708L8.5 10.293V1.5a.5.5 0 0 0-1 0v8.793L5.354 8.146a.5.5 0 1 0-.708.708l3 3z"/>
</svg>
Download Report
</a>
</div>
</div><!--//row-->
</div><!--//table-utilities-->
</div><!--//col-auto-->
</div><!--//row-->
<nav id="orders-table-tab" class="orders-table-tab app-nav-tabs nav shadow-sm flex-column flex-sm-row mb-4">
<a class="flex-sm-fill text-sm-center nav-link active" id="orders-all-tab" data-bs-toggle="tab" href="#all" role="tab" aria-controls="orders-all" aria-selected="true">All</a>
<a class="flex-sm-fill text-sm-center nav-link" id="orders-paid-tab" data-bs-toggle="tab" href="#Finance" role="tab" aria-controls="orders-paid" aria-selected="false">Finance Support</a>
<a class="flex-sm-fill text-sm-center nav-link" id="orders-pending-tab" data-bs-toggle="tab" href="#Customer" role="tab" aria-controls="orders-pending" aria-selected="false">Customer Process</a>
<a class="flex-sm-fill text-sm-center nav-link" id="orders-pending-tab" data-bs-toggle="tab" href="#Technical" role="tab" aria-controls="orders-pending" aria-selected="false">Technical Associate</a>
<a class="flex-sm-fill text-sm-center nav-link" id="orders-cancelled-tab" data-bs-toggle="tab" href="#Digital" role="tab" aria-controls="orders-cancelled" aria-selected="false">Digital Marketing</a>
<a class="flex-sm-fill text-sm-center nav-link" id="orders-cancelled-tab" data-bs-toggle="tab" href="#Php" role="tab" aria-controls="orders-cancelled" aria-selected="false">PHP Developer</a>
</nav>
<div class="tab-content" id="orders-table-tab-content">
<div class="tab-pane fade show active" id="all" role="tabpanel" aria-labelledby="orders-all-tab">
<div class="app-card app-card-orders-table shadow-sm mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table class="table app-table-hover mb-0 text-left" >
<thead>
<tr>
<th class="cell">ID</th>
<?php
include"connection.php";
$field='reg_id';
$sort='ASC';
if(isset($_POST['s']))
{
$n=$_POST['n'];
$qe="select * from aplicant where name like '%".$n."%' or post like '".$n."%'";
}
else
{
if(isset($_GET['sorting']))
{
if($_GET['sorting']=='ASC')
{
$sort='DESC';
}
else
{
$sort='ASC';
}
}
if(isset($_GET['field']))
{
if($_GET['field']=='name')
{
$field = "name";
}
elseif($_GET['field']=='date')
{
$field="date";
}
}
$qe="select * from aplicant ORDER BY $field $sort";
}
$sqe=mysqli_query($cn,$qe);
echo'
<th class="cell">NAME <span> <a href="data.php?sorting='.$sort.'&field=name">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="green" class="bi bi-sort-alpha-down" viewBox="0 0 16 16">
<path fill-rule="evenodd" d="M10.082 5.629 9.664 7H8.598l1.789-5.332h1.234L13.402 7h-1.12l-.419-1.371h-1.781zm1.57-.785L11 2.687h-.047l-.652 2.157h1.351z"/>
<path d="M12.96 14H9.028v-.691l2.579-3.72v-.054H9.098v-.867h3.785v.691l-2.567 3.72v.054h2.645V14zM4.5 2.5a.5.5 0 0 0-1 0v9.793l-1.146-1.147a.5.5 0 0 0-.708.708l2 1.999.007.007a.497.497 0 0 0 .7-.006l2-2a.5.5 0 0 0-.707-.708L4.5 12.293V2.5z"/>
</svg>
</a>
<a href="data.php?sorting='.$sort.'&field=name">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="red" class="bi bi-sort-alpha-down-alt" viewBox="0 0 16 16">
<path d="M12.96 7H9.028v-.691l2.579-3.72v-.054H9.098v-.867h3.785v.691l-2.567 3.72v.054h2.645V7z"/>
<path fill-rule="evenodd" d="M10.082 12.629 9.664 14H8.598l1.789-5.332h1.234L13.402 14h-1.12l-.419-1.371h-1.781zm1.57-.785L11 9.688h-.047l-.652 2.156h1.351z"/>
<path d="M4.5 2.5a.5.5 0 0 0-1 0v9.793l-1.146-1.147a.5.5 0 0 0-.708.708l2 1.999.007.007a.497.497 0 0 0 .7-.006l2-2a.5.5 0 0 0-.707-.708L4.5 12.293V2.5z"/>
</svg>
</a></span>
</th>
<th class="cell">MOBILE</th>
<th class="cell">DATE <span> <a href="data.php?sorting='.$sort.'&field=date">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="green" class="bi bi-sort-numeric-down" viewBox="0 0 16 16">
<path d="M12.438 1.668V7H11.39V2.684h-.051l-1.211.859v-.969l1.262-.906h1.046z"/>
<path fill-rule="evenodd" d="M11.36 14.098c-1.137 0-1.708-.657-1.762-1.278h1.004c.058.223.343.45.773.45.824 0 1.164-.829 1.133-1.856h-.059c-.148.39-.57.742-1.261.742-.91 0-1.72-.613-1.72-1.758 0-1.148.848-1.835 1.973-1.835 1.09 0 2.063.636 2.063 2.687 0 1.867-.723 2.848-2.145 2.848zm.062-2.735c.504 0 .933-.336.933-.972 0-.633-.398-1.008-.94-1.008-.52 0-.927.375-.927 1 0 .64.418.98.934.98z"/>
<path d="M4.5 2.5a.5.5 0 0 0-1 0v9.793l-1.146-1.147a.5.5 0 0 0-.708.708l2 1.999.007.007a.497.497 0 0 0 .7-.006l2-2a.5.5 0 0 0-.707-.708L4.5 12.293V2.5z"/>
</svg>
</a>
<a href="data.php?sorting='.$sort.'&field=date">
<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="red" class="bi bi-sort-numeric-down-alt" viewBox="0 0 16 16">
<path fill-rule="evenodd" d="M11.36 7.098c-1.137 0-1.708-.657-1.762-1.278h1.004c.058.223.343.45.773.45.824 0 1.164-.829 1.133-1.856h-.059c-.148.39-.57.742-1.261.742-.91 0-1.72-.613-1.72-1.758 0-1.148.848-1.836 1.973-1.836 1.09 0 2.063.637 2.063 2.688 0 1.867-.723 2.848-2.145 2.848zm.062-2.735c.504 0 .933-.336.933-.972 0-.633-.398-1.008-.94-1.008-.52 0-.927.375-.927 1 0 .64.418.98.934.98z"/>
<path d="M12.438 8.668V14H11.39V9.684h-.051l-1.211.859v-.969l1.262-.906h1.046zM4.5 2.5a.5.5 0 0 0-1 0v9.793l-1.146-1.147a.5.5 0 0 0-.708.708l2 1.999.007.007a.497.497 0 0 0 .7-.006l2-2a.5.5 0 0 0-.707-.708L4.5 12.293V2.5z"/>
</svg>
</span></a></th>
<th class="cell">MAIL</th>
<th class="cell">EDUACTION</th>
<th class="cell">View</th>
<th class="cell" style="color:green">Update</th>
<th class="cell" style="color:red">Remove</th>';
while($r=mysqli_fetch_array($sqe))
{
$reg_no=$r['reg_no'];
$rid=$r['reg_id'];
echo'<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell"><span class="truncate">'.$r['name'].'</span></td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell"><span>'.$r['date'].'</span></td>
<td class="cell"><span class="badge bg-success">'.$r['email'].'</span></td>
<td class="cell">'.$r['education'].'</td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="../adpreview.php?id='.$reg_no.'">View</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="adupdateform.php?rid='.$rid.'" Style="color:green;">Update</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="addelform.php?id='.$reg_no.'" Style="color:red;">Remove</a></td>
</tr>';
}
?>
</th>
</thead>
</table>
</div><!--//table-responsive-->
</div><!--//app-card-body-->
</div><!--//app-card-->
</div><!--//tab-pane-->
<div class="tab-pane fade" id="Finance" role="tabpanel" aria-labelledby="orders-paid-tab">
<div class="app-card app-card-orders-table mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table class="table mb-0 text-left">
<thead>
<tr>
<th class="cell">ID</th>
<th class="cell">NAME</th>
<th class="cell">MOBILE</th>
<th class="cell">DATE</th>
<th class="cell">MAIL</th>
<th class="cell">EDUACTION</th>
<th class="cell">View</th>
<th class="cell" style="color:green">Update</th>
<th class="cell" style="color:red">Remove</th>
</tr>
</thead>
<tbody>
<?php
include"connection.php";
$qe="select * from aplicant where post = 'Finance Support Executive' ORDER BY reg_id DESC";
$sqe=mysqli_query($cn,$qe);
if($sqe)
{
// check if any data found or not
if(mysqli_fetch_array($sqe)>0)
{
$sqe=mysqli_query($cn,$qe);
while($r=mysqli_fetch_array($sqe))
{
$reg_no=$r['reg_no'];
$rid=$r['reg_id'];
echo'<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell"><span class="truncate">'.$r['name'].'</span></td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell"><span>'.$r['date'].'</span></td>
<td class="cell"><span class="badge bg-success">'.$r['email'].'</span></td>
<td class="cell">'.$r['education'].'</td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="../adpreview.php?id='.$reg_no.'">View</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="adupdateform.php?rid='.$rid.'" Style="color:green;">Update</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="addelform.php?id='.$reg_no.'" Style="color:red;">Remove</a></td>
</tr>';
}
}
else{
echo'<br> No Candidates ';
}
}
else
{
echo '<br>'.mysqli_error($cn);
}
?>
</tbody>
</table>
</div><!--//table-responsive-->
</div><!--//app-card-body-->
</div><!--//app-card-->
</div><!--//tab-pane-->
<div class="tab-pane fade" id="Customer" role="tabpanel" aria-labelledby="orders-pending-tab">
<div class="app-card app-card-orders-table mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table class="table mb-0 text-left">
<thead>
<tr>
<th class="cell">ID</th>
<th class="cell">NAME</th>
<th class="cell">MOBILE</th>
<th class="cell">DATE</th>
<th class="cell">MAIL</th>
<th class="cell">EDUACTION</th>
<th class="cell">View</th>
<th class="cell" style="color:green">Update</th>
<th class="cell" style="color:red">Remove</th>
</tr>
</thead>
<tbody>
<?php
include"connection.php";
$qe="select * from aplicant where post = 'Customer Process Executive' ORDER BY reg_id DESC";
$sqe=mysqli_query($cn,$qe);
if($sqe)
{
// check if any data found or not
if(mysqli_fetch_array($sqe)>0)
{
$sqe=mysqli_query($cn,$qe);
while($r=mysqli_fetch_array($sqe))
{
$reg_no=$r['reg_no'];
$rid=$r['reg_id'];
echo'<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell"><span class="truncate">'.$r['name'].'</span></td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell"><span>'.$r['date'].'</span></td>
<td class="cell"><span class="badge bg-success">'.$r['email'].'</span></td>
<td class="cell">'.$r['education'].'</td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="../adpreview.php?id='.$reg_no.'">View</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="adupdateform.php?rid='.$rid.'" Style="color:green;">Update</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="addelform.php?id='.$reg_no.'" Style="color:red;">Remove</a></td>
</tr>';
}
}
else{
echo'<br> No Candidates ';
}
}
else
{
echo '<br>'.mysqli_error($cn);
}
?>
</tbody>
</table>
</div><!--//table-responsive-->
</div><!--//app-card-body-->
</div><!--//app-card-->
</div><!--//tab-pane-->
<div class="tab-pane fade" id="Technical" role="tabpanel" aria-labelledby="orders-pending-tab">
<div class="app-card app-card-orders-table mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table class="table mb-0 text-left">
<thead>
<tr>
<th class="cell">ID</th>
<th class="cell">NAME</th>
<th class="cell">MOBILE</th>
<th class="cell">DATE</th>
<th class="cell">MAIL</th>
<th class="cell">EDUACTION</th>
<th class="cell">View</th>
<th class="cell" style="color:green">Update</th>
<th class="cell" style="color:red">Remove</th>
</tr>
</thead>
<tbody>
<?php
include"connection.php";
$qe="select * from aplicant where post = 'Technical Associate' ORDER BY reg_id DESC";
$sqe=mysqli_query($cn,$qe);
if($sqe)
{
// check if any data found or not
if(mysqli_fetch_array($sqe)>0)
{
$sqe=mysqli_query($cn,$qe);
while($r=mysqli_fetch_array($sqe))
{
$reg_no=$r['reg_no'];
$rid=$r['reg_id'];
echo'<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell"><span class="truncate">'.$r['name'].'</span></td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell"><span>'.$r['date'].'</span></td>
<td class="cell"><span class="badge bg-success">'.$r['email'].'</span></td>
<td class="cell">'.$r['education'].'</td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="../adpreview.php?id='.$reg_no.'">View</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="adupdateform.php?rid='.$rid.'" Style="color:green;">Update</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="addelform.php?id='.$reg_no.'" Style="color:red;">Remove</a></td>
</tr>';
}
}
else{
echo'<br> No Candidates ';
}
}
else
{
echo '<br>'.mysqli_error($cn);
}
?>
</tbody>
</table>
</div><!--//table-responsive-->
</div><!--//app-card-body-->
</div><!--//app-card-->
</div><!--//tab-pane-->
<div class="tab-pane fade" id="Digital" role="tabpanel" aria-labelledby="orders-cancelled-tab">
<div class="app-card app-card-orders-table mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table class="table mb-0 text-left">
<thead>
<tr>
<th class="cell">ID</th>
<th class="cell">NAME</th>
<th class="cell">MOBILE</th>
<th class="cell">DATE</th>
<th class="cell">MAIL</th>
<th class="cell">EDUACTION</th>
<th class="cell">View</th>
<th class="cell" style="color:green">Update</th>
<th class="cell" style="color:red">Remove</th>
</tr>
</thead>
<tbody>
<?php
include"connection.php";
$qe="select * from aplicant where post = 'Digital Marketing Executive' ORDER BY reg_id DESC";
$sqe=mysqli_query($cn,$qe);
if($sqe)
{
// check if any data found or not
if(mysqli_fetch_array($sqe)>0)
{
$sqe=mysqli_query($cn,$qe);
while($r=mysqli_fetch_array($sqe))
{
$reg_no=$r['reg_no'];
$rid=$r['reg_id'];
echo'<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell"><span class="truncate">'.$r['name'].'</span></td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell"><span>'.$r['date'].'</span></td>
<td class="cell"><span class="badge bg-success">'.$r['email'].'</span></td>
<td class="cell">'.$r['education'].'</td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="../adpreview.php?id='.$reg_no.'">View</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="adupdateform.php?rid='.$rid.'" Style="color:green;">Update</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="addelform.php?id='.$reg_no.'" Style="color:red;">Remove</a></td>
</tr>';
}
}
else{
echo'<br> No Candidates ';
}
}
else
{
echo '<br>'.mysqli_error($cn);
}
?>
</tbody>
</table>
</div><!--//table-responsive-->
</div><!--//app-card-body-->
</div><!--//app-card-->
</div><!--//tab-pane-->
<div class="tab-pane fade" id="Php" role="tabpanel" aria-labelledby="orders-cancelled-tab">
<div class="app-card app-card-orders-table mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table class="table mb-0 text-left">
<thead>
<tr>
<th class="cell">ID</th>
<th class="cell">NAME</th>
<th class="cell">MOBILE</th>
<th class="cell">DATE</th>
<th class="cell">MAIL</th>
<th class="cell">EDUACTION</th>
<th class="cell">View</th>
<th class="cell" style="color:green">Update</th>
<th class="cell" style="color:red">Remove</th>
</tr>
</thead>
<tbody>
<?php
include"connection.php";
$qe="select * from aplicant where post = 'PHP Web Developer' ORDER BY reg_id DESC";
$sqe=mysqli_query($cn,$qe);
if($sqe)
{
// check if any data found or not
if(mysqli_fetch_array($sqe)>0)
{
$sqe=mysqli_query($cn,$qe);
while($r=mysqli_fetch_array($sqe))
{
$reg_no=$r['reg_no'];
$rid=$r['reg_id'];
echo'<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell"><span class="truncate">'.$r['name'].'</span></td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell"><span>'.$r['date'].'</span></td>
<td class="cell"><span class="badge bg-success">'.$r['email'].'</span></td>
<td class="cell">'.$r['education'].'</td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="../adpreview.php?id='.$reg_no.'">View</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="adupdateform.php?rid='.$rid.'" Style="color:green;">Update</a></td>
<td class="cell"><a class="btn-sm app-btn-secondary" href="addelform.php?id='.$reg_no.'" Style="color:red;">Remove</a></td>
</tr>';
}
}
else{
echo'<br> No Candidates ';
}
}
else
{
echo '<br>'.mysqli_error($cn);
}
?>
</tbody>
</table>
</div><!--//table-responsive-->
</div><!--//app-card-body-->
</div><!--//app-card-->
</div><!--//tab-pane-->
<nav aria-label="Page navigation example">
<ul class="pagination">
<li class="page-item"><a class="page-link" href="#">Previous</a></li>
<li class="page-item"><a class="page-link" href="#">1</a></li>
<li class="page-item"><a class="page-link" href="#">2</a></li>
<li class="page-item"><a class="page-link" href="#">3</a></li>
<li class="page-item"><a class="page-link" href="#">Next</a></li>
</ul>
</nav>
</div><!--//tab-content-->
</div><!--//container-fluid-->
</div><!--//app-content-->
<footer class="app-footer">
<div class="container text-center py-3">
<!--/* This template is free as long as you keep the footer attribution link. If you'd like to use the template without the attribution link, you can buy the commercial license via our website: themes.3rdwavemedia.com Thank you for your support. :) */-->
<small class="copyright">Designed with <span class="sr-only">love</span><i class="fas fa-heart" style="color: #fb866a;"></i> by <a class="app-link" href="">Ric</a> for developers</small>
</div>
</footer><!--//app-footer-->
</div><!--//app-wrapper-->
<!-- Javascript -->
<script src="assets/plugins/popper.min.js"></script>
<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
<!-- Page Specific JS -->
<script src="assets/js/app.js"></script>
</body>
</html>