Server IP : 162.240.98.243 / Your IP : 3.128.200.71 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(); require_once('../DBManager.php'); require_once('../LoginManager.php'); require_once('../patientmanager.php'); include 'workdeskmenu.php'; include 'header.php'; include("dbconnection.php"); if(isset($_POST[signup])) { PatientManager::frequencyiv("$_POST[type]","$_POST[typeid]","$_POST[frq]","$_POST[route]","$_POST[duration]","$_POST[potential]","$_POST[adminid]","$_GET[drid]","$_GET[surgeryid]","$_POST[entered_by]"); } ?> <?php include("dbconnection.php"); if(isset($_GET[delid])) { $sql ="DELETE FROM frequency WHERE surgeryid='$_GET[delid]'"; $qsql=mysqli_query($con,$sql); if(mysqli_affected_rows($con) == 1) { echo "<script>alert('Deleted successfully..');</script><script>window.location='frqsurgeryadd.php?drid=$_GET[drid]&surgeryid=$rh12[surgeryid]'</script>;"; } } ?> <style> /* Automatic Serial Number Row */ .css-serial { counter-reset: serial-number; /* Set the serial number counter to 0 */ } .css-serial td:first-child:before { counter-increment: serial-number; /* Increment the serial number counter */ content: counter(serial-number); /* Display the counter */ } </style> <form name='signup' method='post'> < <div class='content-wrapper'> <!-- Content Header (Page header) --> <section class='content-header'> <div class='center'> <table id='example2' width='100%' class='table table-bordered table-hover'> <?php include("dbconnection.php"); $username = "ventexint@gmail.com"; $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9"; $sendername = "EASNUP"; $narayan=LoginManager::currentUser(); $hari=LoginManager::getUserTypeByuname("$narayan"); $sql ="SELECT * FROM site_users WHERE userno='$hari'"; $qsql = mysqli_query($con,$sql); if($re = mysqli_fetch_array($qsql)) { $sql ="SELECT * FROM admin WHERE id='$re[entered_by]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo" <input type='hidden' name='adminid' value='$rs[id]'> <input type='hidden' name='entered_by' value='$hari'> <input type='hidden' name='type' value='inv'> "; } } ?> <tr> <td width='50%'> Investigation Name: </td> <td width='50%'><select name='typeid' required> <?php session_start(); include("dbconnection.php"); require_once('../DBManager.php'); require_once('../LoginManager.php'); $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $sql ="SELECT * FROM list_Investigation"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo "<option value='$rs[ivid]'>$rs[Investigation]</option>"; } ?> </select></td> </tr> </div> </table> <table id='example2' class='table table-bordered table-hover'> <tr> <td><button type="submit" name="signup">Proceed</butoon> </tr> </table> </form> <table id="example2" class="order-table table table-bordered table-hover css-serial"> <thead> <tr> <th>SR No</th> <th>Investigation Details</th> <th>Action</th> </tr> </thead> <?php include("dbconnection.php"); $sql12 ="SELECT * FROM frequency WHERE drid='$_GET[drid]' AND surgeryid='$_GET[surgeryid]' AND type='inv'"; $qsql12 = mysqli_query($con,$sql12); while($rs12 = mysqli_fetch_array($qsql12)) { echo"<td></td> <td> "; $sql13 ="SELECT * FROM list_Investigation WHERE ivid='$rs12[typeid]'"; $qsql13 = mysqli_query($con,$sql13); while($rs13 = mysqli_fetch_array($qsql13)) { if (is_numeric($rs13[ivid])) { $sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs13[labdepartmentid]'"; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) echo "$rh1[lab_department_name]"; } if (is_numeric($rs13[radiobodypartid])) { $sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs13[radiobodypartid]'"; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) echo "- $rh1[bodypart]"; } if (is_numeric($rs13[radiobodypartid])) { $sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs12[typeid]'"; $qsql1 = mysqli_query($con,$sql1); while($rh1 = mysqli_fetch_array($qsql1)) echo "- $rh1[Investigation]"; } else { $sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs12[typeid]' OR ivid='$rs12[typeid]' AND labdepartmentid='Unspecified'"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); while($rsn = mysqli_fetch_array($qsqlpatient1)) { echo" $rsn[Investigation]"; } } echo"</td>"; echo" <td><div class='btn-group'> <button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'> Action <span class='caret'></span> </button> <ul class='dropdown-menu'> <li><a href='frequencyinvestigation_add.php?delid=$rs[medicine_id]')'> <i class='glyphicon glyphicon-save'></i> Remove</a></li> </ul> </div></td> </tr> "; } } ?> </tbody> <tfoot> </tfoot> </table> </div> <html> <head> <style> .center { border: 1px solid grey; text-align:; } h2 { color: #4287f5; } </style> </head> <head> <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> <script> $(document).ready(function () { $('select').selectize({ sortField: 'text' }); }); </script>