| Server IP : 162.240.98.243 / Your IP : 3.133.123.34 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("menu.php");
?>
<html>
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<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>
</head>
<body>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<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 Description</button>
</p>
<br />
<?php
include("dbconnection.php");
$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$_GET[ivid]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo "
<h3>Name of Investigation :<u> $rsn[Investigation]</u></h3>
";
$harilal=$rsn[Method_name];
if($harilal=='')
{
echo"<a href='edit_method.php?ivid=$rsn[ivid]'> Add Method</a>";
}else
{
echo"
<h3>Name of Method : $rsn[Method_name] <a href='edit_method.php?ivid=$rsn[ivid]'> Edit Method</a></h3>
";
}
}
?>
<form method="post" id="user_form">
<div class="table-responsive">
<table class="table table-striped table-bordered" id="user_data">
<tr>
<th>Test Description </th>
<th>Unit </th>
<th> Sex </th>
<th>Age Range </th>
<th>Minimum</th>
<th>Maximum</th>
<th>Action</th>
</tr>
<?php
include("dbconnection.php");
$sqlpatient1 = "SELECT * FROM Test_Description WHERE ivid='$_GET[ivid]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo"
<tr>
<td>$rsn[Test_Description]</td>
<td>$rsn[Unit]</td>
<td>$rsn[Sex]</td>
<td>$rsn[Age_Range]</td>
<td>$rsn[True_Value]</td>
<td>$rsn[True_Value2]</td>
<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><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></td>
</tr>
";
}
?>
</table>
</div>
<div align="center">
<input type="submit" name="insert" id="insert" class="btn btn-success btn-xs" value="Submit" />
</div>
</form>
<br />
</div>
<div id="user_dialog" title="Add Data">
<div class="form-group">
<label>Method</label>
<select class="form-control" id="Parametersid" name="Parametersid">
<option value="NIL">NIL</option>
<?php
$sql1 ="SELECT * FROM method WHERE ivid='$_GET[ivid]'";
$qsql1 = mysqli_query($con,$sql1);
while($re = mysqli_fetch_array($qsql1))
{
echo "<option value='$re[methodid]'>$re[method]</option>";
}
?>
</select>
<?php
$sql1 ="SELECT * FROM method WHERE ivid='$_GET[ivid]'";
echo"
<span id='error_Test_Description' class='text-danger'></span>
<a href='method.php?ivid=$_GET[ivid]'>Add Method</a>
";
?>
</div>
<div class="form-group">
<label>Parameters</label>
<select class="form-control" id="Parametersid" name="Parametersid">
<option value="NIL">NIL</option>
<?php
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM Parameters WHERE ivid='$_GET[ivid]'";
$qsql1 = mysqli_query($con,$sql1);
while($re = mysqli_fetch_array($qsql1))
{
echo "<option value='$re[Parametersid]'>$re[Parameters]</option>";
}
?>
</select>
<?php
$sql1 ="SELECT * FROM Parameters WHERE ivid='$_GET[ivid]'";
echo"
<span id='error_Test_Description' class='text-danger'></span>
<a href='parameters.php?ivid=$_GET[ivid]'>Add Parameters</a>
";
?>
</div>
<div class="form-group">
<label>Test Description</label>
<input type="text" placeholder="Test Description" name="Test_Description" id="Test_Description" class="form-control" />
<span id="error_Test_Description" class="text-danger"></span>
</div>
<div class="form-group">
<label>Unit </label>
<input type="text" placeholder="Unit" name="Unit" id="Unit" class="form-control" />
<span id="error_Unit" class="text-danger"></span>
</div>
<div class="form-group">
<label>Sex </label>
<select class="form-control" id="Sex" name="Sex">
<option value="" disabled selected>Sex </option>
<option value="Not_applicable">Not applicable </option>
<option value="Male">Male</option>
<option value="Female">Female</option>
</select>
<span id="error_Sex" class="text-danger"></span>
</div>
<div class="form-group">
<label> Age Range </label>
<select class="form-control" name="Age_Range" id="Age_Range" class="form-control">
<option value="" disabled selected>Age Range </option>
<option value="Not_Applicable">Not Applicable </option>
<option value="Newborn">Newborn</option>
<option value="Child">Child</option>
<option value="Adult">Adult</option>
<option value="Senior_Citizen">Senior Citizen </option>
</select>
<span id="error_Age_Range" class="text-danger"></span>
</div>
<div class="form-group">
<label> Minimum Value</label>
<input type="text" placeholder="Minimum Value" name="True_Value" id="True_Value" class="form-control" />
<span id="error_True_Value" class="text-danger"></span>
</div>
<div class="form-group">
<label>Maximum Value</label>
<input type="text" placeholder="Maximum Value" name="True_Value2" id="True_Value2" class="form-control" />
<span id="error_True_Value2" class="text-danger"></span>
</div>
<div class="form-group">
<input type="hidden" placeholder="Name" name="ivid" id="ivid" 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">
</div>
</body>
</html>
<script>
$(document).ready(function(){
var count = 0;
$('#user_dialog').dialog({
autoOpen:false,
width:350
});
$('#add').click(function(){
$('#user_dialog').dialog('option', 'title', 'Investigation Description');
$('#Test_Description').val('');
$('#Unit').val('');
$('#Sex').val('');
$('#Age_Range').val('');
$('#True_Value').val('');
$('#True_Value2').val('');
$('#error_Test_Description').text('');
$('#error_Unit').text('');
$('#error_Sex').text('');
$('#error_Age_Range').text('');
$('#error_True_Value').text('');
$('#error_True_Value2').text('');
$('#Test_Description').css('border-color', '');
$('#Unit').css('border-color', '');
$('#Sex').css('border-color', '');
$('#Age_Range').css('border-color', '');
$('#True_Value').css('border-color', '');
$('#True_Value2').css('border-color', '');
$('#save').text('Save');
$('#user_dialog').dialog('open');
});
$('#save').click(function(){
var error_Test_Description = '';
var error_Unit = '';
var error_Sex = '';
var error_Age_Range= '';
var error_True_Value = '';
var error_True_Value2 = '';
var Test_Description = '';
var Unit = '';
var Sex = '';
var Age_Range= '';
var True_Value = '';
var True_Value2 = '';
if($('#Test_Description').val() == '')
{
error_Test_Description = 'Test_Description is required';
$('#error_Test_Description').text(error_Test_Description);
$('#Test_Description').css('border-color', '#cc0000');
Test_Description = '';
}
else
{
error_Test_Description = '';
$('#error_Test_Description').text(error_Test_Description);
$('#Test_Description').css('border-color', '');
Test_Description = $('#Test_Description').val();
}
if($('#Unit').val() == '')
{
error_Unit = 'Unit is required';
$('#error_Unit').text(error_Unit);
$('#Unit').css('border-color', '#cc0000');
Unit = '';
}
else
{
error_Unit = '';
$('#error_Unit').text(error_Unit);
$('#Unit').css('border-color', '');
Unit = $('#Unit').val();
}
if($('#Sex').val() == '')
{
error_Sex = 'Sex is required';
$('#Sex').text(error_Sex);
$('#Sex').css('border-color', '#cc0000');
Sex = '';
}
else
{
error_Sex = '';
$('#error_Sex').text(error_Sex);
$('#Sex').css('border-color', '');
Sex = $('#Sex').val();
}
if($('#Age_Range').val() == '')
{
error_Age_Range = 'Age_Range is required';
$('#error_Age_Range').text(error_Age_Range);
$('#Age_Range').css('border-color', '#cc0000');
Age_Range= '';
}
else
{
error_Age_Range = '';
$('#error_Age_Range').text(error_Age_Range);
$('#Age_Range').css('border-color', '');
Age_Range = $('#Age_Range').val();
}
if($('#True_Value').val() == '')
{
error_True_Value = 'True_Value is required';
$('#error_True_Value').text(error_True_Value);
$('#True_Value').css('border-color', '#cc0000');
True_Value = '';
}
else
{
error_True_Value = '';
$('#error_True_Value').text(error_True_Value);
$('#True_Value').css('border-color', '');
True_Value = $('#True_Value').val();
}
if($('#True_Value2').val() == '')
{
error_True_Value2 = 'True_Value2 is required';
$('#error_True_Value2').text(error_True_Value2);
$('#True_Value2').css('border-color', '#cc0000');
True_Value2 = '';
}
else
{
error_True_Value2 = '';
$('#error_True_Value2').text(error_True_Value2);
$('#True_Value2').css('border-color', '');
True_Value2 = $('#True_Value2').val();
}
if(error_Test_Description != '' || error_Unit != ''|| error_Sex != ''|| error_Age_Range != ''|| error_True_Value != ''|| error_True_Value2 != '')
{
return false;
}
else
{
if($('#save').text() == 'Save')
{
count = count + 1;
output = '<tr id="row_'+count+'">';
output += '<td>'+Test_Description+' <input type="hidden" name="hidden_Test_Description[]" id="Test_Description'+count+'" class="Test_Description" value="'+Test_Description+'" /></td>';
output += '<td>'+Unit+' <input type="hidden" name="hidden_Unit[]" id="Unit'+count+'" value="'+Unit+'" /></td>';
output += '<td>'+Sex+' <input type="hidden" name="hidden_Sex[]" id="Sex'+count+'" value="'+Sex+'" /></td>';
output += '<td>'+Age_Range+' <input type="hidden" name="hidden_Age_Range[]" id="Age_Range'+count+'" value="'+Age_Range+'" /></td>';
output += '<td>'+True_Value+' <input type="hidden" name="hidden_True_Value[]" id="True_Value'+count+'" value="'+True_Value+'" /></td>';
output += '<td>'+True_Value2+' <input type="hidden" name="hidden_True_Value2[]" id="True_Value2'+count+'" value="'+True_Value2+'" /></td>';
output += ''+ivid+' <input type="hidden" name="hidden_ivid[]" id="ivid'+count+'" value="<?php echo"$_GET[ivid]" ?>" />';
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>'+Test_Description+' <input type="hidden" name="hidden_Test_Description[]" id="Test_Description'+row_id+'" class="Test_Description" value="'+Test_Description+'" /></td>';
output += '<td>'+Unit+' <input type="hidden" name="hidden_Unit[]" id="Unit'+row_id+'" value="'+Unit+'" /></td>';
output += '<td>'+Sex+' <input type="hidden" name="hidden_Sex[]" id="Sex'+row_id+'" value="'+Sex+'" /></td>';
output += '<td>'+Age_Range+' <input type="hidden" name="hidden_Age_Range[]" id="Age_Range'+row_id+'" value="'+Age_Range+'" /></td>';
output += '<td>'+True_Value+' <input type="hidden" name="hidden_True_Value[]" id="True_Value'+row_id+'" value="'+True_Value+'" /></td>';
output += '<td>'+True_Value2+' <input type="hidden" name="hidden_True_Value2[]" id="True_Value2'+row_id+'" value="'+True_Value2+'" /></td>';
output += ''+ivid+' <input type="hidden" name="hidden_ivid[]" id="ivid'+row_id+'" value="<?php echo"varanayuy" ?>" />';
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 Test_Description = $('#Test_Description'+row_id+'').val();
var Unit = $('#Unit'+row_id+'').val();
var Sex = $('#Sex'+row_id+'').val();
var Age_Range = $('#Age_Range'+row_id+'').val();
var True_Value = $('#True_Value'+row_id+'').val();
var True_Value2 = $('#True_Value2'+row_id+'').val();
$('#Test_Description').val(Test_Description);
$('#Unit').val(Unit);
$('#Sex').val(Sex);
$('#Age_Range').val(Age_Range);
$('#True_Value').val(True_Value);
$('#True_Value2').val(True_Value2);
$('#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;
$('.Test_Description').each(function(){
count_data = count_data + 1;
});
if(count_data > 0)
{
var form_data = $(this).serialize();
$.ajax({
url:"meditest2.php",
method:"POST",
data:form_data,
success:function(data)
{
$('#user_data').find("tr:gt(0)").remove();
$('#action_alert').html('<p>Investigation Description Inserted Successfully</p>');
$('#action_alert').dialog('open');
window.location.href = "listiv.php";
}
})
}
else
{
$('#action_alert').html('<p>Please Add atleast one data</p>');
$('#action_alert').dialog('open');
}
});
});
</script>