| Server IP : 162.240.98.243 / Your IP : 3.22.70.206 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");
if(isset($_POST[Brief_History]))
{
{
$sql ="INSERT INTO Brief_History_Patient(Briefid,prescriptionid,patientid, Family_History) values(Null,'$_POST[prescriptionid]','$_POST[patientid]','$_POST[Family_History]')";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Team inserted successfully...');</script><script>window.location='PreOperativeAssessmentSheet.php?patientid=$_GET[patientid]&prescriptionid=$_GET[prescriptionid]';</script>;</script>";
}
else
{
echo mysqli_error($con);
}
}
}
if(isset($_GET[editid]))
{
$sql="SELECT * FROM immunization WHERE patientid='$_GET[editid]' ";
$qsql = mysqli_query($con,$sql);
$rsedit = mysqli_fetch_array($qsql);
}
if(isset($_SESSION[patientid]))
{
$sqlpatient = "SELECT * FROM patient WHERE patientid='$_SESSION[patientid]' ";
$qsqlpatient = mysqli_query($con,$sqlpatient);
$rspatient = mysqli_fetch_array($qsqlpatient);
$readonly = " readonly";
}
?>
<?php
$sql ="SELECT * FROM Brief_History_Patient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
echo"
<h3 align='right'><a href='edit_showpage_Brief_History_Patient.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&surgeryid=$rs[surgeryid]'><i class='fa fa-pencil-square-o'></i> </a></h3>";
}
?>
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<br> <h3 align="center">Brief History Of Patient </h3>
<div><input type="button" onclick="myFunction('Demo1')" value="Medical Condition"></div>
<div id="Demo1" class="w3-container w3-hide">
<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 Condition</strong></th>
<th><strong>Status</strong></th>
<th><strong>Edit</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]</td>
<td> $rs[Status]</td>
<td><a href='edit_medicalcon.php?patientid=$rs[patientid]&medicalcoid=$rs[medicalcoid]'><i class='fa fa-pencil-square-o'></i></a></td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<?php
$sql ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rt = mysqli_fetch_array($qsql))
{
echo"
<button style='height:40px;width:100px'><a href='medicalcon_nurse.php?patientid=$rt[patientid]'>Add More</a></button>
";
}
?>
<script>
function myFunction(id) {
var x = document.getElementById(id);
if (x.className.indexOf("w3-show") == -1) {
x.className += " w3-show";
} else {
x.className = x.className.replace(" w3-show", "");
}
}
</script>
<script>
function Disease(id) {
var x = document.getElementById(id);
if (x.className.indexOf("w3-show") == -1) {
x.className += " w3-show";
} else {
x.className = x.className.replace(" w3-show", "");
}
}
</script>
</div>
<br>
<div><input type="button" onclick="haripa('Demo4')" value="Known Allergies"></div>
<div id="Demo4" class="w3-container w3-hide">
<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>Edit</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><a href='edit_alg.php?patientid=$ra[patientid]&allergy_id=$ra[allergy_id]'>Edit</a></td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<?php
$sql ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($ra = mysqli_fetch_array($qsql))
{
echo"
<button style='height:40px;width:100px'><a href='Allergies.php?patientid=$ra[patientid]'>Add More</a></button>
";
}
?>
</div>
<script>
function haripa(id) {
var x = document.getElementById(id);
if (x.className.indexOf("w3-show") == -1) {
x.className += " w3-show";
} else {
x.className = x.className.replace(" w3-show", "");
}
}
</script>
<br>
<div><input type="button" onclick="harila('Demo')" value="Addiction"></div>
<div id="Demo" class="w3-container w3-hide">
<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'> <?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>
<?php
$sql ="SELECT * FROM Medical_surgical WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
$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]' AND surgeryid='$_GET[surgeryid]'";
$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]' AND surgeryid='$_GET[surgeryid]'";
$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>
</div>
<script>
function harila(id) {
var x = document.getElementById(id);
if (x.className.indexOf("w3-show") == -1) {
x.className += " w3-show";
} else {
x.className = x.className.replace(" w3-show", "");
}
}
</script>
<br>
<form method="post" name="Brief_History">
<?php
$sqlpatient= "SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND surgeryid='$_GET[surgeryid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rspatient=mysqli_fetch_array($qsqlpatient))
{
echo "
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$rspatient[prescriptionid]'></td><input type='hidden' name='patientid' id='patientid' value='$rspatient[patientid]'></td>";
}
?>
<table id="example2" class="table table-bordered table-hover">
<thead>
<?php
$sqlpatient= "SELECT * FROM Brief_History_Patient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND surgeryid='$_GET[surgeryid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
if($rspatient=mysqli_fetch_array($qsqlpatient))
{
echo"
<tr>
<td>Family History : </td><td>
$rspatient[Family_History]</td>
</tr>
";
}
?>
</table> </form>
<br>