Server IP : 162.240.98.243 / Your IP : 18.117.188.138 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("../dbconnection.php"); $sql2 ="SELECT * FROM save_activity WHERE srno='$_GET[srno]'"; $qsql2 = mysqli_query($con,$sql2); if($re1 = mysqli_fetch_array($qsql2)) { include 'dashboarddocument.php'; } ?> <?php include 'fileheader.php'; ?> <h3 align='center'>Medical & Surgical History</h3> <?php $sqlpatient = "SELECT * FROM save_activity WHERE prescriptionid='$_GET[prescriptionid]' AND discription='Intial Assessment<br>Medical and surgical History<br>Doc.no-'"; $qsqlpatient = mysqli_query($con,$sqlpatient); if($rsp = mysqli_fetch_array($qsqlpatient)) { if($rsp[discription]== 'Intial Assessment<br>Medical and surgical History<br>Doc.no-'){ echo"<h4 align='right'>Doc.no : $rsp[srno]</h4>"; } else{ echo ""; } } ?> <section class='content-header'> <?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='right'><a href='edit_showpage_Medical_surgical_History.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]'>Edit </a></h3>"; } ?> </section> <table id="example2" class="table table-bordered table-hover"> <thead> <tr> <div class='card-header d-flex p-0'> <ul class='nav nav-pills ml-auto p-2'> <th><strong>Medical Assessment</strong></th> <th><strong>Status</strong></th> <th><strong> <section class="content-header">Edit</section></strong></th> </tr> </thead> <?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> <td><section class='content-header'> <a href='edit_medicalcon.php?patientid=$rs[patientid]&medicalcoid=$rs[medicalcoid]'>Edit</a></section></td> </tr> "; } ?> <table id="example2" class="table table-bordered table-hover"> <thead> <tr> <div class='card-header d-flex p-0'> <ul class='nav nav-pills ml-auto p-2'> <th><strong>Allergies</strong></th> <th><strong>Category</strong></th> <th><strong><section class='content-header'>Edit</section></strong></th> </tr> </thead> <?php $sql ="SELECT * FROM allergy WHERE patientid='$_GET[patientid]'"; $qsql = mysqli_query($con,$sql); while($ra = mysqli_fetch_array($qsql)) { echo " <tbody> <tr> <td> $ra[Allergen]</td> <td> $ra[Category]</td> <td><section class='content-header'><a href='edit_alg.php?patientid=$ra[patientid]&allergy_id=$ra[allergy_id]'>Edit</section></a></td> </tr> "; } ?> </tr> </thead> </tbody> <tfoot> </tfoot> </table> <table id="example2" class="table table-bordered table-hover"> <?php $sql ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); if($ra = mysqli_fetch_array($qsql)) { echo " <tbody> <tr> <td>Information Obtained from</td> <td> $ra[Information_Obtained_from]</td> </tr> "; } ?> </tr> </thead> </tbody> <tfoot> </tfoot> </table> <?php $sql ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { if(on==$rs[Addiction]) { ?> <div id='mmenu'> <h3 align='center'>Addiction </h3> <table id="example2" class="table table-bordered table-hover"> <?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 " <tr><td width='50%'> Tobacco: </td> <td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>"; } else{ echo ""; } } ?> <?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 " <tr><td width='50%'> Alcohol: </td> <td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>"; } else{ echo ""; } } ?> <?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 " <tr><td width='50%'> Smoking: </td> <td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>"; } else{ echo ""; } } ?> </table> <?php } } ?> </table> <?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)) { $sql1 ="SELECT * FROM site_users WHERE userno='$rs[entered_by]'"; $qsql1 = mysqli_query($con,$sql1); if($rs1 = mysqli_fetch_array($qsql1)) { echo"<h5><b> Created & Updated </b><h5> <table id='example2' class='table table-bordered table-hover'> <tr><td width=50%><b>By :</b>$rs1[name] </b><td width='50%'><b>At :</b> $rs[updated_at] </tr>"; } } ?> </table> </div>