<?php
$username = "ventexint@gmail.com";
    $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
    $sendername = "EASNUP";
$connect = new PDO("mysql:host=localhost;dbname=easenuik_software", "easenuik_software", "@#admin@#");
?>

<?php
session_start();
include("header.php");
include("menusuper.php");
include("../dbconnection.php");
?>
<meta name=”viewport” content=”width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;” />
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
            <input type="search" class="light-table-filter" data-table="order-table" placeholder="Search" />
<br
<br>
 <table id="example2" class="order-table table table-bordered table-hover">
                  <thead>
                  <tr>
                  
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
            <th><strong>Patient Details</strong></th>
          <th><strong>City</strong></th> 
          <th><strong>Action </strong></th>
                </tr>
                  </thead>
                 
<?php
		$sql ="SELECT * FROM medi_condition_final WHERE  medicalcon='Pregnancy'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		       $sql1 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rspi1 = mysqli_fetch_array($qsql1))
		{
            echo " <tbody>
                                                                                                                                                                
     <tr>  <td><b>UHID</b> $rspi1[patientid]<br>
     <b>Patient Name</b> $rspi1[patientname] </br>
    <b> Husband Name</b> $rspi1[HusbandName] <br><b> Age</b> $rspi1[dob]</td> 
     <td>&nbsp;$rspi1[city]</td>     
         <td><a href='/hco/patient_basic.php?patientid=$rs[patientid]'>Select</a></td>
				
          </tr>                   
          
          ";
}
}
?>          </tr>
                  </thead>
                  


                   </tbody>
  <tfoot>
          </tfoot>
        </table>
        

<script>
$(function () {
    $("#example1").DataTable({
      "responsive": true,
      "autoWidth": false,
    });
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>