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

        <!--=========== breadcrumb Section Start =========-->
        <div class="sc-breadcrumb-style sc-pt-80 sc-pb-80">
            <div class="container position-relative">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="sc-slider-content p-z-idex">
                            <div class="sc-slider-subtitle">Home - Verify Client Cerificate</div>
                            <h1 class="slider-title white-color sc-mb-25 sc-sm-mb-15">Verify Client Cerificate</h1>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--=========== breadcrumb Section End =========-->

        <!--=========== about Section Start =========-->

        <!--=========== about Section End =========-->

        <!--=========== Working Process section Start =========-->
        <div class="sc-contact-section sc-pt-100 sc-md-pt-70 pb-150">
            <div class="container">
                <div class="row">
                    <div class="col-lg-6 offset-lg-3 text-center">
                        <div class="bgcfrms">
                             <form method="POST" class="row">
                                <div class="form-box" class="col-lg-12">
                                    <input class="from-control ipussstd" type="text"  name="location" placeholder="Enter Your Certificate No. *" required=""
                                    />
                                </div>
                                <div class="col-lg-12">
                                    <div class="submit-button sc-primary-btn">
                                        <input type="submit" name="btnclient" value="Send Message" style="color:#fff !important" />
                                    </div>
                                </div>
                             </form>
  
                        </div>
                    </div>
                </div>
                
        </div>
        </div>






        <?php 
if(isset($_POST['btnclient']))
{
  $certificatenumber = $_POST['location'];
  $selectdata = "SELECT * FROM `tbl_blog` WHERE `location`='$certificatenumber'";
  $dataselect = mysqli_query($link,$selectdata);
  $showdata = mysqli_fetch_array($dataselect);
  if($certificatenumber==$showdata['location'])
  {

  
    


    echo '<section class="pb-150 pt-0">
    <div class="container">



        <div class="row">
            <div class="col-lg-12 text-center">
                <div class="catsss">
                   
                </div>
            </div>

            
            <div class="col-lg-12 tblews">
                <div class="table-responsive">
              <table class="table table-bordered table-striped">
                                              
                  <tbody>
                      
                      <tr>
                     <th> Name</th>
                     <td>'.$showdata["title"].'</td>
                     
                 </tr>
                 <tr>
                 <th>Address </th>
                 <td>'.$showdata["blog_desc"].'</td>
                 
             </tr>
                 <tr>
                     <th>Certificate Number</th>
                     <td>'.$showdata["location"].'</td>
                     
                 </tr>
                
                 <tr>
                 <th>Scope </th>
                 <td>'.$showdata["scope"].'</td>
                 
             </tr>
             <tr>
             <th>Standard </th>
             <td>'.$showdata["sub_title"].'</td>
             
         </tr>
                 <tr>
                 <th>Issue Date </th>
                 <td>'. date('d F Y',strtotime($showdata['idate'])) .'</td>
                 
             </tr>
             
                 
                
                
                
                 
                 <tr>
                     <th>Status </th>
                     <td>'.$showdata["vdate"].'</td>
                     
                 </tr>
             
         </tbody></table>
      </div>
            </div>
        </div>
        
    </div>
</section>';
  }elseif(isset($_POST['btnclient']))
  {
    $certificatenumber = $_POST['location'];
    $selectdata = "SELECT * FROM `tbl_lead_auditor` WHERE `location`='$certificatenumber'";
    $dataselect = mysqli_query($link,$selectdata);
    $showdata = mysqli_fetch_array($dataselect);
    if($certificatenumber==$showdata['location'])
    {
  
    
      
  
  
      echo '<section class="pb-150 pt-0">
      <div class="container">
  
  
  
          <div class="row">
              <div class="col-lg-12 text-center">
                  <div class="catsss">
                   
                  </div>
              </div>
  
              
              <div class="col-lg-12 tblews">
                  <div class="table-responsive">
                <table class="table table-bordered table-striped">
                                                
                    <tbody>
                        
                        <tr>
                       <th> Name</th>
                       <td>'.$showdata["title"].'</td>
                       
                   </tr>
                   <tr>
                       <th>Certificate Number</th>
                       <td>'.$showdata["location"].'</td>
                       
                   </tr>
                   <tr>
                   <th>Issue Date </th>
                   <td>'. date('d F Y',strtotime($showdata['idate'])) .'</td>
                   
               </tr>
               <tr>
               <th>Status </th>
               <td>'.$showdata["vdate"].'</td>
               
           </tr>
           <tr>
                       <th>Standard </th>
                       <td>'.$showdata["sub_title"].'</td>
                       
                   </tr>
                   
                   
                   <tr>
                   <th>Type of course </th>
                   <td>'.$showdata["tcourse"].'</td>
                   
               </tr>
                   
                 
               
           </tbody></table>
        </div>
              </div>
          </div>
          
      </div>
  </section>';
    }else{
    echo  '<script>alert("There Something Wrong In Your Certificate Number")</script>';
  }

}
}


?>






        
  
    
        <!--=========== blog section End =========-->

        <?php 
       include ('include/footer.php');
       ?>