Server IP : 162.240.98.243 / Your IP : 3.22.81.57 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/www/login.easenup.in/ |
Upload File : |
<?php session_start(); include 'dbconnection.php'; require_once("../patientmanager.php"); require_once("../DBManager.php"); include 'dashboarddocument.php'; include 'header.php'; if(isset($_POST['Before_Conduction'])) { date_default_timezone_set("Asia/Calcutta"); //India time (GMT+5:30) $updated_at= date('d-m-Y H:i:s'); $sql ="UPDATE Before_Conduction SET Anesthesia_Safety='$_POST[Anesthesia_Safety]',Pulse_Oximeter='$_POST[Pulse_Oximeter]',Known_Allergy='$_POST[Known_Allergy]',Difficult_Airways='$_POST[Difficult_Airways]',Risk_500='$_POST[Risk_500]',updated_at='$_POST[created_at]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $sql1 ="UPDATE save_activity SET created_at='$_POST[created_at]',updated_at='$updated_at' WHERE prescriptionid='$_GET[prescriptionid]' AND userno='$_GET[patientid]' AND discription='Pre-Assessment Sheet<br>Routine Examination<br>Doc.no-'"; 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."; } } $sql ="SELECT * FROM Before_Conduction WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'AND surgeryid='$_GET[surgeryid]'"; $qsql = mysqli_query($con,$sql); $row=$qsql->fetch_assoc(); ?> <div class="content-wrapper"> <section class="content-header"> <form name="Before_Conduction" method="post" > <fieldset> <legend align="center">Before Conduction Of Sign In:</legend> <h3 > </h3> <table id='example2' class='table table-bordered table-hover'> <input type='text' value='<?php echo $row[updated_at] ?>' name='created_at' > <?php $sql ="SELECT * FROM Before_Conduction WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND surgeryid='$_GET[surgeryid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo" <tr> <td width='25%'>"; if($rs[Anesthesia_Safety]=='on') { echo "<input type='checkbox' name='Anesthesia_Safety' checked>"; } else{ echo "<input type='checkbox' name='Anesthesia_Safety' >"; } echo"</td> <td width='25%'><span style='font-size: 17px;'>Anesthesia Safety Check Completed </span></td> <td width='25%'> "; if($rs[Pulse_Oximeter] == 'on'){ echo "<input type='checkbox' name='Pulse_Oximeter' checked>"; } else { echo "<input type='checkbox' name='Pulse_Oximeter'>"; } echo"</td> <td width='25%'><span style='font-size: 17px;'>Pulse Oximeter On And Functioning</span></td> </tr> <tr> <td width='25%'> "; if($rs[Known_Allergy] == 'on'){ echo "<input type='checkbox' name='Known_Allergy' checked>"; } else { echo "<input type='checkbox' name='Known_Allergy'>"; } echo"</td> <td width='25%'><span style='font-size: 17px;'>Does Patient Have A Known Allergy</span> </td> <td width='25%'> "; if($rs[Difficult_Airways] == 'on'){ echo "<input type='checkbox' name='Difficult_Airways' checked>"; } else { echo "<input type='checkbox' name='Difficult_Airways'>"; } echo"</td> <td width='25%'><span style='font-size: 17px;'>Difficult Airways/Aspiration Risk? </span></td> </tr> <tr> <td width='25%'> "; if($rs[Risk_500] == 'on'){ echo "<input type='checkbox' name='Risk_500' checked>"; } else { echo "<input type='checkbox' name='Risk_500'>"; } echo"</td> <td width='25%'><span style='font-size: 17px;'>Risk of> 500 Ml Blood Loss (7ml/Kg In Children)</span></td> </tr> "; } ?> </table> <input type='submit' name='Before_Conduction' value='Submit'> </fieldset> </form>