<?php

 if(isset($_POST[statusg]))
{ 
      date_default_timezone_set('Asia/Kolkata');
$date = date('y-m-d h:i:s');
$finaltm=$date;
$sql ="UPDATE site_users SET status='$_POST[status]' WHERE  userno='$_GET[userno]'";
$sql2 ="UPDATE atten SET punchsp='20$finaltm' WHERE  userno='$_GET[userno]'";
if($qsql = mysqli_query($con,$sql))
if($qsql = mysqli_query($con,$sql2))
		{
    echo "<script>
 window.history.go(-1)</script>";
     } 
    
}
?>


 <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <td bgcolor="1e73be"><strong> <span style="color:white">Name</span></strong></td>
          <td bgcolor="1e73be"><strong> <span style="color:white">Username</span></strong></td>
            <td bgcolor="1e73be"><strong> <span style="color:white">Password </span></strong></td>
          <td bgcolor="1e73be"><strong> <span style="color:white">Action<</span></strong></td>
        </tr>
      
                  </thead>
<?php

$sqlpatient1 = "SELECT * FROM site_users WHERE entered_by='$harilal' AND status='Deactivate' AND usertype='Doctor' OR entered_by='$harilal' AND status='Deactivate' AND usertype='FrontOffice' OR entered_by='$harilal' AND status='Deactivate' AND usertype='pharma' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Nurse'  OR entered_by='$harilal' AND status='Deactivate' AND usertype='RMO' OR entered_by='$harilal' AND status='Deactivate' AND usertype='HR' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Account' OR entered_by='$harilal' AND status='Deactivate' AND usertype='OT' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Lab' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Diagnostic' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Subadmin' OR entered_by='$harilal' AND status='Deactivate' AND usertype='lab_Doctor' OR entered_by='$harilal' AND status='Deactivate' AND usertype='lab_FrontOffice' OR entered_by='$harilal' AND status='Deactivate' AND usertype='lab_Account'  OR entered_by='$harilal' AND status='Deactivate' AND usertype='Biomed' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Maintenance' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Security' OR entered_by='$harilal' AND status='Deactivate' AND usertype='store' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Transport' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Cleaning' OR entered_by='$harilal' AND status='Deactivate' AND usertype='Optometrist'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
            echo " <tbody>
          
            <tr>   <td>&nbsp;$rsn[name]</td>
              		<td>&nbsp;$rsn[uname]</td>
              		 <td>&nbsp;$rsn[password]</td>
<td>&nbsp;<form method='post' name='statusg' action='CreatedPlayerAccess.php?userno=$rsn[userno]'>
<input type='hidden' name='status' Value='Active'>
<input type='submit' name='statusg' Value='Active' class='btn btn-warning'>
</form>
";
}
?> 


    </tr> 

</tbody>
  <tfoot>
          </tfoot>
        </table>