| Server IP : 162.240.98.243 / Your IP : 3.137.213.94 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/www/login.easenup.in/ |
Upload File : |
<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once("../LoginManager.php");
require_once('../patientmanager.php');
include 'header.php';
include 'dashboarddocument.php';
if(isset($_POST[near]))
{
$sql ="UPDATE Glass_Advices SET SPH='$_POST[SPH]',SPH_right='$_POST[SPH_right]',SPH_left='$_POST[SPH_left]',CYL='$_POST[CYL]',CYL_right='$_POST[CYL_right]',CYL_left='$_POST[CYL_left]',AXIS='$_POST[AXIS]',AXIS_right='$_POST[AXIS_right]',AXIS_left='$_POST[AXIS_left]',VISION='$_POST[VISION]',VISION_right='$_POST[VISION_right]',VISION_left='$_POST[VISION_left]' WHERE id='$_GET[id]' AND Examination_type='near'";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Update successfully');</script><script>window.location.href = 'Glass_Advices_near.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&occuid=$_GET[occuid]'</script>
</script>";
}else {
echo "Sorry, there was an error uploading your file.";
}
}
?>
<style>
.box{
display: none;
}
.box1{
display: none;
}
.center {
border: 1px solid grey;
text-align:;
}
</style>
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box").hide();
}
});
}).change();
});
</script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box1").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box1").hide();
}
});
}).change();
});
</script>
</head>
<body>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<div class='center'>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th>Glass Advices Near</th>
<th>Right Eye</th>
<th>Left Eye</th>
</tr>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM Glass_Advices WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'AND occuid='$_GET[occuid]' AND Examination_type='near'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
?>
</thead>
</tbody>
</table>
<br>
<form name="near" method="post">
<table id="example2" class="table table-bordered table-hover">
<tr><td><select class="form-control" name="SPH">
<option value="SPH (DIOPTRE)"> SPH (DIOPTRE)</option>
</select></td><td>
<input name='SPH_right' type='text' list='SPH_right' value=<?php echo $rs['SPH_right'] ?>>
<datalist name='SPH_right' id='SPH_right'>
<option value="+0.75" <?php echo ($rs[SPH_right]=="+0.75")? "selected":"" ?>>+0.75</option>
<option value="+0.50" <?php echo ($rs[SPH_right]=="+0.50")? "selected":"" ?>> +0.50</option>
<option value="+0.25" <?php echo ($rs[SPH_right]=="+0.25")? "selected":"" ?>>+0.25</option>
<option value="+1.00" <?php echo ($rs[SPH_right]=="+1.00")? "selected":"" ?>>+1.00</option>
<option value="-1.25" <?php echo ($rs[SPH_right]=="-1.25")? "selected":"" ?>>-1.25</option>
<option value="+1.50" <?php echo ($rs[SPH_right]=="+1.50")? "selected":"" ?>>-1.50</option>
<option value="+1.75" <?php echo ($rs[SPH_right]=="+1.75")? "selected":"" ?>>-1.75</option>
</datalist> </td>
<td><input name='SPH_left' type='text' list='SPH_left' value="<?php echo $rs[SPH_left] ?>">
<datalist name='SPH_left' id='SPH_left'>
<option value="+0.75" <?php echo ($rs[SPH_right]=="+0.75")? "selected":"" ?>>+0.75</option>
<option value="+0.50" <?php echo ($rs[SPH_right]=="+0.50")? "selected":"" ?>> +0.50</option>
<option value="+0.25" <?php echo ($rs[SPH_right]=="+0.25")? "selected":"" ?>>+0.25</option>
<option value="+1.00" <?php echo ($rs[SPH_right]=="+1.00")? "selected":"" ?>>+1.00</option>
<option value="-1.25" <?php echo ($rs[SPH_right]=="-1.25")? "selected":"" ?>>-1.25</option>
<option value="+1.50" <?php echo ($rs[SPH_right]=="+1.50")? "selected":"" ?>>-1.50</option>
<option value="+1.75" <?php echo ($rs[SPH_right]=="+1.75")? "selected":"" ?>>-1.75</option>
</datalist></td></tr>
<tr><td>
<select class="form-control" name="CYL" id="Examination">
<option value="CYL (DIOPTRE)"> CYL (DIOPTRE)</option>
</select></td>
<td><input name='CYL_right' type='text' list='CYL_right' value="<?php echo $rs[CYL_right] ?>">
<datalist name='CYL_right' id='CYL_right'>
<option value="+0.75" <?php echo ($rs[CYL_right]=="+0.75")? "selected":"" ?>>+0.75</option>
<option value="+0.50" <?php echo ($rs[CYL_right]=="+0.50")? "selected":"" ?>> +0.50</option>
<option value="+0.25" <?php echo ($rs[CYL_right]=="+0.25")? "selected":"" ?>>+0.25</option>
<option value="+1.00" <?php echo ($rs[CYL_right]=="+1.00")? "selected":"" ?>>+1.00</option>
<option value="-1.25" <?php echo ($rs[CYL_right]=="-1.25")? "selected":"" ?>>-1.25</option>
<option value="-1.50" <?php echo ($rs[CYL_right]=="-1.50")? "selected":"" ?>>-1.50</option>
<option value="-1.75" <?php echo ($rs[CYL_right]=="-1.75")? "selected":"" ?>>-1.75</option>
</datalist></td>
<td><input name='CYL_left' type='text' list='CYL_left' value="<?php echo $rs[CYL_left] ?>">
<datalist name='CYL_left' id='CYL_left'>
<option value="+0.75" <?php echo ($rs[CYL_right]=="+0.75")? "selected":"" ?>>+0.75</option>
<option value="+0.50" <?php echo ($rs[CYL_right]=="+0.50")? "selected":"" ?>> +0.50</option>
<option value="+0.25" <?php echo ($rs[CYL_right]=="+0.25")? "selected":"" ?>>+0.25</option>
<option value="+1.00" <?php echo ($rs[CYL_right]=="+1.00")? "selected":"" ?>>+1.00</option>
<option value="-1.25" <?php echo ($rs[CYL_right]=="-1.25")? "selected":"" ?>>-1.25</option>
<option value="-1.50" <?php echo ($rs[CYL_right]=="-1.50")? "selected":"" ?>>-1.50</option>
<option value="-1.75" <?php echo ($rs[CYL_right]=="-1.75")? "selected":"" ?>>-1.75</option>
</datalist></td></tr>
<tr><td><select class="form-control" name="AXIS" id="Examination">
<option value="AXIS(0-180*)"> AXIS(0-180*)</option>
</select></td>
<td> <input name='AXIS_right' type='text' list='AXIS_right' value="<?php echo $rs[AXIS_right] ?>"> <datalist name='AXIS_right' id='AXIS_right'>
<option value="60" <?php echo ($rs[AXIS_right]=="60")? "selected":"" ?>>60</option>
<option value="70" <?php echo ($rs[AXIS_right]=="70")? "selected":"" ?>>70</option>
<option value="80" <?php echo ($rs[AXIS_right]=="80")? "selected":"" ?>>80</option>
<option value="90" <?php echo ($rs[AXIS_right]=="90")? "selected":"" ?>>90</option>
</datalist></td>
<td><input name='AXIS_left' type='text' list='AXIS_left' value="<?php echo $rs[AXIS_left] ?>">
<datalist name='AXIS_left' id='AXIS_left'>
<option value="60" <?php echo ($rs[AXIS_left]=="60")? "selected":"" ?>>60</option>
<option value="70" <?php echo ($rs[AXIS_left]=="70")? "selected":"" ?>>70</option>
<option value="80" <?php echo ($rs[AXIS_left]=="80")? "selected":"" ?>>80</option>
<option value="90" <?php echo ($rs[AXIS_left]=="90")? "selected":"" ?>>90</option>
</datalist></td></tr>
<tr><td><select class="form-control" name="VISION" id="Examination">
<option value="VISION"> VISION</option>
</select></td><td><input name='VISION_right' type='text' list='VISION_right' value="<?php echo $rs[VISION_right] ?>">
<datalist name='VISION_right' id='VISION_right'>
<option value='<?php echo $rs[VISION_right] ?>'> <?php echo $rs[VISION_right] ?></option>
<option value='6/6' <?php echo ($rs[VISION_right]=='6/6')?'selected':'' ?>> 6/6</option>
<option value='6/9' <?php echo ($rs[VISION_right]=='6/9')?'selected':''?>> 6/9</option>
<option value='6/12' <?php echo ($rs[VISION_right]=='6/12')?'selected':''?>> 6/12</option>
<option value='6/18' <?php echo ($rs[VISION_right]=='6/18')?'selected':''?>> 6/18</option>
<option value='6/24' <?php echo ($rs[VISION_right]=='6/24')?'selected':''?>> 6/24</option>
<option value='6/36' <?php echo ($rs[VISION_right]=='6/36')?'selected':''?>> 6/36</option>
<option value='6/60' <?php echo ($rs[VISION_right]=='6/60')?'selected':''?>> 6/60</option>
<option value='FC' <?php echo ($rs[VISION_right]=='FC')?'selected':''?>> FC</option>
<option value='HM' <?php echo ($rs[VISION_right]=='HM')?'selected':''?>> HM</option>
<option value='PL+' <?php echo ($rs[VISION_right]=='PL+')?'selected':''?>> PL+</option>
<option value='PL-' <?php echo ($rs[VISION_right]=='PL-')?'selected':''?>> PL-</option>
</datalist></td><td><input name='VISION_left' type='text' list='VISION_left' value="<?php echo $rs[VISION_left] ?>">
<datalist name='VISION_left' id='VISION_left'>
<option value='<?php echo $rs[VISION_left] ?>'> <?php echo $rs[VISION_left] ?></option>
<option value='6/6' <?php echo ($rs[VISION_left]=='6/6')?'selected':'' ?>> 6/6</option>
<option value='6/9' <?php echo ($rs[VISION_left]=='6/9')?'selected':''?>> 6/9</option>
<option value='6/12' <?php echo ($rs[VISION_left]=='6/12')?'selected':''?>> 6/12</option>
<option value='6/18' <?php echo ($rs[VISION_left]=='6/18')?'selected':''?>> 6/18</option>
<option value='6/24' <?php echo ($rs[VISION_left]=='6/24')?'selected':''?>> 6/24</option>
<option value='6/36' <?php echo ($rs[VISION_left]=='6/36')?'selected':''?>> 6/36</option>
<option value='6/60' <?php echo ($rs[VISION_left]=='6/60')?'selected':''?>> 6/60</option>
<option value='FC' <?php echo ($rs[VISION_left]=='FC')?'selected':''?>> FC</option>
<option value='HM' <?php echo ($rs[VISION_left]=='HM')?'selected':''?>> HM</option>
<option value='PL+' <?php echo ($rs[VISION_left]=='PL+')?'selected':''?>> PL+</option>
<option value='PL-' <?php echo ($rs[VISION_left]=='PL-')?'selected':''?>> PL-</option>
</datalist></td></tr>
<?php } ?>
</table>
<input type="submit" value="Update" name="near">
</form>
</div>
</body>
</html>