| Server IP : 162.240.98.243 / Your IP : 3.14.134.17 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('dbconnection.php');
include('dashboarddocument.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="Dashboard">
<meta name="keyword" content="Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina">
<title>Hospital Dashboard</title>
<style>
.center {
border: 1px solid blue;
}
h3 {
color: #1e73be;
}
</style>
</head>
<body>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class='center'>
<br>
<h3 align='center'> Patient Profile </h3>
<br>
</head>
<table id="example2" class="table table-bordered table-hover">
<tbody>
<form name="sub" method="post">
<?php
$sql ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "<tr>
<td><b>UHID :</b></td>
<td>$rs[patientid]</td>
</tr>
<tr>
<td><b>Familyid :</b></td>
<td>$rs[familyid]</td>
</tr>
<tr>
<td><b>Patient Name :</b></td>
<td>$rs[patientname]</td>
</tr>
<tr>
<td><b>Email Id :</b></td>
<td>$rs[Email]</td>
</tr>
<tr>
<td><b>Mobile Number</b></td>
<td>$rs[numbers]</td>
</tr>
<tr>
<td><b>Gender</b></td>
<td>$rs[gendor]</td>
</tr>
<tr>
<td><b>Age</b></td>
<td>$rs[dob]</td>
</tr><tr>
<td><b>Weight (kg)</b></td>
<td>$rs[Weight]</td>
</tr>
<tr>
<td><b>Height (cm)</b></td>
<td>$rs[Height]</td></tr>
<tr>
<td><b>Blood Group</b></td>
<td>$rs[bloodgroup]</td>
</tr>
<tr>
<td><b>Nationality</b></td>
<td>$rs[Nationality]</td></tr>
<tr>
<td><b>Marital Status</b></td>
<td>$rs[Marital]</td>
</tr>
<tr>
<td><b>Religion </b></td>
<td>$rs[Religion]</td></tr>
<tr>
<td><b>Occupation</b></td>
<td>$rs[Occupation]</td>
</tr>
<tr>
<td><b>Family income </b></td>
<td>$rs[Familyinc]</td></tr>
<tr>
<td><b>Education Qualification</b></td>
<td>$rs[Education]</td>
</tr>
<tr>
<td><b>Passport Number </b></td>
<td>$rs[Passportnm]</td></tr>
<tr>
<td><b>Aadhar Number</b></td>
<td>$rs[AadharNu]</td>
</tr>
<tr>
<td><b>Referred By </b></td>
<td>
";if(is_numeric($rs[Referred]))
{
$sql12 ="SELECT * FROM site_users WHERE userno='$rs[Referred]'";
$qsql12 = mysqli_query($con,$sql12);
if($re1234 = mysqli_fetch_array($qsql12))
{
$sql13 ="SELECT * FROM admin WHERE id='$re1234[entered_by]'";
$qsql13 = mysqli_query($con,$sql13);
if($reas = mysqli_fetch_array($qsql13))
{
echo"
$reas[hsname] </td></tr>";
}
}
}
echo"
<tr>
<td><b>Country</b></td>
<td>$rs[Country]</td>
</tr>
<tr>
<td><b>State </b></td>
<td>$rs[State]</td></tr>
<tr>
<td><b>City </b></td>
<td>$rs[city]</td>
</tr>
<tr>
<td><b>pincode</b></td>
<td>$rs[pincode]</td>
</tr>
<td><b>Name of insurance</b></td>
<td>$rs[nameofinc]</td>
</tr>
<tr>
<td><b> Policy Name</b></td>
<td>$rs[Policynm]</td></tr>
<tr>
<td><b> Address</b></td>
<td><textarea name='bloc' rows='4' cols='25' readonly>
$rs[bloc]</textarea></td></tr>
<tr>
";
echo "</td></tr>";
}
?>
</body>
</html>
</table>
</div>
<br>
<br>
<div class='center'>
<br>
<h3 align='center'>Medical Assessment</h3>
<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>
</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>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
<br>
<br>
<div class='center'>
<br>
<h3 align='center'>Allergies</h3>
<br>
<table id="example2" class="table table-bordered table-hover">
<th><strong>Vaccine </strong></th>
<th><strong>Date Given </strong></th>
<th><strong>Due Date</strong></th>
<?php
$sql ="SELECT * FROM allergy WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<tr>
<td>$rs[Allergen]</td>
<td>$rs[Reactiontype]</td>
<td>$rs[Category]</td>
</tr>";
echo "</td></tr>";
}
?>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
<br>
<br>
<div class='center'>
<br>
<h3 align='center'>Immunization</h3>
<br>
<table id="example2" class="table table-bordered table-hover">
<th><strong>Vaccine </strong></th>
<th><strong>Date Given </strong></th>
<th><strong>Due Date</strong></th>
<th><strong>Note </strong></th>
</tr>
</thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM immunization WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[Vaccine]</td>
<td> $rs[DateGiven]</td>
<td> $rs[duedate]</td>
<td> $rs[Note]</td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
<br>
<br>
<div class='center'>
<br>
<h3 align='center'>Regular Medication</h3>
<br>
<table id="example2" class="table table-bordered table-hover">
<th><strong>Drug </strong></th>
<th><strong>Dose in MG</strong></th>
</tr>
</thead>
<?php
$sql1 ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
$qsql1 = mysqli_query($con,$sql1);
while($rp = mysqli_fetch_array($qsql1))
{
$sql ="SELECT * FROM medication WHERE patientid='$rp[patientid]' AND poa='Regular_Medicine' ";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[drug]</td>
<td> $rs[dose]</td>
</tr>
";
}
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>