<?php
session_start();
error_reporting(1);
include('includes/config.php');
if (strlen($_SESSION['adminlogin']) == 0) {
	header('location:index.php');
	die();
}
ini_set('memory_limit', '512M');

?>

<!doctype html>
<html lang="en" class="no-js">

<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1">
	<meta name="description" content="">
	<meta name="author" content="">
	<meta name="theme-color" content="#3e454c">

	<title>Manage Users</title>

	<!-- Font awesome -->
	<link rel="stylesheet" href="css/font-awesome.min.css">
	<!-- Sandstone Bootstrap CSS -->
	<link rel="stylesheet" href="css/bootstrap.min.css">
	<!-- Admin Stye -->
	<link rel="stylesheet" href="css/style.css">





	<script src="https://code.jquery.com/jquery-3.6.4.slim.min.js" integrity="sha256-a2yjHM4jnF9f54xUQakjZGaqYs/V1CYvWpoqZzC2/Bw=" crossorigin="anonymous"></script>
	<!-- Sandstone Bootstrap CSS -->

	<!--<link rel="stylesheet" href="//cdn.datatables.net/1.13.4/css/jquery.dataTables.min.css"> -->
	<script src="//cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js" ></script>
	<!-- Admin Stye -->









	<style>
		.errorWrap {
			padding: 10px;
			margin: 0 0 20px 0;
			background: #dd3d36;
			color: #fff;
			-webkit-box-shadow: 0 1px 1px 0 rgba(0, 0, 0, .1);
			box-shadow: 0 1px 1px 0 rgba(0, 0, 0, .1);
		}

		.succWrap {
			padding: 10px;
			margin: 0 0 20px 0;
			background: #5cb85c;
			color: #fff;
			-webkit-box-shadow: 0 1px 1px 0 rgba(0, 0, 0, .1);
			box-shadow: 0 1px 1px 0 rgba(0, 0, 0, .1);
		}
	</style>

</head>

<body>
	<?php include('includes/header.php'); ?>

	<div class="ts-main-content">
		<?php include('includes/leftbar.php'); ?>
		<div class="content-wrapper">
			<div class="container-fluid">

				<div class="row">
					<div class="col-md-12">

						<h2 class="page-title">Manage Users</h2>

						<!-- Zero Configuration Table -->
						<div class="panel panel-default">
							<?php

							$sql = "SELECT * from log ORDER BY id DESC";
							$query = $dbh->prepare($sql);
							$query->execute();
							$results = $query->fetchAll(PDO::FETCH_OBJ);
							?>
							<div class="panel-heading">Total: <?php echo $query->rowCount(); ?></div>
							<div class="panel-body">

								<table id="myTable" class="display table table-striped table-bordered table-hover" cellspacing="0" width="100%">
									<thead>
										<tr>
											<th>ID</th>
											<th>NameBangla</th>
											<th>MameEnglish</th>
											<th>nid</th>
											<th>pin</th>
											<th>dob</th>
											<th>nameFather</th>
											<th>nameMother</th>
											<th>bloodGroup</th>
											<th>fulladdress</th>
											<th>birthPlace</th>
											<th>User</th>
											<th>Time</th>
										</tr>
									</thead>

									<tbody>

										<?php

										if ($query->rowCount() > 0) {
											foreach ($results as $result) {				?>
												<tr>
													<td><?php echo htmlentities($result->id); ?></td>
													<td><?php echo htmlentities($result->nameBangla); ?></td>
													<td><?php echo htmlentities($result->nameEnglish); ?></td>
													<td><?php echo htmlentities($result->nid); ?></td>
													<td><?php echo htmlentities($result->pin); ?></td>

													<td><?php echo htmlentities($result->dateOfBirth); ?></td>
													<td><?php echo htmlentities($result->fatherName); ?></td>
													<td><?php echo htmlentities($result->motherName); ?></td>

													<td><?php echo htmlentities($result->bloodGroup); ?></td>

													<td><?php echo htmlentities($result->address); ?></td>
													<td><?php echo htmlentities($result->birthPlace); ?></td>
													<td><?php echo htmlentities($result->cardUser); ?></td>
													<td><?php echo htmlentities($result->insertTime); ?></td>

												</tr>
										<?php
											}
										} ?>

									</tbody>
								</table>
							</div>
						</div>
					</div>
				</div>

			</div>
		</div>
	</div>

	<!-- Loading Scripts -->
	<script src="js/jquery.min.js"></script>
	<script src="js/bootstrap-select.min.js"></script>
	<script src="js/bootstrap.min.js"></script>
	<script src="js/main.js"></script>
	<script type="text/javascript">
		//let table = new DataTable('#myTable');
			//$(document).ready(function() {
				//setTimeout(function() {
				//	$('.succWrap').slideUp("slow");
				//}, 3000);
			//});
		</script>

</body>

</html>