<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
include("database.php");
$db=$conn;
// fetch query
function fetch_data(){
 global $db;

  $query="SELECT * from patient";
  $exec=mysqli_query($db, $query);
  if(mysqli_num_rows($exec)>0){
    $row= mysqli_fetch_all($exec, MYSQLI_ASSOC);
    return $row;
      
  }else{
 return $row=[];
  }
}

$fetchData= fetch_data();
show_data($fetchData);
function show_data($fetchData){
 echo '<table border="1">
        <tr>
            <th>S.N</th>
            <th>Full Name</th>
        </tr>';
 if(count($fetchData)>0){
      $srno=1;
      foreach($fetchData as $data){ 
  echo "<tr>
          <td>".$srno."</td>
          <td>".$data['patient_name']."</td>
      
   </tr>";
       
  $srno++; 
     }
}else{
     
  echo "<tr>
        <td colspan='7'>No Data Found</td>
       </tr>"; 
}
  echo "</table>";
}

?>