Server IP : 162.240.98.243 / Your IP : 18.224.54.168 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'); 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 prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Examination_type='near'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</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 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>