|
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 : /home2/outerorb/dev.outerorbittech.com/bhive/admin/ | |
|
Path: /home2/outerorb/dev.outerorbittech.com/bhive/admin/export.php
Size: 5.76 KB
Permissions: 0644
<?php
ob_start();
session_start();
if($_SESSION['aid']!=session_id())
{
header("location:../login.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>EXPORT</title>
<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/ric.png" rel="icon">
<script defer src="assets/plugins/fontawesome/js/all.min.js"></script>
<!-- App CSS -->
<link id="theme-style" rel="stylesheet" href="assets/css/portal.css">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
</head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.6.4/css/bootstrap-datepicker.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.6.4/js/bootstrap-datepicker.js"></script>
<script>
$(document).ready(function(){
$('.input-daterange').datepicker({
todayBtn:'linked',
format: "yyyy-mm-dd",
autoclose: true
});
});
</script>
<style>
.input-daterange input {
text-align: left;
}
</style>
</head>
<body class="">
<div role="navigation" class="navbar navbar-default navbar-static-top">
<div class="container" style="background-color:white;">
<div class="navbar-header">
<button data-target=".navbar-collapse" data-toggle="collapse" class="navbar-toggle" type="button">
<span class="sr-only"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<div class="navbar-collapse collapse" style="background-color:white;">
<ul class="nav navbar-nav">
<li style="background-color:#DCEDFF;"><a href="index.php" style="text-align:center;"><b>HOME</b></a></li>
</ul>
</div><!--/.nav-collapse -->
</div>
</div>
<div class="container">
<h2 style="color:red;">Export Data to EXCEL</h2>
<br>
<div class="row">
<form action="down.php" method="post" enctype="multipart/form-data">
<div class="input-daterange">
<div class="col-md-4">
From<input type="text" name="fromDate" class="form-control" value="<?php echo date("Y-m-d"); ?>"/>
</div>
<div class="col-md-3">
To<input type="text" name="toDate" class="form-control" value="<?php echo date("Y-m-d"); ?>" />
</div>
</div>
<div class="col-md-2"><div> </div>
<input type="submit" name="export" value="Export" class="btn btn-info" />
</div>
</form>
</div>
<div class="row">
</div>
<br />
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>ID</th>
<th>STATUS</th>
<th>NAME</th>
<th>MOBILE No.</th>
<th>MAIL_ID</th>
<th>AADHAR No.</th>
<th>FATHER NAME</th>
<th>ADDRESS</th>
<th>PIN CODE</th>
<th>STATE</th>
<th>CITY</th>
<th>AGE</th>
<th>RELOCATION</th>
<th>EDUCATION</th>
<th>INSTITUTE</th>
<th>UNIVERSITY</th>
<th>PASSOUT</th>
<th>RESULT</th>
<th>NIGHT SHIFT</th>
<th>WORK EXPRIENCE</th>
<th>EPF A/C</th>
<th>FOREIGN CERTIFICATE</th>
<th>OLD EMPLYEE</th>
</tr>
</thead>
<tbody>
<?php
include"connection.php";
$qe="select * from aplicant 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'];
echo '
<tr>
<td class="cell">'.$r['reg_no'].'</td>
<td class="cell">'.$r['status'].'</td>
<td class="cell">'.$r['name'].'</td>
<td class="cell">'.$r['mobile'].'</td>
<td class="cell">'.$r['email'].'</td>
<td class="cell">'.$r['aadhar'].'</td>
<td class="cell">'.$r['fname'].'</td>
<td class="cell">'.$r['address'].'</td>
<td class="cell">'.$r['pin'].'</td>
<td class="cell">'.$r['state'].'</td>
<td class="cell">'.$r['city'].'</td>
<td class="cell">'.$r['age'].'</td>
<td class="cell">'.$r['relocate'].'</td>
<td class="cell">'.$r['education'].'</td>
<td class="cell">'.$r['institute'].'</td>
<td class="cell">'.$r['university'].'</td>
<td class="cell">'.$r['pass'].'</td>
<td class="cell">'.$r['result'].'</td>
<td class="cell">'.$r['night'].'</td>
<td class="cell">'.$r['work'].'</td>
<td class="cell">'.$r['epf'].'</td>
<td class="cell">'.$r['fcertificate'].'</td>
<td class="cell">'.$r['emp'].'</td>
</tr>
';
}
}
else {
echo'<br> DATA not found ';
}}
else
{
echo '<br>'.mysqli_error($cn);
}
?>
</tbody>
</table>
</div>
<div class="insert-post-ads1" style="margin-top:20px;">
</div>
</div>
</body>
</html>