<?php
	require_once 'validate.php';
	require 'name.php';
	
?>
<?php 
include('header.php');
?>
<?php 
include('sidebar.php');
?>
<style>
.settings-tab .tabs-menu li {
    width: 25% !important;
    display: block;
}
</style>
<?php

if(isset($_POST['search']))
{
    $valueToSearch = $_POST['valueToSearch'];
    // search in all table columns
    // using concat mysql function
    $query = "SELECT * FROM `registration` WHERE CONCAT(`serial_id`, `name`, `emailid`, `contact_no`, `state`, `sport`, `designation`, `reg_date`, `status`) LIKE '%".$valueToSearch."%'";
    $search_result = filterTable($query);
    
}
 else {
    $query = "SELECT * FROM `registration`";
    $search_result = filterTable($query);
}

// function to connect and execute the query
function filterTable($query)
{
	
    $conn = mysqli_connect("localhost", "hotelrsg_iasfindia", "Sport@123", "hotelrsg_iasf");
    $filter_Result = mysqli_query($conn, $query);
    return $filter_Result;
}

?>
<!--app content-->
				<div class="app-content">
					<div class="side-app">
						<div class="page-header">
							<h4 class="page-title">Update Player Registration</h4>
							<ol class="breadcrumb">
								<li class="breadcrumb-item"><a href="#"><i class="fe   fe-home mr-1"></i> Admin</a></li>
								<li class="breadcrumb-item active" aria-current="page">Update Registration</li>
							</ol>
						</div>	
<div class = "panel panel-default">
			
			<div class = "panel-body">
				
				<div class="card-body">
								<div class="settings-tab">
									
									<form action="" method="post">
            <input type="text" name="valueToSearch" placeholder="Value To Search">
            <input type="submit" name="search" value="Filter">
			</form>
									<div class="tab-content">
										<div class="tab-pane active show" id="tab0">
											
											<table id = "table" class = "table table-bordered">
					<thead>
						<tr>
							<th>ID</th>
							<th>Name</th>
							<th>Email</th>
							<th>Contact No</th>
							<th>State</th>
							<th>Sport</th>
							<th>Designation</th>
							<th>Date</th>
							<th>Status</th>
							<th>Action</th>
						</tr>
					</thead>
					<tbody>
					 <?php while($fetch = mysqli_fetch_array($search_result)):?>
						
						<tr>
							<td><?php echo $fetch['serial_id']?></td>
							<td><?php echo $fetch['name']?></td>
							<td><?php echo $fetch['emailid']?></td>
							<td><?php echo $fetch['contact_no']?></td>
							<td><?php echo $fetch['state']?></td>
							<td><?php echo $fetch['sport']?></td>
							<td><?php echo $fetch['designation']?></td>
							<td><strong><?php echo $fetch['reg_date']?></strong></td>
							<td><?php echo $fetch['status']?></td>
							
							<td><center>
							<form action="update-registration-page.php" method="post">
							<input type = "hidden" class = "form-control" name = "id" value="<?php echo $fetch['id'];?>" />
							
							<input type = "submit" class = "btn btn-success btn-icon btn-sm fe fe-edit-2" name ="select" value="Select"/>
							
							</form>
							
							
						</tr>
						
						<?php endwhile;?>
					</tbody>
				</table>
											
										</div>
										
										
									</div>
									
								</div>
							</div>
				
			</div>
		</div>
	</div>
	</div>

						
				<!--app content-->
				
				<?php 
include('footer.php');
?>