<?php
session_start();
require_once("../dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
?>

<table id='example2' class='table table-bordered table-hover>
                  <tr>
                  
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
      
         <th><strong>Drugs</strong></th>
          <th><strong>Dose(mg)</strong></th> 
          <th><strong>Route</strong></th>
           <th><strong>Frequency</strong></th>
           <th><strong>Duration</strong></th>
              <th><strong>Edit</strong></th>
                </tr>
<?php 

$conn = new mysqli('localhost', 'easenupo_hcosoftware', '@#admin@#', 'easenupo_hcosoftware');
if ($conn->connect_error) {
	die("Connection error: " . $conn->connect_error);
}

$result = $conn->query("SELECT * FROM medication");
if ($result->num_rows > 0) {
	while ($row = $result->fetch_assoc()) {
		$pavan=$row['drug'];
		$sravan=$row['dose'];
	
echo "<tr>
<td>$pavan</td>
<td>$sravan</td>
</tr>
";
}
}
?>
</table