| Server IP : 162.240.98.243 / Your IP : 18.191.178.183 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();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'dashboarddocument.php';
?>
<?php
include 'fileheader.php';
?>
<h2 align="center">Initial Diagnosis</h2>
<form method="post" action="" name="submit" onSubmit="return validateform()">
<table id="example2" class="table table-bordered table-hover">
<tbody>
<?php
$sqlpatient= "SELECT * FROM request_for_admission WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rr=mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1= "SELECT * FROM addaspatient WHERE prescriptionid='$rr[prescriptionid]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rr1=mysqli_fetch_array($qsqlpatient1))
{
$sqlpatient2= "SELECT * FROM Vulnerability WHERE prescriptionid='$rr1[prescriptionid]'";
$qsqlpatient2 = mysqli_query($con,$sqlpatient2);
while($rr2=mysqli_fetch_array($qsqlpatient2))
{
echo "
<tr> <td height='62'> Consultant: </td>
<td>";
$sqldoctor= "SELECT * FROM site_users WHERE userno='$rr1[Admitted_Under]'";
$qsqldoctor = mysqli_query($con,$sqldoctor);
while($rsdoctor = mysqli_fetch_array($qsqldoctor))
{
echo"
$rsdoctor[name]
";
}
echo"</td></tr>
<tr> <td height='62'> Reason for Admission: </td>
<td>$rr[Reason_for_Admission]</td></tr>
<tr><td height='62'> Vulnerability/Triage Assessment: </td>
<td>$rr1[triage]</td>
</tr>
";
}}
}
?>
<tr><td width='50%'> Covid 19 Checklist: </td>
<?php
$DisplayForm=True;
$sql7 ="SELECT * FROM CovidChecklist WHERE prescriptionid='$_GET[prescriptionid]'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if(!$DisplayForm)
{
echo "
<td width='50%'><DIV class='button' data-modal='modalOne'> <span style='color:blue;align:center;font-size: 14px'>Filled</span></DIV></td>";
} else{
echo "<td width='50%'>Not Applicable</td>";
}
?>
</tr>
<tr><td width='50%'>MLC: </td>
<?php
$DisplayForm=True;
$sql7 ="SELECT * FROM mlc WHERE prescriptionid='$_GET[prescriptionid]'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if(!$DisplayForm)
{
echo "
<td width='50%'><DIV class='button' data-modal='modalmlc'> <span style='color:blue;align:center;font-size: 14px'>Filled</span></DIV></td>";
} else{
echo "<td width='50%'>Not Applicable</td>";
}
?>
</tr>
<tr><td width='50%'>Trauma: </td>
<?php
$DisplayForm=True;
$sql7 ="SELECT * FROM trauma_checklist WHERE prescriptionid='$_GET[prescriptionid]'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if(!$DisplayForm)
{
echo "
<td width='50%'><DIV class='button' data-modal='modaltrauma'> <span style='color:blue;align:center;font-size: 14px'>Filled</span></DIV></td>";
} else{
echo "<td width='50%'>Not Applicable</td>";
}
?>
</tr>
</tbody>
</table>
<br>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr><th>Medical Assessment </th><th>Status</th></tr>
<?php
$sql ="SELECT * FROM medi_condition_final WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[medicalcon] <b>$rs[Specify]</b></td>
<td> $rs[Status]</td>
</tr>
";
}
?> </table>
<?php
$sql3 ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql3 = mysqli_query($con,$sql3);
if($rs2 = mysqli_fetch_array($qsql3))
{
if(on==$rs2[Addiction])
{
?>
<h3 align='center'>Addiction </h3>
<table id='example2' class='table table-bordered table-hover'>
<tr> <?php
$sql ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Tobacco'];
if($usertype == 'on'){
echo "<td width='50%'>Tobacco: </td>
<td width='50%'> <i class='fa fa-check' aria-hidden='true'></i></td>";
} else{
echo "<td width='50%'>Tobacco: </td><td width='50%'> <i class='fa fa-times' aria-hidden='true'></i></td>";
}
}
?>
</tr>
<tr>
<?php
$sql ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Alcohol'];
if($usertype == 'on'){
echo "<td width='50%'>Alcohol: </td>
<td width='50%'> <i class='fa fa-check' aria-hidden='true'></i></td>";
} else{
echo "<td width='50%'>Alcohol: </td><td width='50%'> <i class='fa fa-times' aria-hidden='true'></i></td>";
}
}
?>
</tr>
<tr>
<?php
$sql ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Smoking'];
if($usertype == 'on'){
echo "<td width='50%'>Smoking: </td>
<td width='50%'> <i class='fa fa-check' aria-hidden='true'></i></td>";
} else{
echo "<td width='50%'>Smoking: </td><td width='50%'> <i class='fa fa-times' aria-hidden='true'></i></td>";
}
}
?>
</tr>
<?php
}
}
?>
<table id="example2" class="table table-bordered table-hover">
<thead>
<?php
$sqlpatient2= "SELECT * FROM Vulnerability WHERE prescriptionid='$_GET[prescriptionid]'";
$qsqlpatient2 = mysqli_query($con,$sqlpatient2);
while($rtv=mysqli_fetch_array($qsqlpatient2))
{
echo"
<tr><td height='62'>Level of Consciousness : </td>
<td>$rtv[Level_Consciousness]</td>
</tr>
<tr><td height='62'>Dependency: </td>
<td>$rtv[Dependency]</td>
</tr>
<tr><td height='62'>Mode of movement: </td>
<td>$rtv[Modn]</td>
</tr>
<tr><td height='62'>Pain Assessment: </td>
<td>$rtv[Pain_Assessment]</td>
</tr>
<tr><td height='62'>Pain Location: </td>
<td>$rtv[Pain_Location]</td>
</tr>
";
}
?>
<tr>
<?php
$sql ="SELECT * FROM Vulnerability WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['fall_risk'];
if($usertype == 'on'){
echo "<td width='50%'>Fall Risk: </td>
<td width='50%'> <i class='fa fa-check' aria-hidden='true'></i></td>";
} else{
echo "<td width='50%'>Fall Risk: </td><td width='50%'> <i class='fa fa-times' aria-hidden='true'></i></td>";
}
}
?>
</tr>
<tr><td width='50%'>Nutritional Screening : </td>
<?php
$DisplayForm=True;
$sql7 ="SELECT * FROM Nutritional_Screening WHERE prescriptionid='$_GET[prescriptionid]'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if(!$DisplayForm)
{
echo "
<td width='50%'><a href='link' style='color:blue'>Available</a></td>";
} else{
echo "<td width='50%'>Unavailable</td>";
}
?>
</tr>
</table>
</div>
</br></br>
<div class='center'>
<table id='example2' class='table table-bordered table-hover'>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
echo"
<h3 align='center'>Chief Complain <a href='edit_showpage_Medical_Assessment.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]'><B>Edit</B> </a>";
}
?>
</h3>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Fever'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Fever: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Fever_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['smell'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Loss of Smell: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[smell_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Diarrhoea'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Diarrhoea: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Diarrhoea_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Deformity'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Facial Deformity: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Deformity_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Cough'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Cough: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Cough_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Taste'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Loss of Taste: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Taste_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Weakness'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Weakness: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Weakness_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Breathlessness'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Breathlessness: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Breathlessness_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Appetite'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Shivering: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Appetite_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Limbs'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Power Loss in Limbs: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Limbs_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Throat'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Sore Throat : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Throat_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Vomitting'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Vomitting : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Vomitting_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Slurred_Voice'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Slurred Voice: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Slurred_Voice_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Nausea'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Nausea: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Nausea_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Loss_Appetite'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Loss of Appetite: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Loss_Appetite_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Delusion'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Delusion: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Delusion_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Fits_Anger'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Fits of Anger: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Fits_Anger_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Depression'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Depression: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Depression_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Memory_Loss'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Memory Loss: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Memory_Loss_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Bleeding_Disorder'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Bleeding Disorder: </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Bleeding_Disorder_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Migraine'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Migraine : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Migraine_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Frequent_Urination'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Frequent Urination : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Frequent_Urination_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Swollen_Join'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Swollen Join : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Swollen_Join_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Weight_Gain'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Weight Gain : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Weight_Gain_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['weight_loss'];
if($usertype == 'on'){
echo " <tr><td width='33%'> weight loss : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[weight_loss_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Body_pain'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Body pain : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Body_pain_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Physical_Injury'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Physical Injury : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Physical_Injury_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tr><td width='33%'> Other Symptoms : </td>
<td width='33%'>$rs[Other_Symptoms]</td></tr>";
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['RED_EYE'];
if($usertype == 'on'){
echo " <tr><td width='33%'> RED EYE : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[RED_EYE_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Swollen_Eye'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Swollen Eye : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Swollen_Eye_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Conjuctiva'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Conjuctiva : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Conjuctiva_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Itchiness'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Itchiness : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Itchiness_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Dislocated'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Dislocated : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Dislocated_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Blur_Vision'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Blur Vision : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Blur_Vision_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Partial_Blindness'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Partial Blindness : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Partial_Blindness_note]</td></tr>";
} else{
echo "";
}
}
?>
<?php
$sql ="SELECT * FROM Medical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$usertype=$rs['Blindness'];
if($usertype == 'on'){
echo " <tr><td width='33%'> Blindness : </td>
<td width='33%'><i class='fa fa-check' aria-hidden='true'></i></td><td width='33%'>$rs[Blindness_note]</td></tr>";
} else{
echo "";
}
}
?>
</table>
<?php
session_start();
require_once('../LoginManager.php');
require_once('../DBManager.php');
$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
if((Eye_Care!==$rs[casetype]) || ('Eye_Care'==$rs[casetype]))
{
?>
<?php
$sql ="SELECT * FROM opdslip WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
echo" <table id='example2' class='table table-bordered table-hover'>
<tr><td width='50%'>Significant findings : </td>
<td width='50%'>$rs[significate]</td></tr>
<tr><td>Nutritional diagnosis</td><td>$rs[Nutritional_Diagnosis]</td></tr>";
$sqlpatient1 = "SELECT * FROM list_tretment WHERE trid=$rs[tratment]";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo " <tr> <td>Proposed Surgery:</td>
<td>$rsn[tratment]</td></tr>";
}
}
?>
<?php
}
}
?>
</table>
<?php
session_start();
require_once('../LoginManager.php');
require_once('../DBManager.php');
$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
if(Eye_Care==$rs[casetype])
{
?>
<table id="example2" class="table table-bordered table-hover">
<tr><th>Provisional diagnosis</th>
<th>Eye</th>
<th>Note</th>
</tr>
<tr>
<?php
$sql ="SELECT * FROM opdslip WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<td> $rs[Admission_diagnosis] <b>$rs[other_Admission_diagnosis]</td>
<td> $rs[eyetype] </td>
<td> $rs[note] </td>
";
}
}
}
?>
</div>