| Server IP : 162.240.98.243 / Your IP : 18.226.4.191 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();
include("dbconnection.php");
include("header.php");
include("dashboarddocument.php");
if(isset($_POST[add_team]))
{
{
$sql ="INSERT INTO surury_team(teamid,prescriptionid,patientid,team) values(Null,'$_POST[prescriptionid]','$_POST[patientid]','$_POST[team]')";
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
include("dbconnection.php");
if(isset($_GET[delid]))
{
$sql ="DELETE FROM surury_team WHERE teamid='$_GET[delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
?>
<meta name=”viewport” content=”width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;” />
<div class="content-wrapper">
<div class="card-body">
<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>Surgery Team</strong></th>
<th><strong>Action</strong></th>
</tr>
</thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM surury_team WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql1 ="SELECT * FROM site_users WHERE userno='$rs[team]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs1 = mysqli_fetch_array($qsql1))
{
echo " <tbody>
<tr> <td> $rs1[name]</td>
<td><a href='PreOperativeAssessmentSheet.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[teamid]'>Remove</a></td>
</tr>
";
}
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<!DOCTYPE html>
<html>
<head>
<title>Demo Select Box With Search Option Using Jquery - AllPHPTricks.com</title>
<link rel="stylesheet" href="select2.min.css" />
<style>
.select2-dropdown {top: 22px !important; left: 8px !important;}
</style>
</head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<body>
<div class="wrapper col2">
<div id="breadcrumb">
</div>
</div>
<div class="wrapper col4">
<div id="container">
<form method="post" action="" name="add_team" onSubmit="return validateform()">
<table width="532" border="3">
<table id="example2" class="table table-bordered table-hover">
<tbody>
<?php
$sqlpatient= "SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$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>";
}
?>
</tr>
<tr>
<td>Surgery Team</td>
<td><select name="team" id="team" class="form-control">
<option value='' disabled selected>Select Surgery Team</option>
<?php
include("dbconnection.php");
$username = "ventexint@gmail.com";
$apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
$sendername = "EASNUP";
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sqldoctor= "SELECT * FROM site_users WHERE usertype='Doctor' and entered_by='$re[entered_by]' or usertype='Nurse' and entered_by='$re[entered_by]' or usertype='RMO' and entered_by='$re[entered_by]'";
$qsqldoctor = mysqli_query($con,$sqldoctor);
while($rsdoctor = mysqli_fetch_array($qsqldoctor))
{
echo "<option value='$rsdoctor[userno]'>$rsdoctor[name]</option>";
}
}
?>
</select></td>
</tr>
</tr>
</tbody>
</table>
<tr>
<td colspan="2" align="center"><input type="submit" name="add_team" id="add_team" value="ADD" /></td>
</tr>
</form>
</div></div></div>
<script>
$(function () {
$("#example1").DataTable({
"responsive": true,
"autoWidth": false,
});
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
"responsive": true,
});
});
</script>