<?php 
require_once 'admin/connect.php';
include('header.php');

?>
<style>
#tbl {
  font-family: Arial, Helvetica, sans-serif;
  border-collapse: collapse;
  width: 100%;
  text-transform: uppercase;
}

#tbl td, #ctbl th {
  border: 1px solid #ddd;
  padding: 4px 8px;
}

#tbl tr:nth-child(even){background-color: #f2f2f2;}

#tbl tr:hover {background-color: #ddd;}

#tbl th {
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: left;
  background-color: #04AA6D;
  color: white;
}
.form-label{font-weight:bold !important;}
.form-control, .form-group {
    
    text-transform: uppercase;
}
</style>
<!--Breadcrumb-->
		<section class="bannerimg cover-image bg-background3" data-image-src="assets/images/banners/slide-banner.jpg">
			<div class="header-text mb-0">
				<div class="container">
					<div class="row text-white">
						<div class="col"><h1 class="">Find Your Certificate</h1></div>
						<div class="col col-auto">
							<ol class="breadcrumb text-center">
								<li class="breadcrumb-item"><a href="index.php">Home</a></li>
								
								<li class="breadcrumb-item active text-white" aria-current="page">Find Your Certificate</li>
							</ol>
						</div>
					</div>
				</div>
			</div>
		</section>
		<!--/Breadcrumb-->
		<!--Add listing-->
		<section class="sptb">
			<div class="container">
				<div class="row">
				<div class="col-xl-12 col-lg-12 col-md-12">
				<form action="" method="GET">
						<div class="card">
							<div class="card-body">
								<div class="input-group">
									
									<input type="text" name="serial_id" value="<?php if(isset($_GET['serial_id'])){echo $_GET['serial_id'];} ?>" class="form-control br-tl-5  br-bl-5" placeholder="Enter Your Serial Number">
									<div class="input-group-append ">
										
										<button type="submit" class="btn btn-secondary br-tr-5  br-br-5">Search Now</button>
									</div>
								</div>
							</div>
						</div>
						
						</form>
						</div>
						<?php 
											if(isset($_GET['serial_id']))
                                    {
                                        $serial_id	 = $_GET['serial_id'];

                                        //$query = "SELECT * FROM `registration` WHERE status='Approved'";
										$query = "SELECT * FROM `registration` WHERE status='Approved' AND serial_id='$serial_id' ";
										
                                        $query_run = mysqli_query($conn, $query);
                                        if(mysqli_num_rows($query_run) > 0)
                                        {
                                            foreach($query_run as $row)
                                            {
                                                ?>
					<div class="col-xl-8 col-lg-8 col-md-12">
						<!--Add lists-->
						<div class="row">
							<div class="col-xl-12 col-lg-12 col-md-12 col-sm-6">
								<div class="card overflow-hidden">
									<div class="d-md-flex  ieh-100">
										<div class="item2-card-img relative br-tr-0">
											<img src = "<?php echo $row['photo']?>"  alt="img" class="cover-image h-100 w-100 br-tr-0"/>
											
											<div class="date-blog bg-primary">
												<h4 class="mb-0 font-weight-semibold2"><img src="assets/images/brand/logo2.png" alt="img" class="w-100 br-5" style="width:50px !important;"></h4>
												
												<small>IASF INDIA</small>
											</div>
										</div>
										<div class="card-body">
											<div class="text-muted" style="float:right; color:red !important"><label style="font-weight:bold"><?= $row['serial_id']; ?> </label>  <i class="fa fa-thumbs-up"></i> IASF <span>Varified</span></div>
											<table  id="tbl">
												<tr>
												<td><label>Name</label></td>
												<td><label class="form-label"><?= $row['name']; ?> </label></td>
												</tr>
												<tr>
												<td><label>Father's Name</label></td>
												<td><label class="form-label"> <?= $row['father_name']; ?></label></td>
												</tr>
												<tr>
												<td><label>Date of Birth</label></td>
												<td><label class="form-label"><?= $row['dob']; ?></label></td>
												</tr>
												<tr>
												<td><label>State</label></td>
												<td><label class="form-label"><?= $row['state']; ?></label></td>
												</tr>
												<tr>
												<td><label>Country</label></td>
												<td><label class="form-label"><?= $row['country']; ?></label></td>
												</tr>
												<tr>
												<td><label>Game</label></td>
												<td><label class="form-label"><?= $row['sport']; ?></label></td>
												</tr>
												
												<tr>
												<td><label>Age Category</label></td>
												<td><label class="form-label"><?= $row['age_category']; ?></label></td>
												</tr>
												<tr>
												
												<td><label>Result</label></td>
												<td><label class="form-label"><?= $row['result']; ?></label></td>
												</tr>
												
												<tr>
												<td><label>Designation</label></td>
												<td><label class="form-label"><?= $row['designation']; ?></label></td>
												</tr>
												<tr>
												<td><label>Coach Name</label></td>
												<td><label class="form-label"><?= $row['coach']; ?></label></td>
												</tr>
												</table>
										</div>
									</div>
								</div>
							</div>
						</div>
						
						<!--/Add lists-->
					</div>

					<!--Side Content-->
					<div class="col-xl-4 col-lg-4 col-md-12">
						<div class="card">
							<div class="card-header">
								<h3 class="card-title">ID Proof</h3>
							</div>
							<div class="card-body p-0">
								<div class="list-catergory">
									<div class="item-list">
										<img src = "<?php echo $row['adhar_card']?>"  alt="img" class="cover-image"/>
											
									</div>
								</div>
							</div>
						</div>
						<div class="card">
							<div class="card-header">
								<h3 class="card-title">Signature</h3>
							</div>
							<div class="card-body">
								<div class="product-tags clearfix">
								<img src = "<?php echo $row['signature']?>"  alt="img" class="cover-image"/>
								</div>
							</div>
						</div>
				
						</div>
						<?php
                                            }
                                        }
                                        else
                                        {
                                            echo "No Record Found";
                                        }
                                    }
                                   
                                ?>
					</div>
					<!--/ Side Content-->
				</div>
			</div>
		</section>
		<!--All Listing-->
		
		
		


		<script src = "js/jquery.js"></script>
<script src = "js/bootstrap.js"></script>	
	<?php 

include('footer.php');

?>