<?php
include("dbconnection.php");
include("menu.php");
?>
     <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
              <!-- /.card-header -->
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Patient Details</strong></th>
           <th><strong>Location</strong></th>    
            <th><strong>Select</strong></th>
        </tr>
      
                  </thead>
<?php
$sql ="SELECT * FROM patient WHERE patientname='$_GET[patientname]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
            echo " <tbody>
            <tr>   <td><b>UHID :</b>$rs[patientid]<br><b>Name : </b>$rs[patientname]<br><b>Gender : </b>$rs[gendor]<br><b>C/O :</b>$rs[HusbandName]<br><b>DOB :</b>$rs[dob]<br></td>
              					<td>&nbsp;$rs[city]</td>
					<td><a href='Pharmacy/patient_basic.php?patientid=$rs[patientid]' >Select</td>
          </tr>                   
          
          ";
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
                </div>
      <?php
if(isset($_SESSION[doctorid]))
{
?>  

         
<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>

<?php
}
?>
</form>
</html>