<?php
session_start();
include("header.php");
include("../dbconnection.php");
include("menusuper.php");
if(isset($_POST['Action_med']))
{
    
 $sql ="UPDATE admin SET ipdacs='$_POST[ipdacs]' WHERE id='$_POST[id]'";
 if($qsql = mysqli_query($con,$sql))
		{
    echo "<script>alert('update successfully');</script>";
  } else {
    echo "Sorry, there was an error uploading your file.";
  } 
     
}


if(isset($_GET[delid]))
{
	$sql ="DELETE FROM site_users WHERE userno='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script>";
	}
}
?>

<style>
th {
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: left;
  background-color: #1e73be;
  color: white;
}
table {
  border-collapse: collapse;
  border-spacing: 0;
  width: 100%;
  border: 1px solid #ddd;
}

th, td {
  text-align: center;
  padding: 16px;
}

tr:nth-child(even) {
  background-color: #f2f2f2;
}
</style>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">


<section class="container">
<h3><input type="search" class="light-table-filter" data-table="order-table" placeholder="Search Hospital" /></h3>


	<table class="order-table">
      <thead>
        <tr>
       
          <th width="20%"><div align="center">Name</div></th>
             <th width="20%"><div align="center">Usertype</div></th>
          <th width="20%"><div align="center">Mobile Number</div></th>    
          <th width="20%"><div align="center">Password</div></th>
          <th width="20%"><div align="center">Action</div></th>
          <th width="20%"><div align="center">Access</div></th>
        </tr>
        </thead>
      <tbody>
   <?php
		$sql ="SELECT * FROM site_users where usertype='Hospital'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    $sql1 ="SELECT * FROM admin where id='$rs[userno]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rs1 = mysqli_fetch_array($qsql1))
		{
        echo "<tr>
	
          <td>
	$rs[uname]
	</td>
		<td>  $rs[usertype] </td>
	<td>
$rs[numbers]</td>
<td>$rs[password]</td>
         ";

		  echo "<td>$rs[status]<br><a href='hsopitalfetch.php?id=$rs[userno]'>View</a> | <a href='Hospitalpending.php?delid=$rs[userno]'>Delete</a></td>
		  <form name='Action_med' method='POST'> <input type='hidden' name='id' value='$rs[userno]'></td>";
		  		    $usertype2=$rs1['ipdacs'];
if($usertype2 == 'on'){
    echo "<td> <input type='checkbox' name='ipdacs' checked><span>IPD Access</span><input type='submit' name='Action_med'></form></td>
    ";
} else{
    echo "<td> <input type='checkbox' name='ipdacs'><span>IPD Access</span><input type='submit' name='Action_med'>
    </form></td>
";
		  echo "</td></tr>";
		}
		}
		}
		?>

      </tbody>
    </table>
    
                                </section>
    <p>&nbsp;</p>
  </div>
</div>
</div>
 <div class="clear"></div>
  </div>
</div>
<?php
include("footers.php");
?>