<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
//Code for Registration 
if(isset($_POST['update'])) 
{ 
    	$updated_at=date("F d, Y / h:i:s A");
$sql ="UPDATE Dressing  SET created_at='$_POST[created_at]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
$sql1 ="UPDATE patient_invace SET created_at='$_POST[created_at]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND pagetype='$_GET[id]'";
if($qsql = mysqli_query($con,$sql))
		{
		    if($qsql = mysqli_query($con,$sql1))
		    {
    echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } 
  }else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
    <form name='update' method='POST'>
  <table id="example2" class="table table-bordered table-hover"> 

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

$sql4 ="SELECT * FROM Dressing WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND id='$_GET[id]'";
		$qsql4 = mysqli_query($con,$sql4);
		while($rp = mysqli_fetch_array($qsql4))
		{
		    	$sql1 ="SELECT * FROM site_users WHERE userno='$rp[entered_by]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re = mysqli_fetch_array($qsql1))
		{
        echo " <tbody>
	                <tr>
                    <td>&nbsp;Timing</td>
                 <td><input type='datetime-local' name='created_at' value='$rp[created_at]' required></td>
                 </tr>
                 <tr>
                    <td>&nbsp;Performed</td>
                 <td>&nbsp;$rp[done]</td>
                 </tr>
                 <tr><td>&nbsp;Created By</td>
                    <td>&nbsp;$re[name]</td>
                    </tr>                   
          
          ";


}

}

?>   
</tbody>
 </table>
 <input type='submit' value='Update' name='update'>
 </form>