| Server IP : 162.240.98.243 / Your IP : 18.116.15.161 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/public_html/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['Routine_Examination']))
{
date_default_timezone_set("Asia/Calcutta"); //India time (GMT+5:30)
$updated_at= date('d-m-Y H:i:s');
$sql ="UPDATE Pre_Operative_Assessment_Sheet SET Cough='$_POST[Cough]',Fever='$_POST[Fever]',Wheezing='$_POST[Wheezing]',Hypertension='$_POST[Hypertension]',Diabetes='$_POST[Diabetes]',Liverproblem='$_POST[Liverproblem]',Previous_Operation='$_POST[Previous_Operation]',Smoking='$_POST[Smoking]',Migraine='$_POST[Migraine]',Pregnancy='$_POST[Pregnancy]',Bleeding_Disorder='$_POST[Bleeding_Disorder]',SOB='$_POST[SOB]',Palpitation='$_POST[Palpitation]',Chest_Pain='$_POST[Chest_Pain]',Renal_Disease='$_POST[Renal_Disease]',Allergies='$_POST[Allergies]',Alcohol='$_POST[Alcohol]',Anesthesia_Problem='$_POST[Anesthesia_Problem]',Urination='$_POST[Urination]',Back_Neck_Pain='$_POST[Back_Neck_Pain]',Arthritis='$_POST[Arthritis]',Blackouts='$_POST[Blackouts]',Muscie='$_POST[Muscie]',Weight_Loss_Gain='$_POST[Weight_Loss_Gain]',hernia='$_POST[hernia]',Pacemaker='$_POST[Pacemaker]',Artificial='$_POST[Artificial]',Resp_System='$_POST[Resp_System]',Resp_System_note='$_POST[Resp_System_note]',CVS_status='$_POST[CVS_status]',CVS_status_note='$_POST[CVS_status_note]',Dentures_status='$_POST[Dentures_status]',Dentures_status_note= '$_POST[Dentures_status_note]',Dentures_status_lower='$_POST[Dentures_status_lower]',Dentures_lower_note='$_POST[Dentures_lower_note]',Mouth_Opening='$_POST[Mouth_Opening]',Mouth_Opening_note='$_POST[Mouth_Opening_note]',Neck_Mobility='$_POST[Neck_Mobility]',Neck_Mobility_note='$_POST[Neck_Mobility_note]',Venous_Access='$_POST[Venous_Access]',Venous_Access_note='$_POST[Venous_Access_note]',Nervous_System='$_POST[Nervous_System]',Nervous_System_note='$_POST[Nervous_System_note]',Abdomen_System='$_POST[Abdomen_System]',Intubation_Difficulty='$_POST[Intubation_Difficulty]',Intubation_Difficulty_note='$_POST[Intubation_Difficulty_note]',Special_Anesthesia_Problems='$_POST[Special_Anesthesia_Problems]',Special_Anesthesia_Problems_note='$_POST[Special_Anesthesia_Problems_note]',PALLOR='$_POST[PALLOR]',ICTERUS='$_POST[ICTERUS]',CYANOSIS='$_POST[CYANOSIS]',LYMPHNODES='$_POST[LYMPHNODES]',JVP_RAISED='$_POST[JVP_RAISED]',TM_JOINT='$_POST[TM_JOINT]',DENTAL_REACTION='$_POST[DENTAL_REACTION]',Abdomen_note='$_POST[Abdomen_note]',Neck='$_POST[Neck]',Neck_note='$_POST[Neck_note]',Asthama_Breathlesness='$_POST[Asthama_Breathlesness]',BloodTransfusion='$_POST[BloodTransfusion]',Indigestion='$_POST[Indigestion]',Acid='$_POST[Acid]',Heartburn='$_POST[Heartburn]',Hiatus='$_POST[Hiatus]',ContactLens='$_POST[ContactLens]',HearingAid='$_POST[HearingAid]',Hypertension='$_POST[Hypertension]',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 Pre_Operative_Assessment_Sheet 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="Routine_Examination" method="post" >
<h2 align="center">Routine Examination </h2>
<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 Pre_Operative_Assessment_Sheet WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'AND surgeryid='$_GET[surgeryid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo"
<tr>
<td width='25%'>";
if($rs[Cough] == 'on'){
echo "<input type='checkbox' name='Cough' checked>";
} else{
echo "<input type='checkbox' name='Cough' >";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Cough </span></td>";
echo"<td width='25%'>";
if($rs[Fever] == 'on'){
echo "<input type='checkbox' name='Fever' checked>";
} else{
echo "<input type='checkbox' name='Fever' >";
}
echo"</td><td width='25%'><span style='font-size: 17px;'>Fever </span></td>
</tr><tr> <td width='25%'> ";
if($rs[Wheezing] == 'on'){
echo "<input type='checkbox' name='Wheezing' checked>";
}
else
{
echo "<input type='checkbox' name='Wheezing'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Wheezing </span></td>
<td width='25%'> ";
if($rs[Asthama_Breathlesness] == 'on'){
echo "<input type='checkbox' name='Asthama_Breathlesness' checked>";
}
else
{
echo "<input type='checkbox' name='Asthama Breathlesness'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Asthama Breathlesness </span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Liverproblem] == 'on'){
echo "<input type='checkbox' name='Liverproblem' checked>";
}
else
{
echo "<input type='checkbox' name='Liverproblem'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Liver Problem/Jaundice </span>
</td> <td width='25%'> ";
if($rs[Previous_Operation] == 'on'){
echo "<input type='checkbox' name='Previous_Operation' checked>";
}
else
{
echo "<input type='checkbox' name='Previous_Operation'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Tuberculosis </span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Migraine] == 'on'){
echo "<input type='checkbox' name='Migraine' checked>";
}
else
{
echo "<input type='checkbox' name='Migraine'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Headache/Migraine</span></td>
<td width='25%'> ";
if($rs[BloodTransfusion] == 'on'){
echo "<input type='checkbox' name='BloodTransfusion' checked>";
}
else
{
echo "<input type='checkbox' name='BloodTransfusion'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Blood Transfusion</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Bleeding_Disorder] == 'on'){
echo "<input type='checkbox' name='Bleeding_Disorder' checked>";
}
else
{
echo "<input type='checkbox' name='Bleeding_Disorder'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Bleeding Disorder</span></td>
<td width='25%'> ";
if($rs[HearingAid] == 'on'){
echo "<input type='checkbox' name='HearingAid' checked>";
}
else
{
echo "<input type='checkbox' name='HearingAid'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Hearing Aid</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[SOB] == 'on'){
echo "<input type='checkbox' name='SOB' checked>";
}
else
{
echo "<input type='checkbox' name='SOB'>";
}
echo"</td><td width='25%'><span style='font-size: 17px;'>SOB</span></td>
<td width='25%'> ";
if($rs[Palpitation] == 'on'){
echo "<input type='checkbox' name='Palpitation' checked>";
}
else
{
echo "<input type='checkbox' name='Palpitation'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Palpitation</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Chest_Pain] == 'on'){
echo "<input type='checkbox' name='Chest_Pain' checked>";
}
else
{
echo "<input type='checkbox' name='Chest_Pain'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>CAD/PTCA/CABG/Chest Pain</span></td>
<td width='25%'> ";
if($rs[Renal_Disease] == 'on'){
echo "<input type='checkbox' name='Renal_Disease' checked>";
}
else
{
echo "<input type='checkbox' name='Renal_Disease'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Renal Disease</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Allergies] == 'on'){
echo "<input type='checkbox' name='Allergies' checked>";
}
else
{
echo "<input type='checkbox' name='Allergies'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Allergies: Drug/Food</span></td>
<td width='25%'> ";
if($rs[Previous_Admission] == 'on'){
echo "<input type='checkbox' name='Previous_Admission' checked>";
}
else
{
echo "<input type='checkbox' name='Previous_Admission'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Previous Admission</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Indigestion] == 'on'){
echo "<input type='checkbox' name='Indigestion' checked>";
}
else
{
echo "<input type='checkbox' name='Indigestion'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Indigestion</span></td>
<td width='25%'> ";
if($rs[Acid] == 'on'){
echo "<input type='checkbox' name='Acid' checked>";
}
else
{
echo "<input type='checkbox' name='Acid'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Acid</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Fever] == 'on'){
echo "<input type='checkbox' name='Fever' checked>";
}
else
{
echo "<input type='checkbox' name='Fever'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Recent URI/Fever </span></td>
<td width='25%'> ";
if($rs[Anesthesia_Problem] == 'on'){
echo "<input type='checkbox' name='Anesthesia_Problem' checked>";
}
else
{
echo "<input type='checkbox' name='Anesthesia_Problem'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Previous Anesthesia& Problem</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Urination] == 'on'){
echo "<input type='checkbox' name='Urination' checked>";
}
else
{
echo "<input type='checkbox' name='Urination'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Frequent Urination </span></td>
<td width='25%'> ";
if($rs[Back_Neck_Pain] == 'on'){
echo "<input type='checkbox' name='Back_Neck_Pain' checked>";
}
else
{
echo "<input type='checkbox' name='Back_Neck_Pain'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Back/Neck Pain</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Arthritis] == 'on'){
echo "<input type='checkbox' name='Arthritis' checked>";
}
else
{
echo "<input type='checkbox' name='Arthritis'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Arthritis/Painful/Swollen Join </span></td>
<td width='25%'> ";
if($rs[Blackouts] == 'on'){
echo "<input type='checkbox' name='Blackouts' checked>";
}
else
{
echo "<input type='checkbox' name='Blackouts'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Blackouts/Loss of Consciousness</span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[Muscie] == 'on'){
echo "<input type='checkbox' name='Muscie' checked>";
}
else
{
echo "<input type='checkbox' name='Muscie'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Abnormality of Nerve of Muscie </span></td>
<td width='25%'> ";
if($rs[Weight_Loss_Gain] == 'on'){
echo "<input type='checkbox' name='Weight_Loss_Gain' checked>";
}
else
{
echo "<input type='checkbox' name='Weight_Loss_Gain'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'> Weight Loss/Gain </span></td>
</tr>
<tr>
<td width='25%'> ";
if($rs[hernia] == 'on'){
echo "<input type='checkbox' name='hernia' checked>";
}
else
{
echo "<input type='checkbox' name='hernia'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Hiatus hernia </span></td>
<td width='25%'> ";
if($rs[Heartburn] == 'on'){
echo "<input type='checkbox' name='Heartburn' checked>";
}
else
{
echo "<input type='checkbox' name='Heartburn'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Heartburn </span></td>
";
echo"
<tr>
<td width='25%'>";
if($rs[Pacemaker] == 'on'){
echo "<input type='checkbox' name='Pacemaker' checked>";
}
else
{
echo "<input type='checkbox' name='Pacemaker'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Contact Lens/Pacemaker/Hearing Aid </span></td>
<td width='25%'> ";
if($rs[Artificial] == 'on'){
echo "<input type='checkbox' name='Artificial' checked>";
}
else
{
echo "<input type='checkbox' name='Artificial'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'> Artificial Joint/Plates </span></td>
</tr> ";
echo"
<tr>
<td width='25%'>";
if($rs[Hiatus] == 'on'){
echo "<input type='checkbox' name='Hiatus' checked>";
}
else
{
echo "<input type='checkbox' name='Hiatus'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Hiatus </span></td>
<td width='25%'> ";
if($rs[ContactLens] == 'on'){
echo "<input type='checkbox' name='ContactLens' checked>";
}
else
{
echo "<input type='checkbox' name='ContactLens'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>ContactLens </span></td>
</tr> ";
echo " <tr> <td width='25%'>";
if($rs[Hypertension] == 'on'){
echo "<input type='checkbox' name='Hypertension' checked>";
}
else
{
echo "<input type='checkbox' name='Hypertension'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Hypertension </span></td>
<td width='25%'> ";
if($rs[Diabetes] == 'on'){
echo "<input type='checkbox' name='Diabetes' checked>";
}
else
{
echo "<input type='checkbox' name='Diabetes'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Diabetes </span></td>
</tr> ";
echo " <tr> <td width='25%'>";
if($rs[Smoking] == 'on'){
echo "<input type='checkbox' name='Smoking' checked>";
}
else
{
echo "<input type='checkbox' name='Smoking'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Smoking/ Alcohal </span></td>
<td width='25%'> ";
if($rs[Pregnancy] == 'on'){
echo "<input type='checkbox' name='Pregnancy' checked>";
}
else
{
echo "<input type='checkbox' name='Pregnancy'>";
}
echo"</td> <td width='25%'><span style='font-size: 17px;'>Pregnancy </span></td>
</tr> ";
echo"
</tr>
</table>
<table id='example2' class='table table-bordered table-hover' border='1' width='100%'>
<th></th>
<th>Unknown</th>
<tr>
<td width='20%'>Loose Tooth/Dentures
Upper
</td>
<td width='20%'><select name='Dentures_status'>
<option value='$rs[Dentures_status]' >$rs[Dentures_status]</option>
<option value='Unknown' >Unknown</option>
<option value='Present'>Present</option>
<option value='None'>None</option>
</select></td>
</tr>
<tr>
<td width='20%'>Loose Tooth/Dentures
lower
</td>
<td width='20%'><select name='Dentures_status_lower'>
<option value='$rs[Dentures_status_lower]' >$rs[Dentures_status_lower]</option>
<option value='Unknown' >Unknown</option>
<option value='Present'>Present</option>
<option value='None'>None</option>
</select></td>
</tr>
<tr>
<td width='20%'>Mouth Opening
</td>
<td width='20%'><select name='Mouth_Opening_note'>
<option value='$rs[Mouth_Opening_note]' >$rs[Mouth_Opening_note]</option>
<option value='Unknown'>Unknown</option>
<option value='Normal'>Normal</option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
<tr>
<td width='20%'>Neck
</td>
<td width='20%'><select name='Neck'>
<option value='$rs[Neck]' >$rs[Neck]</option>
<option value='Unknown' >Unknown</option>
<option value='SHORT'>SHORT</option>
<option value='LONG'>LONG</option>
<option value='NORMAL'>NORMAL</option>
</select></td>
</tr>
<tr>
<td width='20%'>Neck Mobility
</td>
<td width='20%'><select name='Neck_Mobility'>
<option value='$rs[Neck_Mobility]' >$rs[Neck_Mobility]</option>
<option value='Unknown' >Unknown</option>
<option value='Normal'>Normal</option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
<tr>
<td width='20%'>Venous Access
</td>
<td width='20%'><select name='Venous_Access'>
<option value='$rs[Venous_Access]' >$rs[Venous_Access]</option>
<option value='Unknown' >Unknown</option>
<option value='Normal'>Normal</option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
<tr>
<td width='20%'>Nervous System
</td>
<td width='20%'><select name='Nervous_System'>
<option value='$rs[Nervous_System]' >$rs[Nervous_System]</option>
<option value='Unknown' >Unknown</option>
<option value='Normal'>Normal</option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
<tr>
<td width='20%'>Abdomen
</td>
<td width='20%'><select name='Abdomen_System'>
<option value='$rs[Abdomen_System]' >$rs[Abdomen_System]</option>
<option value='Unknown' >Unknown</option>
<option value='Normal'>Normal</option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
<tr>
<td width='20%'>Intubation Difficulty
</td>
<td width='20%'><select name='Intubation_Difficulty'>
<option value='$rs[Intubation_Difficulty]' >$rs[Intubation_Difficulty]</option>
<option value='Unknown' >Unknown</option>
<option value='Normal'>Normal</option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
<tr>
<td width='20%'>Special Anesthesia Problems
</td>
<td width='20%'><select name='Special_Anesthesia_Problems'>
<option value='$rs[Special_Anesthesia_Problems]' >$rs[Special_Anesthesia_Problems]</option>
<option value='Unknown' >Unknown</option>
<option value='Normal'>Normal </option>
<option value='Attention Needed'>Attention Needed</option>
</select></td>
</tr>
</table>
<table id='example2' class='table table-bordered table-hover' border='1' width='100%'>
</table>
<table id='example2' class='table table-bordered table-hover'>
<tr><td><span style='font-size: 20px'>PALLOR </span></h3></td><td>";
if($rs[PALLOR] == 'on'){
echo "<input type='checkbox' name='PALLOR' checked>";
}
else
{
echo "<input type='checkbox' name='PALLOR'>";
}
echo"
</td>
</tr>
<tr>
<td><span style='font-size: 20px'>ICTERUS</span></h3></td><td>";
if($rs[ICTERUS] == 'on'){
echo "<input type='checkbox' name='ICTERUS' checked>";
}
else
{
echo "<input type='checkbox' name='ICTERUS'>";
}
echo"
</td>
</tr>
<tr><td><span style='font-size: 20px'>CYANOSIS </span></h3></td><td>";
if($rs[CYANOSIS] == 'on'){
echo "<input type='checkbox' name='CYANOSIS' checked>";
}
else
{
echo "<input type='checkbox' name='CYANOSIS'>";
}
echo"
</td>
</tr>
<tr><td><span style='font-size: 20px'>LYMPHNODES </span></h3></td><td>";
if($rs[LYMPHNODES] == 'on'){
echo "<input type='checkbox' name='LYMPHNODES' checked>";
}
else
{
echo "<input type='checkbox' name='LYMPHNODES'>";
}
echo"
</td>
</tr>
<tr>
<td><span style='font-size: 20px'>JVP RAISED </span></h3></td><td>";
if($rs[JVP_RAISED] == 'on'){
echo "<input type='checkbox' name='JVP_RAISED' checked>";
}
else
{
echo "<input type='checkbox' name='JVP_RAISED'>";
}
echo"
</td>
</tr>
<tr>
<td><span style='font-size: 20px'>T.M.JOINT</span></h3></td><td>";
if($rs[TM_JOINT] == 'on'){
echo "<input type='checkbox' name='TM_JOINT' checked>";
}
else
{
echo "<input type='checkbox' name='TM_JOINT'>";
}
echo"
</td>
</tr>
<tr>
<td><span style='font-size: 20px'>DENTAL ABOUT REACTION </span></h3></td><td>";
if($rs[DENTAL_REACTION] == 'on'){
echo "<input type='checkbox' name='DENTAL_REACTION' checked>";
}
else
{
echo "<input type='checkbox' name='DENTAL_REACTION'>";
}
echo"
</td>
</tr>
";
}
?>
</table>
<input type='submit' name='Routine_Examination' value='Submit'>
</form>