File: /home/u435929562/domains/events.peacockindia.in/public_html/report_details.php
<?php
$host = 'localhost';
$user = 'u520518518_valoevent_demo';
$pass = 'Valoevent@dem0';
$db_name = "u520518518_valoevent_demo";
// $host = "localhost";
// $user = "u520518518_valoevents";
// $pass = "3nA>:7&5kS=";
// $db_name = "u520518518_valovents";
$mysqli = new mysqli($host, $user, $pass, $db_name);
$sql = "SELECT * from qrcode where id<800";
$result_entry = $mysqli->query($sql);
$sql = "SELECT * from qrcode WHERE id<800";
$result_dinner = $mysqli->query($sql);
$sql = "SELECT * from qrcode where id>1000";
$result_empentry = $mysqli->query($sql);
$sql = "SELECT * from qrcode where id>1000";
$result_empdinner = $mysqli->query($sql);
$entry = 0;
$dinner = 0;
$eentry = 0;
$edinner = 0;
?>
<?php
$page = $_SERVER['PHP_SELF'];
$sec = "60";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Saba Group Report Details</title>
<meta http-equiv="refresh" content="<?php echo $sec?>;URL='<?php echo $page?>'">
<meta name="description" content="Source code generated using layoutit.com">
<meta name="author" content="LayoutIt!">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<style>
.inn{font-weight:bold;color:#000000;font-size:1.5em;}
</style>
</head>
<body>
<div class="container-fluid">
<div class="row">
<h1 class="text-center" style="margin:0 auto;text-align:center;padding-bottom:50px;">SabaGroup Detail Report</h1>
<div class="col-md-12">
<h3 class="text-center" style="margin:0 auto;text-align:center;padding-bottom:50px;" id="ventry">VIP ENTRY</h3>
<div style="margin:0 auto;text-align:center;padding-top:50px;padding-bottom:50px;">
<a href="#ventry">VIP ENTRY</a> | <a href="#vdinner">VIP DINNER</a> | <a href="#eentry">EMPLOYEE ENTRY</a> | <a href="#edinner">EMPLOYEE DINNER</a>
</div>
<table class="table">
<thead>
<tr>
<th>
#
</th>
<th>
SEAT NO
</th>
<th>
STATUS
</th>
</tr>
</thead>
<tbody>
<?php while($row = $result_entry->fetch_array()) { ?>
<tr class="<?php echo (($entry % 2 == 0)?'table-active':'table-success');?>">
<td>
<?php echo $entry++;?>
</td>
<td>
<?php echo $row['seat_no'];?>
</td>
<td>
<?php if ($row['status']==0) { ?>
<span class="not_inn">NOT INN</span>
<?php } else { ?>
<span class="inn">INN</span>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div style="padding-top:50px;"> </div>
<div style="margin:0 auto;text-align:center;padding-top:50px;padding-bottom:50px;">
<h3 class="text-center" style="margin:0 auto;text-align:center;padding-bottom:50px;" id="vdinner">VIP DINNER ENTRY</h3>
<a href="#ventry">VIP ENTRY</a> | <a href="#vdinner">VIP DINNER</a> | <a href="#eentry">EMPLOYEE ENTRY</a> | <a href="#edinner">EMPLOYEE DINNER</a>
</div>
<table class="table">
<thead>
<tr>
<th>
#
</th>
<th>
SEAT NO
</th>
<th>
STATUS
</th>
</tr>
</thead>
<tbody>
<?php while($row = $result_dinner->fetch_array()) { ?>
<tr class="<?php echo (($entry % 2 == 0)?'table-active':'table-success');?>">
<td>
<?php echo $entry++;?>
</td>
<td>
<?php echo $row['seat_no'];?>
</td>
<td>
<?php if ($row['dinner_status']==0) { ?>
<span class="not_inn">NOT INN</span>
<?php } else { ?>
<span class="inn">INN</span>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div style="padding-top:50px;"> </div>
<div style="margin:0 auto;text-align:center;padding-top:50px;padding-bottom:50px;">
<h3 class="text-center" style="margin:0 auto;text-align:center;padding-bottom:50px;" id="eentry">EMPLOYEE ENTRY</h3>
<a href="#ventry">VIP ENTRY</a> | <a href="#vdinner">VIP DINNER</a> | <a href="#eentry">EMPLOYEE ENTRY</a> | <a href="#edinner">EMPLOYEE DINNER</a>
</div>
<table class="table">
<thead>
<tr>
<th>
#
</th>
<th>
EMPLOYEE NO
</th>
<th>
STATUS
</th>
</tr>
</thead>
<tbody>
<?php while($row = $result_empentry->fetch_array()) { ?>
<tr class="<?php echo (($entry % 2 == 0)?'table-active':'table-success');?>">
<td>
<?php echo $entry++;?>
</td>
<td>
<?php echo $row['seat_no'];?>
</td>
<td>
<?php if ($row['status']==0) { ?>
<span class="not_inn">NOT INN</span>
<?php } else { ?>
<span class="inn">INN</span>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div style="padding-top:50px;"> </div>
<h3 class="text-center" style="margin:0 auto;text-align:center;padding-bottom:50px;" id="edinner">EMPLOYEE DINNER ENTRY</h3>
<div style="margin:0 auto;text-align:center;padding-top:50px;padding-bottom:50px;">
<a href="#ventry">VIP ENTRY</a> | <a href="#vdinner">VIP DINNER</a> | <a href="#eentry">EMPLOYEE ENTRY</a> | <a href="#edinner">EMPLOYEE DINNER</a>
</div>
<table class="table">
<thead>
<tr>
<th>
#
</th>
<th>
EMPLOYEE NO
</th>
<th>
STATUS
</th>
</tr>
</thead>
<tbody>
<?php while($row = $result_empdinner->fetch_array()) { ?>
<tr class="<?php echo (($entry % 2 == 0)?'table-active':'table-success');?>">
<td>
<?php echo $entry++;?>
</td>
<td>
<?php echo $row['seat_no'];?>
</td>
<td>
<?php if ($row['dinner_status']==0) { ?>
<span class="not_inn">NOT INN</span>
<?php } else { ?>
<span class="inn">INN</span>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<div class="col-md-12" style="text-align:center;">
<a href="report.php" class="btn btn-primary">Back</a>
</div>
</div>
</div>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/scripts.js"></script>
</body>
</html>
<?php
$mysqli->close();
?>