📄 File: down.php

Path: /home2/outerorb/dev.outerorbittech.com/bhive/admin/down.php

Size: 4.95 KB

Permissions: 0644

<?php
ob_start();
session_start();
if($_SESSION['aid']!=session_id())
{
	header("location:../login.php");
}
?>

<?php
include_once("connection.php");
if(isset($_POST["export"]))
{

	$startDate =$_POST['fromDate'];
	$endDate =$_POST['toDate'];



	$qe = "
	SELECT * FROM aplicant
	WHERE date >= '".$startDate."' AND date <= '".$endDate."' ORDER BY date 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);

		$data = '

<table class="table app-table-hover mb-0 text-left" border="1">
										<thead>
											<tr>
											<th class="cell">ID</th>
											<th class="cell">STATUS</th>
											<th class="cell">NAME</th>
											<th class="cell">MOBILE No.</th>
											<th class="cell">MAIL_ID</th>
												<th class="cell">AADHAR No.</th>
												<th class="cell">FATHER NAME</th>
												<th class="cell">ADDRESS</th>
												<th class="cell">PIN CODE</th>
                                                <th class="cell">STATE</th>
                                                <th class="cell">CITY</th>
                                                <th class="cell">AGE</th>
                                                <th class="cell">RELOCATION</th>
                                                <th class="cell">EDUCATION</th>
                                        
                                                <th class="cell">INSTITUTE</th>
                                                <th class="cell">UNIVERSITY</th>
                                                <th class="cell">PASSOUT</th>
                                                <th class="cell">RESULT</th>
                                                <th class="cell">NIGHT SHIFT</th>
                                                <th class="cell">WORK EXPRIENCE</th>
                                                <th class="cell">EPF A/C</th>
                                                <th class="cell">FOREIGN CERTIFICATE</th>
                                                <th class="cell">OLD EMPLYEE</th>
                                                <th class="cell">ACCOUNT</th>
												<th class="cell">IFSC</th>
												<th class="cell">BANK</th>
												<th class="cell">PAN</th>
												<th class="cell">JOIN DATE</th>
												<th class="cell">SALARY</th>
											
											</tr>
										</thead>

										<tbody>';


										while($r=mysqli_fetch_array($sqe))
										{
											$reg_no=$r['reg_no'];
																				$data.= '<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>
																					<td class="cell">'.$r['account'].'</td>
																					<td class="cell">'.$r['ifsc'].'</td>
																					<td class="cell">'.$r['bank'].'</td>
																					<td class="cell">'.$r['pan'].'</td>
																					<td class="cell">'.$r['joining'].'</td>
																					<td class="cell">'.$r['salary'].'</td>
									
																				</tr>';
																			
																			}

																			$finame="allCandidate-Data : ".date("d-m-y");
																			header("Content-Type: application/xls");
																			header("Content-Disposition: attacchment; filename=$finame.xls");
									
																			echo $data;
																		}
																		else   {
																			
																			echo '<script>alert("No Record Found");
																			window.location="export.php";
																			</script>';
																		}
									
									}
								}
								else 
									{
									echo '<br>'.mysqli_error($cn);
									}

?>

← Back to Directory Edit File 🔒 Chmod