<?php 
include('database_connection.php');
$id = $_GET['id'];
//echo $id;


$slab_nature_lab = '';
$query = "SELECT * FROM tbl_slab WHERE slab_id=".$id." ORDER BY slab_id ASC";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
 $slab_name = $row['slab_name'];
 $slab_certificate_number = $row['slab_certificate_number'];
 $slab_number = $row['slab_number'];
 $slab_mail = $row['slab_mail'];
 $slab_address = $row['slab_address'];
 $slab_city = $row['slab_city'];
 $slab_nature_lab = $row['slab_nature_lab'];
 $slab_scope = $row['slab_scope'];
 $slab_types_of_tests = $row['slab_types_of_tests'];
 $slab_test_standard = $row['slab_test_standard'];
}

/*
print_r ($result);

echo "<br>";
echo $result['slab_id'];*/
?>


<html>
 <head>
  <title>Iamps</title>
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  <script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
  <script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>  
  <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  
 </head>
 <body>
 <div class="heading" style="background-color:#232F3E">
		<img src="https://iampshz.com/static/images/iampshz/logo-white.png" style="padding-left:4%">
		<div style="font-size:30px;font-weight:bold;color:white;padding-left:4%"> KARNATAKA LABS LIST : EMC Testing Company Directory<br><a href="https://iampshz.com/" style="color:white" >Home</a>
	 </div>
	</div>
  <div class="container box">
   <br />
   <div class="row">
   
   <div class="table-responsive">
   <a href="index.php" class="btn btn-primary pull-right">Back</a><br><br>
 <table class="table  table-bordered table-sm">
  <thead >
    <tr>
       <th colspan="3">LAB DETAILS</th>
     </tr>
   </thead>
   <tbody>
      <tr>
		 <td colspan="2" style="font-weight:bold">Name </td>
         <td><?php echo  $slab_name ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold" width="40%">Certificate Number </td>
         <td><?php echo  $slab_certificate_number ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold" width="40%">Contact Number </td>
         <td><?php echo  $slab_number ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold">Email</td>
         <td><?php echo  $slab_mail ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold">Address </td>
         <td><?php echo  $slab_address ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold">City </td>
         <td><?php echo  $slab_city ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold">Nature Of Lab </td>
         <td><?php echo  $slab_nature_lab ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold">Scope </td>
         <td><?php echo  $slab_scope ;?></td>
      </tr>
     
      <tr>
		 <td colspan="2" style="font-weight:bold">Type of Tests </td>
         <td><?php echo  $slab_types_of_tests ;?></td>
      </tr>
      <tr>
		 <td colspan="2" style="font-weight:bold">Test Standard </td>
         <td><?php echo  $slab_test_standard ;?></td>
      </tr>
     
   </tbody>
</table>
</div>

    
	</div>
</body>
</html>	