<?php  
$page_title = 'Statistics';
include 'header.php';
?>
<div class="content-wrapper">
	<section class="content mt-4">
		<div class="container-fluid">
			<div class="row">
				<div class="col-md-12">
					<?php include('alert-msg.php'); ?>
					<div class="card card-primary">
						<div class="card-header">
							<h3 class="card-title"><?php echo $page_title; ?></h3>
						</div>
						<form action="" method="POST" enctype="multipart/form-data">
							<div class="card-body">
								<div class="row">
									<div class="col-md-4">
										<div class="form-group">
											<label>Title</label>
											<input type="text" class="form-control" name="title" />
										</div>
									</div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Count</label>
											<input type="text" class="form-control" name="count" />
										</div>
									</div>
								</div>
								<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
							</div>
						</form>
					</div>
					<div class="card card-primary">
						<div class="card-header">
							<h3 class="card-title"><?php echo $page_title; ?> List</h3>
						</div>
							<div class="card-body">
								<table class="table table-bordered table-striped main_datatables">
									<thead>
										<tr>
											<th>Sr. No.</th>
											<th>Title</th>
											<th>Count</th>
											<th>Action</th>
										</tr>
									</thead>
									<tbody>
										<?php
										$sel_statistics=mysqli_query($con,'select * from statistics order by id desc');
										$i=1;
										while($row_statistics=mysqli_fetch_array($sel_statistics))
										{

											?>
											<tr>
												<td><?php echo $i; ?></td>
												<td><?php echo $row_statistics['title']; ?></td>
												<td><?php echo $row_statistics['count']; ?></td>
												<td>
													<a href="statistics-delete.php?id=<?php echo $row_statistics['id']; ?>" onclick="return confirm('Are you sure you want to delete ?');" class="btn btn-sm btn-danger"><i class="fas fa-trash"></i></a>
												</td>
											</tr>
											<?php
											$i=$i+1;
										}
										?>
									</tbody>
								</table>
							</div>
						</form>
					</div>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>


<?php
if(isset($_POST['btnSubmit']))
{
	$title = $_POST['title'];
	$count = $_POST['count'];

	$ins = mysqli_query($con,"INSERT INTO `statistics` (`id`, `title`, `count`) VALUES (NULL, '$title', '$count')");

	if($ins)
	{
		$_SESSION['success_msg'] = 'Statistics has been added...';
		echo"<script>window.location='statistics.php';</script>";
	}
	else
	{
		$_SESSION['error_msg'] = 'Unable to add statistics...';
		echo"<script>window.location='statistics.php';</script>";
	}
}
?>