| Server IP : 162.240.98.243 / Your IP : 3.139.80.209 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/NewNurse/Patient/ |
Upload File : |
<?php
if(isset($_POST['Medical_surgical']))
{
PatientManager::Medicalsurgical("$_GET[prescriptionid]","$_GET[patientid]","$_POST[Information_Obtained_from]","$_POST[specify]","$_POST[relation]","$_POST[Addiction]","$_POST[Alcohol]","$_POST[Smoking]","$_POST[Tobacco]","$_POST[enteredby]");
}
if(isset($_POST['PatientMedication']))
{
$sql ="INSERT INTO medi_condition_final(patientid,medicalcon,Specify,Status) values('$_POST[patientid]','$_POST[medicalcon]','$_POST[Specify]','$_POST[Status]')";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Medication record inserted successfully...');</script>";
echo "<script>window.location='RequestforAdmissionset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]';</script>;";
// echo "</script>";
}
else
{
echo mysqli_error($con);
}
}
if(isset($_POST[Allergies]))
{
$sql ="INSERT INTO allergy(patientid,Allergen,Category,Severity, Reaction,Reactiontype,Reactionstdate) values('$_POST[patientid]','$_POST[Allergen]','$_POST[Category]','$_POST[Severity]','$_POST[Reaction]','$_POST[Reactiontype]','$_POST[Reactionstdate]')";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Allergies Add successfully...');</script><script>
window.history.go(-1)</script>";
}
else
{
echo mysqli_error($con);
}
}
if(isset($_POST[AddImmunization])){
$sql ="INSERT INTO immunization(patientid,Vaccine,DateGiven,duedate,Note) values('$_POST[patientid]','$_POST[Vaccine]','$_POST[DateGiven]','$_POST[duedate]','$_POST[Note]')";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Immunization record inserted successfully...');</script><script> window.history.go(-1)</script>";
}
else
{
echo mysqli_error($con);
}
}
if(isset($_POST[RegularMedication]))
{
$CheckPatient = $con->query("SELECT * FROM `medication` WHERE `patientid` = '$_POST[patientid]' AND `drug` = '$_POST[drug]'");
$numSU=mysqli_num_rows($CheckPatient);
if($numSU > 0){
echo "<script>alert('Already Exists');</script>";
}else{
$medication =$con->query("INSERT INTO medication(patientid,drug,dose,Route,Frequency,duration,prescriptionid,poa) values('$_GET[patientid]','$_POST[drug]','$_POST[dose]','$_POST[Route]','$_POST[Frequency]','$_POST[duration]','$_POST[prescriptionid]','Regular_Medicine')");
if($medication ==1)
{
echo "<script>alert('Regular Medication record inserted successfully...');</script><script> window.history.go(-1)</script>";
}
else
{
echo mysqli_error($con);
}
}
}
if(isset($_GET['Del'])){
// sql to delete a record
$sql = "DELETE FROM medi_condition_final WHERE medicalcoid='$_GET[Del]' ";
if ($con->query($sql) === TRUE) {
echo "<script>alert('Delete successfully...');</script><script>
window.history.go(-1)</script>";
} else {
echo "Error deleting record: " . $con->error;
}
$con->close();
}
if(isset($_GET['DelAllergy'])){
// sql to delete a record
$allergy = "DELETE FROM allergy WHERE allergy_id='$_GET[DelAllergy]' ";
if ($con->query($allergy) === TRUE) {
echo "<script>alert('Allergy Delete successfully...');</script><script>
window.history.go(-1)</script>";
} else {
echo "Error deleting record: " . $con->error;
}
$con->close();
}
if(isset($_GET['Del_Immunization'])){
// sql to delete a record
$immunization = "DELETE FROM immunization WHERE Immuni_id='$_GET[Del_Immunization]' ";
if ($con->query($immunization) === TRUE) {
echo "<script>alert('Immunization Delete successfully...');</script><script>
window.history.go(-1)</script>";
} else {
echo "Error deleting record: " . $con->error;
}
$con->close();
}
?>
<div style='padding:20px;'>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Medical Assessment</strong></th>
<th><strong>Status</strong></th>
<th><strong>Action</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>
<a href='RequestforAdmissionset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&surgeryid=$_GET[surgeryid]&Del=$rs[medicalcoid]'>DELETE</a>
</td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#PatientMedication" style='float:right;'>
Add
</button>
<!-- Modal -->
<div class="modal fade" id="PatientMedication" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle" aria-hidden="true">
<div class="modal-dialog" role="document">
<form method="post" action="" onSubmit="return validateform()"> <div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLongTitle">Patient Medication</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<table id="example2" class="table table-bordered table-hover">
<tbody>
<?php
echo "<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]'></td>";
?>
</tr>
<tr>
<td>Medical Assessment</td>
<td><select name="medicalcon" class='form-control'>
<option value="">Medical Assessment</option>
<option value="Diabetes" selected>Diabetes</option>
<option value="Thyroid">Thyroid</option>
<option value="Cholesterol">Cholesterol</option>
<option value="Physical Injury">Physical Injury</option>
<option value="Heart Condition">Heart Condition</option>
<option value="Anemia">Anemia</option>
<option value="Thalassemia">Thalassemia</option>
<option value="HIV">HIV</option>
<option value="Low Blood Pressure">Low Blood Pressure</option>
<option value="High Blood Pressure">High Blood Pressure</option>
<option value="Hypertension">Hypertension</option>
<option value="Depression">Depression</option>
<option value="Physically challenged">Physically challenged</option>
<option value="Mentally challenged">Mentally challenged</option>
<?php
while($rspi1 = mysqli_fetch_array($patient))
{
$sex=$rspi1['gendor'];
if($sex == 'Female'){
echo"
<option value='PCOD'>PCOD</option>
<option value='Pregnancy'>Pregnancy</option>";
}else
{
echo"";
}
}
?>
}
<option value="Terminally ill">Terminally ill</option>
<option value="Surgery-Treatment">History of Surgery & Treatment</option>
</select>
<br>
<div class='row Surgery-Treatment box'>
<div class='col-sm-6'> <label>Specify</label></div>
<div class='col-sm-6'><input type="text" name="Specify" class='form-control'></div>
</div>
</td>
</tr>
<td>Status</td>
<td><select class="form-control" name="Status">
<option value="" disabled >Status </option>
<option value="Active" selected>Active</option>
<option value="Cured">Cured</option>
</select></td>
</tr>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" name="PatientMedication" class="btn btn-primary">Save changes</button>
</div>
</div>
</form>
</div>
</div>
<br>
</div>
<br>
<div style='padding:20px;'>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Allergies</strong></th>
<th><strong>Category</strong></th>
<th><strong>Action</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='RequestforAdmissionset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&surgeryid=$_GET[surgeryid]&DelAllergy=$ra[allergy_id]'>DELETE</a>
</td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#Allergies" style='float:right;'>
Add
</button>
<!-- Modal -->
<div class="modal fade" id="Allergies" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<form method="post" action="" id="myForm" name="submit" onSubmit="return validateform()">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Add Allergies</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<table id="example2" class="table table-bordered table-hover">
<tbody>
<?php
echo "<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]'></td>";
?>
<tr>
<td height="62">Allergen</td>
<td><input type="text" placeholder="What am i allergies to" name="Allergen" id="Allergen" class='form-control'></td>
</tr>
<tr>
<td height="62">Category</td>
<td><select name="Category" id="Category" class='form-control'>
<option value="" disabled selected>Choose Category </option>
<option value="Drug"> Drug</option>
<option value="Food">Food</option>
<option value="Investigation"> Investigation</option>
<option value="Other"> Other</option>
</select></td>
</tr>
<tr>
<td height="62">Severity</td>
<td><select name="Severity" id="Severity" class='form-control'>
<option value="" disabled selected>Choose Severity </option>
<option value="Mild"> Mild</option>
<option value="Moderate">Moderate</option>
<option value="Severe"> Severe</option>
</select></td> </tr>
<tr>
<td height="62">Reaction</td>
<td><input type="text" placeholder="Description" name="Reaction" id="Reaction" class='form-control'></td>
</tr>
<tr>
<td height="62">Reaction Type</td>
<td><select name="Reactiontype" id="Reactiontype" class='form-control'>
<option value="" disabled selected>Reaction Type </option>
<option value="Allergy"> Allergy</option>
<option value="Advance Effect">Advance Effect</option>
<option value="Unknown"> Unknown</option> </select> </td>
</tr>
<tr>
<td height="62">Reaction Date</td>
<td><input type="date" name="Reactionstdate" id="Reactionstdate" class='form-control'></td>
</tr>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" name="Allergies" class="btn btn-primary">Save </button>
</div>
</div>
</form>
</div>
</div>
</div>
<div style='padding:20px;'>
<br>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Vaccination </strong></th>
<th><strong>Date Given </strong></th>
<th><strong>Note </strong></th>
<th><strong>Action </strong></th>
</tr>
</thead>
<?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[Note]</td>
<td>
<a href='RequestforAdmissionset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&surgeryid=$_GET[surgeryid]&Del_Immunization=$rs[Immuni_id]'>DELETE</a>
</td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#Immunization" style='float:right;margin-bottom:20px;'>
Add
</button>
<!-- Modal -->
<div class="modal fade" id="Immunization" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<form method="post" onSubmit="return validateform()"> <div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Add Immunization</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<table id="example2" class="table table-bordered table-hover">
<tbody>
<?php
echo "<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]'></td>";
?>
<tr>
<td height="62">Vaccine</td>
<td><input type="text" name="Vaccine" id="Vaccine" class='form-control'></td>
</tr>
<tr>
<td height="62">Date Given</td>
<td><input type="date" name="DateGiven" id="DateGiven" class='form-control'></textarea></td>
</tr>
<tr>
<td height="62">Due Date </td>
<td><input type="date" name="duedate" id="duedate" class='form-control'></textarea></td>
</tr>
<td>Note</td>
<td><textarea name="Note" rows="2" cols="50" id="Note" class='form-control'></textarea></td>
</tr>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" name="AddImmunization" class="btn btn-primary">Save </button>
</div>
</div></form>
</div>
</div>
</div>
<!--////////////////////////////////////-->
<div style='padding:20px;'>
<br>
<table id="dynamic-table" class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th><strong>Regular Medication Intake</strong></th>
<th><strong>Dose in MG</strong></th>
</tr>
</thead>
<?php
$patient =$con->query("SELECT * FROM patient WHERE patientid='$_GET[patientid]'");
while($rp = $patient->fetch_array())
{
$medication =$con->query("SELECT * FROM medication WHERE patientid='$rp[patientid]' AND poa='Regular_Medicine'");
while($rs = $medication->fetch_array())
{
echo " <tbody>
<tr> <td> $rs[drug]</td>
<td> $rs[dose]</td>
</tr>
";
}
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#RegularMedication" style='float:right;margin-bottom:20px;'>
Add
</button>
<!-- Modal -->
<div class="modal fade" id="RegularMedication" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<form method="post" onSubmit="return validateform()"> <div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Add Regular Medication</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<table id="dynamic-table" class="table table-striped table-bordered table-hover">
<tbody>
<?php
$sqlpatient= "SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rspatient=mysqli_fetch_array($qsqlpatient))
{
echo "<input type='hidden' name='patientid' id='patientid' value='$rspatient[patientid]'></td>";
}
?>
</tr>
<tr>
<td height="62">Name of Medicine</td>
<td><input type="text" name="drug" class='form-control' required></td>
</tr>
<tr>
<td height="62">Dose (Mg)</td>
<td><input type="text" placeholder="Dose in MG" name="dose" class='form-control' required></td>
</tr>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" name="RegularMedication" class="btn btn-primary">Save </button>
</div>
</div></form>
</div>
</div>
</div>
<!--//////////////////////////////////////-->
<div>
<table class='table table-hover table-bordered'>
<form name="Medical_surgical" method="post" id="MS_Form" >
<tr>
<td><label for="item"> Information Obtained from <span>*</span></label></td>
<td> <select name='Information_Obtained_from' class='form-control' required>
<option value='' disabled selected>Information Obtained from</option>
<option value='Patient'>Patient</option>
<option value='Family-Other'>Family/Other</option>
<option value='Old Chart'>Old Chart</option>
</select></td>
</tr>
<tr class="Family-Other box">
<td ><label>Name</label></td>
<td> <input type="text" Placeholder='Name' name="specify" class='form-control'></td>
</tr>
<tr>
<td >
<label>Relation</label></td >
<td >
<input type="text" Placeholder='Relation' name="relation" class='form-control'>
</td>
</tr>
<?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(Pregnancy==$rs[casetype])
{
?>
<tr>
<td colspan='2'><div class="checkbox" style='padding:20px;'> <input name="Insulin" id="myCheck19" onclick="myFunction19()" type="checkbox" ><span>Insulin dependent diabetes mellitus </span>
</div> </td>
</tr>
<tr>
<td colspan='2'><div id="text19" style="display:none">
<label>Type</label>
<select name='insulin_type' class='form-control'>
<option value='' disabled selected>Type</option>
<option value='Type 1'>Type-1</option>
<option value='Type-2'>Type-2</option>
</select>
</div></td>
</tr>
<tr>
<td><label for="item"> Last menstrual period </label></td>
<td> <input type='date' name='lmp' class='form-control'></td>
</tr>
<?php
}
}
?>
<tr>
<td></td>
<td><div class="checkbox" style='padding:20px;'> <input name="Addiction" id="myCheck11" onclick="myFunction11()" type="checkbox"><span>Addiction </span>
</div></td>
</tr>
<tr>
<td></td> <td >
<div id="text11" style="display:none" >
<div class="" style='padding:20px;'>
<input name="Alcohol" type="checkbox" class="ace ace-switch ace-switch-6"><span class="lbl" ><b style='margin-left:15px;font-size:15px;'>Alcohol</b> </span> </div>
<div class="" style='padding:20px;'><input name="Smoking" type="checkbox" class="ace ace-switch ace-switch-6"><span class="lbl"><b style='margin-left:15px;font-size:15px;'>Smoking</b> </span></div>
<div class="" style='padding:20px;'> <input name="Tobacco" type="checkbox" class="ace ace-switch ace-switch-6"><span class="lbl"><b style='margin-left:15px;font-size:15px;'>Tobacco</b> </span>
</div></div>
</td></tr>
<tr>
<td colspan='2'><input type="submit" name="Medical_surgical" value="Submit" class='btn btn-success'></td>
</tr>
</form>
</table>