File: /home/u435929562/domains/events.peacockindia.in/public_html/report.php
<?php
// $host = 'localhost';
// ////////////////////////////////////
// $user = "u520518518_valoevents";
// $pass = "3nA>:7&5kS=";
// $db_name = "u520518518_valovents";
// $host = "localhost";
// $user = "u520518518_valoevents";
// $pass = "3nA>:7&5kS=";
// $db_name = "u520518518_valovents";
$host = 'localhost';
$user = 'u520518518_valoevent_demo';
$pass = 'Valoevent@dem0';
$db_name = "u520518518_valoevent_demo";
$mysqli = new mysqli($host, $user, $pass, $db_name);
$sql = "SELECT count(*) as entrycount from qrcode where status>0 and id<800";
$result = $mysqli->query($sql);
$row_entry = $result->fetch_array();
$sql = "SELECT count(*) as dinnercont from qrcode where dinner_status>0 and id<800";
$result = $mysqli->query($sql);
$row_dinner = $result->fetch_array();
$sql = "SELECT count(*) as employeecont from qrcode where status>0 and id>1000";
$result = $mysqli->query($sql);
$row_empentry = $result->fetch_array();
$sql = "SELECT count(*) as employeecont from qrcode where dinner_status>0 and id>1000";
$result = $mysqli->query($sql);
$row_empdinner = $result->fetch_array();
?>
<?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</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">
</head>
<body>
<div class="container-fluid">
<div class="row">
<h1 class="text-center" style="margin:0 auto;text-align:center;padding-bottom:50px;">SabaGroup Report</h1>
<div class="col-md-12">
<table class="table">
<thead>
<tr>
<th>
#
</th>
<th>
Action
</th>
<th>
Count
</th>
</tr>
</thead>
<tbody>
<tr class="table-active">
<td>
1
</td>
<td>
SEAT INN
</td>
<td>
<?php echo $row_entry['entrycount'];?>
</td>
</tr>
<tr class="table-success">
<td>
2
</td>
<td>
DINNER INN
</td>
<td>
<?php echo $row_dinner['dinnercont'];?>
</td>
</tr>
<tr class="table-warning">
<td>
3
</td>
<td>
EMPLOYEE INN
</td>
<td>
<?php echo $row_empentry['employeecont'];?>
</td>
</tr>
<tr class="table-danger">
<td>
4
</td>
<td>
EMPLOYEE DINNER INN
</td>
<td>
<?php echo $row_empdinner['employeecont'];?>
</td>
</tr>
</tbody>
</table>
</div>
<div class="col-md-12" style="text-align:center;">
<a href="report_details.php" class="btn btn-primary">View Details</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();
?>