| Server IP : 162.240.98.243 / Your IP : 18.226.159.181 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['Surgeryprocedurerelatedva'])){
$updated_at=date("Y-m-d");
$created_at=date("F d, Y / h:i:s A");
$CheckPatient = $con->query("SELECT * FROM Surgeryprocedurerelated WHERE prescriptionid = '$_POST[prescriptionid]' AND patientid = '$_POST[patientid]' AND Surgeryprocedurerelated='$_POST[Surgeryprocedurerelated]' AND Surgeryprocedurerelated_Native='$_POST[Surgeryprocedurerelated_Native]' AND Surgeryprocedurerelated_Corrective='$_POST[Surgeryprocedurerelated_Corrective]'");
$numSU=mysqli_num_rows($CheckPatient);
if($numSU > 0){
echo "<script>alert('Already Exists');</script>";
}else{
$Surgery=$con->query("INSERT INTO Surgeryprocedurerelated(id,prescriptionid,patientid,Surgeryprocedurerelated,Surgeryprocedurerelated_Native,Surgeryprocedurerelated_Corrective,entered_by,created_at,updated_at) VALUES (NULL,'$_POST[prescriptionid]','$_POST[patientid]','$_POST[Surgeryprocedurerelated]','$_POST[Surgeryprocedurerelated_Native]','$_POST[Surgeryprocedurerelated_Corrective]','$_POST[entered_by]','$created_at','$updated_at')");
$last_id = mysqli_insert_id($con);
$save_activity=$con->query("INSERT INTO save_activity(srno,userno,prescriptionid,discription,entered_by,link,created_at,updated_at) VALUES (NULL, '$_POST[patientid]','$_POST[prescriptionid]','Incident Report<br>Surgery procedure related','$_POST[entered_by]','showSurgeryprocedurerelated.php?prescriptionid=$_POST[prescriptionid]&patientid=$_POST[patientid]&id=$last_id','$created_at','$updated_at')");
if($Surgery){
echo "<script>alert('Surgery procedure related add successfully..');</script><script>window.history.go(-1)</script>;</script>";
}
}
}
?>
<!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>Surgery procedure related</title>
<body>
<h3><i class="fa fa-angle-right"></i> Surgery procedure related </h3>
<form name="Surgeryprocedurerelatedva" method="post">
<input type='hidden' name='entered_by' value='<?php echo $entered_by; ?>'>
<input type='hidden' name='patientid' value='<?php echo $_GET['patientid']; ?>'>
<input type='hidden' name='prescriptionid' value='<?php echo $_GET['prescriptionid']; ?>'>
<table class='table table-hover table-bordered'>
<tr>
<td> <label for="address">Surgery procedure related</label></td>
<td> <select name="Surgeryprocedurerelated" class='form-control'>
<option value="" disabled selected>Surgery procedure related</option>
<option value="Incorrect site">Incorrect site</option>
<option value="Site not marked">Site not marked </option><option value="Related material or consumable not available">Related material or consumable not available</option>
<option value="Drugs not available">Drugs not available</option>
<option value="Injury to patient during procedure">Injury to patient during procedure</option>
</select>
</td>
</tr>
<tr>
<td> <label>Native description of Occurrence</label></td>
<td> <input type="text" class='form-control' name="Surgeryprocedurerelated_Native" placeholder="Native description of Occurrence"></td>
</tr>
<tr>
<td><label>Corrective And Preventive Action Taken</label></td>
<td> <input type="text" class='form-control' name="Surgeryprocedurerelated_Corrective" placeholder="Corrective And Preventive Action Taken"> </td>
</tr>
<tr>
<td colspan='2'> <button style="float: right;" name="Surgeryprocedurerelatedva" type="submit" class='btn btn-success'> Save</button></td>
</tr>
</table>
</form>