| Server IP : 162.240.98.243 / Your IP : 18.191.234.150 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");
require_once('../DBManager.php');
require_once("../LoginManager.php");
require_once('../patientmanager.php');
?>
<html>
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://www.jqueryscript.net/demo/Dialog-Modal-Dialogify/dist/dialogify.min.js"></script>
<title>PHP - Sending multiple forms data through jQuery Ajax</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />
</head>
<body>
<p align="right">
<button type="button" name="add" id="add" class="btn btn-success btn-xs"><i class="fa fa-plus" aria-hidden="true"></i>Add Investigation</button>
</p>
<br />
<form method="post" id="user_form">
<div class="table-responsive">
<table id="user_data" class="table table-bordered table-striped">
<tr>
<td><b>Date Time</b></td>
<td><b>Investigation</b></td>
<td><b>Result</b></td>
<td><b>Evidence</b></td>
<td><b>Action</b></td>
</tr>
<?php
$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[created_at]</td>
<td> ";
if (is_numeric($rs[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs[Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs[Sub_Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[bodypart]";
}
if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs[Investigation]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[Investigation]";
}
$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs[ivid]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo"
$rsn[Investigation]"; }
echo"</b></td>
<td> $rs[Result]</td>
<td> $rs[Evidence]</td>
<td><a href='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]'>Delete</a></td>
</tr>
";
}
?>
</tbody>
</table>
</div>
<div align="center">
<input type="submit" name="insert" id="insert" class="btn btn-success btn-xs" value="Submit" />
</div>
</form>
<div id="user_dialog" title="Add Data">
<div class="form-group">
<input type="hidden" name="prescriptionid" id="prescriptionid" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="patientid" id="patientid" class="form-control" />
</div>
<div class="form-group">
<label>Investigation Type </label>
<select onchange="ivtype(this.value)" class="form-control" name="Category">
<option value="" selected="selected">Select Investigation Type</option>
<option value="44">Radiology</option>
<option value="45">Pathology</option>
</select>
</div>
<p id='divmedidr'>
</p>
<p id='divdr'>
</p>
<div class="form-group">
<label>Priority slip</label>
<select onchange='ivload(this.value)' name="Priority_slip" class="form-control">
<option value="">Priority slip </option>
<option value="11">Urgent </option>
<option value="Normal">Normal </option>
<span id="error_Priority_slip" class="text-danger"></span>
</div>
<div class="form-group">
<input type="hidden" name="poa" id="poa" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="status" id="status" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="Action_med" id="Action_med" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="availability" id="availability" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="batchno" id="batchno" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="entered_by" id="entered_by" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="created_at" id="created_at" class="form-control" />
</div>
<div class="form-group">
<input type="hidden" name="updated_at" id="updated_at" class="form-control" />
</div>
<div class="form-group" align="center">
<input type="hidden" name="row_id" id="hidden_row_id" />
<button type="button" name="save" id="save" class="btn btn-info">Save</button>
</div>
</div>
<div id="action_alert" title="Action">
</p></div>
</body>
</html>
<script>
function ivload(drid)
{
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("divdr").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadiv.php?drid="+drid,true);
xmlhttp.send();
}
</script>
<script>
$(document).ready(function(){
var count = 0;
$('#user_dialog').dialog({
autoOpen:false,
width:340
});
$('#add').click(function(){
$('#user_dialog').dialog('option', 'title', 'Add Medication');
$('#DRUGS').val('');
$('#error_DRUGS').text('');
$('#Dose').val('');
$('#error_Dose').text('');
$('#Route').val('');
$('#error_Route').text('');
$('#Frequency').val('');
$('#error_Frequency').text('');
$('#duration').val('');
$('#error_duration').text('');
$('#DRUGS').css('border-color', '');
$('#Dose').css('border-color', '');
$('#Route').css('border-color', '');
$('#Frequency').css('border-color', '');
$('#duration').css('border-color', '');
$('#save').text('Save');
$('#user_dialog').dialog('open');
});
$('#save').click(function(){
var error_DRUGS = '';
var DRUGS = '';
if($('#DRUGS').val() == '')
{
error_DRUGS = 'DRUGS is required';
$('#error_DRUGS').text(error_DRUGS);
$('#DRUGS').css('border-color', '#cc0000');
DRUGS = '';
}
else
{
error_DRUGS = '';
$('#error_DRUGS').text(error_DRUGS);
$('#DRUGS').css('border-color', '');
DRUGS = $('#DRUGS').val();
}
if(error_DRUGS != '')
{
return false;
}
var error_Dose = '';
var Dose = '';
if($('#Dose').val() == '')
{
error_Dose= 'Dose is required';
$('#error_Dose').text(error_Dose);
$('#Dose').css('border-color', '#cc0000');
Dose = '';
}
else
{
error_Dose = '';
$('#error_Dose').text(error_Dose);
$('#Dose').css('border-color', '');
Dose = $('#Dose').val();
}
if(error_Dose != '')
{
return false;
}
var error_Route = '';
var Route = '';
if($('#Route').val() == '')
{
error_Dose= 'Route is required';
$('#error_Route').text(error_Dose);
$('#Route').css('border-color', '#cc0000');
Route = '';
}
else
{
error_Route = '';
$('#error_Route').text(error_Route);
$('#Route').css('border-color', '');
Route = $('#Route').val();
}
if(error_Route != '')
{
return false;
}
var error_Frequency = '';
var Frequency = '';
if($('#Frequency').val() == '')
{
error_Frequency= 'Frequency is required';
$('#error_Frequency').text(error_Dose);
$('#Frequency').css('border-color', '#cc0000');
Frequency = '';
}
else
{
error_Frequency = '';
$('#error_Frequency').text(error_Frequency);
$('#Frequency').css('border-color', '');
Frequency = $('#Frequency').val();
}
if(error_Frequency != '')
{
return false;
}
var error_duration = '';
var duration = '';
if($('#duration').val() == '')
{
error_duration= 'duration is required';
$('#error_duration').text(error_Dose);
$('#duration').css('border-color', '#cc0000');
duration = '';
}
else
{
error_duration = '';
$('#error_duration').text(error_duration);
$('#duration').css('border-color', '');
duration = $('#duration').val();
}
if(error_duration != '')
{
return false;
}
else
{
if($('#save').text() == 'Save')
{
count = count + 1;
output = '<tr id="row_'+count+'">';
output += '<td>'+DRUGS+' <input type="hidden" name="hidden_DRUGS[]" id="DRUGS'+count+'" class="DRUGS" value="'+DRUGS+'" /></td>';
output += '<td>'+Dose+' <input type="hidden" name="hidden_Dose[]" id="Dose'+count+'" class="Dose" value="'+Dose+'" /></td>';
output += '<td>'+Route+' <input type="hidden" name="hidden_Route[]" id="Route'+count+'" class="Route" value="'+Route+'" /></td>';
output += '<td>'+Frequency+' <input type="hidden" name="hidden_Frequency[]" id="Frequency'+count+'" class="Frequency" value="'+Frequency+'" /></td>';
output += '<td>'+duration+' <input type="hidden" name="hidden_duration[]" id="duration'+count+'" class="duration" value="'+duration+'" /></td>';
output += ''+prescriptionid+' <input type="hidden" name="hidden_prescriptionid[]" id="prescriptionid'+count+'" value="<?php echo"$_GET[prescriptionid]" ?>" />';
output += ''+patientid+' <input type="hidden" name="hidden_patientid[]" id="patientid'+count+'" value="<?php echo"$_GET[patientid]" ?>" />';
output += ''+poa+' <input type="hidden" name="hidden_poa[]" id="poa'+count+'" value="Opd_Medicine" />';
output += ''+status+' <input type="hidden" name="hidden_status[]" id="status'+count+'" value="Active" />';
output += ''+Action_med+' <input type="hidden" name="hidden_Action_med[]" id="Action_med'+count+'" value="Action_med" />';
output += ''+availability+' <input type="hidden" name="hidden_availability[]" id="availability'+count+'" value="availability" />';
output += ''+batchno+' <input type="hidden" name="hidden_batchno[]" id="batchno'+count+'" value="askjdkjsd"/>';
output += ''+entered_by+' <input type="hidden" name="hidden_entered_by[]" id="entered_by'+count+'" value="entered_by"/>';
output += ''+created_at+' <input type="hidden" name="hidden_created_at[]" id="created_at'+count+'" value="created_at"/>';
output += ''+updated_at+' <input type="hidden" name="hidden_updated_at[]" id="updated_at'+count+'" value="updated_at"/>';
output += '<td><button type="button" name="view_details" class="btn btn-warning btn-xs view_details" id="'+count+'"><i class="fa fa-edit" aria-hidden="true"></i></button>';
output += '<button type="button" name="remove_details" class="btn btn-danger btn-xs remove_details" id="'+count+'"><i class="fa fa-trash" aria-hidden="true"></i></button></td>';
output += '</tr>';
$('#user_data').append(output);
}
else
{
var row_id = $('#hidden_row_id').val();
output = '<td>'+DRUGS+' <input type="hidden" name="hidden_DRUGS[]" id="DRUGS'+row_id+'" class="DRUGS" value="'+DRUGS+'" /></td>';
output = '<td>'+Dose+' <input type="hidden" name="hidden_Dose[]" id="Dose'+row_id+'" class="Dose" value="'+Dose+'" /></td>';
output = '<td>'+Route+' <input type="hidden" name="hidden_Route[]" id="Route'+row_id+'" class="Route" value="'+Route+'" /></td>';
output = '<td>'+Frequency+' <input type="hidden" name="hidden_Frequency[]" id="Frequency'+row_id+'" class="Frequency" value="'+Frequency+'" /></td>';
output = '<td>'+duration+' <input type="hidden" name="hidden_duration[]" id="duration'+row_id+'" class="duration" value="'+duration+'" /></td>';
output += ''+prescriptionid+' <input type="hidden" name="hidden_prescriptionid[]" id="prescriptionid'+row_id+'" value="<?php echo"varanayuy" ?>" />';
output += ''+patientid+' <input type="hidden" name="hidden_patientid[]" id="patientid'+row_id+'" value="<?php echo"varanayuy" ?>" />';
output += ''+poa+' <input type="hidden" name="hidden_poa[]" id="poa'+row_id+'" value="Opd_Medicine" />';
output += ''+status+' <input type="hidden" name="hidden_status[]" id="status'+row_id+'" value="Active" />';
output += ''+Action_med+' <input type="hidden" name="hidden_Action_med[]" id="Action_med'+row_id+'" value="Action_med" />';
output += ''+availability+' <input type="hidden" name="hidden_availability[]" id="availability'+row_id+'" value="Active" />';
output += ''+batchno+' <input type="hidden" name="hidden_batchno[]" id="batchno'+row_id+'" value="Active" />';
output += ''+entered_by+' <input type="hidden" name="hidden_entered_by[]" id="entered_by'+row_id+'" value="entered_by" />';
output += ''+created_at+' <input type="hidden" name="hidden_created_at[]" id="created_at'+row_id+'" value="created_at" />';
output += ''+updated_at+' <input type="hidden" name="hidden_updated_at[]" id="updated_at'+row_id+'" value="updated_at" />';
output += '<td><button type="button" name="view_details" class="btn btn-warning btn-xs view_details" id="'+row_id+'"><i class="fa fa-edit" aria-hidden="true"></i></button>';
output += '<button type="button" name="remove_details" class="btn btn-danger btn-xs remove_details" id="'+row_id+'"><i class="fa fa-trash" aria-hidden="true"></i></button></td>';
$('#row_'+row_id+'').html(output);
}
$('#user_dialog').dialog('close');
}
});
$(document).on('click', '.view_details', function(){
var row_id = $(this).attr("id");
var DRUGS = $('#DRUGS'+row_id+'').val();
$('#DRUGS').val(DRUGS);
var Dose = $('#Dose'+row_id+'').val();
$('#Dose').val(Dose);
var Route = $('#Route'+row_id+'').val();
$('#Route').val(Route);
var Frequency = $('#Frequency'+row_id+'').val();
$('#Frequency').val(Frequency);
var duration = $('#duration'+row_id+'').val();
$('#duration').val(duration);
$('#save').text('Edit');
$('#hidden_row_id').val(row_id);
$('#user_dialog').dialog('option', 'title', 'Edit Data');
$('#user_dialog').dialog('open');
});
$(document).on('click', '.remove_details', function(){
var row_id = $(this).attr("id");
if(confirm("Are you sure you want to remove this row data?"))
{
$('#row_'+row_id+'').remove();
}
else
{
return false;
}
});
$('#action_alert').dialog({
autoOpen:false
});
$('#user_form').on('submit', function(event){
event.preventDefault();
var count_data = 0;
$('.DRUGS').each(function(){
count_data = count_data + 1;
});
if(count_data > 0)
{
var form_data = $(this).serialize();
$.ajax({
url:"testmedipavan2.php",
method:"POST",
data:form_data,
success:function(data)
{
$('#user_data').find("tr:gt(0)").remove();
$('#action_alert').html('<p>DRUGS Inserted Successfully</p>');
$('#action_alert').dialog('open');
window.location.href = "opdset.php?prescriptionid=<?php echo "$_GET[prescriptionid]"?>&patientid=<?php echo "$_GET[patientid]" ?>";
}
})
}
else
{
$('#action_alert').html('<p>Please Add atleast one data</p>');
$('#action_alert').dialog('open');
}
});
});
</script>
<script>
function ivtype(ivtypeid)
{
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("divmedidr").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadivtype.php?ivtypeid="+ivtypeid,true);
xmlhttp.send();
}
</script>