<?php 
error_reporting(0);
include("common.php");
include("config.php");  
       $id = $_GET['id'];
      $q = "SELECT * FROM contact_book WHERE id='$id'";
        $r = $conn->query($q);
        $data = mysqli_fetch_assoc($r);          
$ssid = $data[state];
		
		
		
		
		$q="select * from state where id='$ssid'";
    $r = $conn->query($q);
    $rr=mysqli_fetch_assoc($r);
	
	 $dsid = $data[district];	
	$q1="select * from district where id='$dsid'";
    $r1 = $conn->query($q1);
    $rr1=mysqli_fetch_assoc($r1);
	
	
	 $cid = $data[country];	
	$q2="select * from country where id='$cid'";
    $r2 = $conn->query($q2);
    $rr2=mysqli_fetch_assoc($r2);
	
	 $ctyp = $data[country_typ];	
	 $q4="select * from country_typ where id='$ctyp'";
    $r4 = $conn->query($q4);
    $rr4=mysqli_fetch_assoc($r4);		
?>

        <!-- START: Template CSS-->
        <link rel="stylesheet" href="dist/vendors/bootstrap/css/bootstrap.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.theme.min.css">
        <link rel="stylesheet" href="dist/vendors/simple-line-icons/css/simple-line-icons.css">        
        <link rel="stylesheet" href="dist/vendors/flags-icon/css/flag-icon.min.css"> 
        <link rel="stylesheet" href="dist/vendors/flag-select/css/flags.css">
        <!-- END Template CSS-->   

        <!-- START: Page CSS-->
        <link rel="stylesheet" href="dist/vendors/quill/quill.snow.css" />
        <!-- END: Page CSS-->

        <!-- START: Custom CSS-->
        <link rel="stylesheet" href="dist/css/main.css">
        <!-- END: Custom CSS-->
  
<style>
table {
  
  border-collapse: collapse;
  width: 100%;
}

td, th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #fff;
}
</style>

        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
    

							
                <!-- START: Card Data-->
                <div class="row">
                    <div class="col-8 mt-3">
                       <div class="card">
<div class="card-header justify-content-between align-items-center">
        <h4 class="card-title"><b><?PHP echo ucfirst($data[first_name]);?> <?PHP echo ucfirst($data[middle_name]);?> <?PHP echo ucfirst($data[last_name]);?></b>
     <span style="float:right"> <a href="add_contact.php">Back to page </a></span></h4>
    </div>
	
    <div class="card-body">
        <div class="table-responsive">
          <table id="example" class="display table dataTable table-striped table-bordered" >
 <tr>
    <td>Group Name</td>
    <td><b><?php echo $data[group_name];?></b></td>
  
  </tr>
  <tr>
    <td><b>Permanant Address</b></td>
    <td> </td>
   
  </tr>
   <tr>
    <td>Address</td>
    <td><?php echo ucfirst($data[address]);?> </td>
  
  </tr>
 
  <tr>
    <td>State</td>
    <td><?php echo ucfirst($rr[state]);?></td>
    </tr>
	  <tr>
    <td>District</td>
    <td><?php echo ucfirst($rr1[district_name]);?></td>
    </tr>
	  <tr>
    <td>City</td>
    <td><?php echo ucfirst($data[city]);?></td>
    </tr>
	  <tr>
    <td>Pincode</td>
    <td><?php echo $data[pincode];?></td>
    </tr>
	  <tr>
   <td><b>Local Address</b></td>
    <td></td>
    </tr>
	    <tr>
    <td>Address</td>
    <td><?php echo ucfirst($data[laddress]);?> </td>
  
  </tr>
  
  <tr>
    <td>State</td>
    <td><?php echo ucfirst($rr[state]);?></td>
    </tr>
	  <tr>
    <td>District</td>
    <td><?php echo ucfirst($rr1[district_name]);?></td>
    </tr>
	  <tr>
    <td>City</td>
    <td><?php echo ucfirst($data[city]);?></td>
    </tr>
	  <tr>
    <td>Pincode</td>
    <td><?php echo $data[pincode];?></td>
    </tr>
	  <tr>
    <td><b>General Info</b></td>
    <td></td>
    </tr>
	  <tr>
    <td>Website Url</td>
    <td><?php echo $data[website];?></td>
    </tr>
	 <tr>
    <td>Birth Date</td>
    <td><?php echo $data[dob];?></td>
    </tr>
	 <tr>
    <td>Anniversary Date</td>
    <td><?php echo $data[annversary_date];?></td>
    </tr>
	 <tr>
    <td>Phone 01</td>
    <td><?php echo $data[phone1];?></td>
    </tr>
	 <tr>
    <td>Phone 02</td>
    <td><?php echo $data[phone2];?></td>
    </tr>
	 <tr>
    <td>Email</td>
    <td><?php echo $data[email];?></td>
    </tr>
	 <tr>
    <td>Email</td>
    <td><?php echo $data[email2];?></td>
    </tr>
	 
	 <tr>
    <td>Note</td>
    <td><b><?php echo $data[note];?></b></td>
  
  </tr>
</table>

      
                                </div>
                            </div>
                        </div> 

                    </div>    
 <div class="col-4 mt-3">

 <div class="card-body">
        <div class="table-responsive">
          <table id="example" class="display table dataTable table-striped table-bordered" >
		  
		  

   
		  

  <tr>
                     <td><?php if($data['photo_copy']==''){?>
					<center><img src="img/vouchersimg_1.png" class="img-fluid"  style="border-radius:5%;width:200px;height:200px;" ></center>
					<?php } else {?>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['photo_copy']; ?>" class="img-fluid"  style="border-radius:5%;width:200px;height:200px;" ></center>
					<?php } ?> </td>
  
  </tr>		

  </table>
  
<table id="example" class="display table dataTable table-striped table-bordered" >
                  <?php if($data['adharfile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['adharfile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
                   <?php if($data['tcfile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['tcfile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
				  <?php if($data['marksheetfile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['marksheetfile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
				  <?php if($data['vcardfile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['vcardfile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
				  <?php if($data['brafile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['brafile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
				  <?php if($data['drifile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['drifile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
				  <?php if($data['otherfile']!=''){?>
                     <tr>
                     <td>
					<center><img src="<?php echo "../admin/".$uploadpath.$data['otherfile']; ?>" class="img-fluid"  style="border-radius:5%;width:300px;height:200px;" ></center>
					</td>
					</tr>	
				  <?php } ?>
  	

  </table>
  

   </div> 
 </div> 
 </div> 
 </div> 
                
        </main>
        <!-- END: Content-->

       <!-- START: Template JS-->
        <script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
        <script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script>    
        <script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        <!-- END: Template JS-->
        
        <!-- START: APP JS-->
        <script src="dist/js/app.js"></script>
        <!-- END: APP JS-->

        <!-- START: Page Vendor JS-->
        <script src="dist/vendors/datatable/js/jquery.dataTables.min.js"></script> 
        <script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
        <script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->        
        <script src="dist/js/datatable.script.js"></script>
    </body>
   
</html>