<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
include("header.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>Doctors Name</strong></th>
          <th><strong>Qualification </strong></th>
            <th><strong>Specialty </strong></th>
                    <th><strong>Mobile Number</strong></th> </tr>
      
                  </thead>
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once("../LoginManager.php");
require_once('../patientmanager.php');
 $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($rs1 = mysqli_fetch_array($qsql1))
{
$sql ="SELECT * FROM dr WHERE entered_by='$rs1[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{

            echo " <tbody>
            <tr>   <td>&nbsp;$rs[Drname]</td>
              		<td>&nbsp;$rs[Qualification]</td>
              		<td>&nbsp;$rs[Specialty]</td>
              		<td>&nbsp;$rs[numbers]</td>
              		";
             
		  echo "</td></tr>";
         
}
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
          
                    <?php
		$sql ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
if(isset($_SESSION[adminid]))
{
  echo "
             <p align='right'><a  href='prescription.php?patientid=$rs[patientid]'>
          <button style='height:40px;width:200px'> Add New Recods</button><span class='caret'></span></p>
          </a>
          ";
        }
        
        echo "</td></tr>";
      }
     
      ?>
      </div>
      <?php
if(isset($_SESSION[doctorid]))
{
?>  

         
<hr>
	<table>
		<tr>
			<td>
			<div align="center"><strong><a href="prescription.php?patientid=<?php echo $_GET[patientid]; ?>&appid=<?php echo $rsappointment[appointmentid]; ?>">Add Prescription records</a></strong></div>
			</td>
		</tr>
	</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>

<?php
}
?>