Server IP : 162.240.98.243 / Your IP : 3.145.170.105 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("header.php"); include("patient_menu.php"); include("dbconnection.php"); if(isset($_POST[submit])) { { $sql ="INSERT INTO medication(patientid,drug,dose,Route,Frequency,duration,prescriptionid,poa) values('$_GET[patientid]','$_POST[drug]','$_POST[dose]','$_POST[Route]','$_POST[Frequency]','$_POST[duration]','$_POST[prescriptionid]','Regular_Medicine')"; if($qsql = mysqli_query($con,$sql)) { // echo "<script>alert('Medicine record inserted successfully...');</script></script>"; } else { echo mysqli_error($con); } } } if(isset($_GET[editid])) { $sql="SELECT * FROM immunization WHERE patientid='$_GET[editid]' "; $qsql = mysqli_query($con,$sql); $rsedit = mysqli_fetch_array($qsql); } if(isset($_SESSION[patientid])) { $sqlpatient = "SELECT * FROM patient WHERE patientid='$_SESSION[patientid]' "; $qsqlpatient = mysqli_query($con,$sqlpatient); $rspatient = mysqli_fetch_array($qsqlpatient); $readonly = " readonly"; } ?> <?php include("dbconnection.php"); if(isset($_GET[delid])) { $sql ="DELETE FROM medication WHERE id='$_GET[delid]'"; $qsql=mysqli_query($con,$sql); if(mysqli_affected_rows($con) == 1) { echo "<script>alert('Deleted successfully..');</script>"; } } ?> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div class="card-body"> <table id="example2" class="table table-bordered table-hover"> <thead> <tr> <div class='card-header d-flex p-0'> <ul class='nav nav-pills ml-auto p-2'> <th><strong>Drug </strong></th> <th><strong>Dose in MG</strong></th> <th><strong>Action</strong></th> </tr> </thead> <?php $sql1 ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'"; $qsql1 = mysqli_query($con,$sql1); while($rp = mysqli_fetch_array($qsql1)) { $sql ="SELECT * FROM medication WHERE patientid='$rp[patientid]' AND poa='Regular_Medicine' "; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo " <tbody> <tr> <td> $rs[drug]</td> <td> $rs[dose]</td> <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='edit_regularmedicine.php?id=$rs[id]'> <i class='glyphicon glyphicon-save'></i> Edit</a></li> <li><a href='regularmedicine.php?patientid=$rs[patientid]&delid=$rs[id]'>Remove</a> </li> </ul> </div></td> </tr> "; } } ?> </tr> </thead> </tbody> <tfoot> </tfoot> </table> <style> .container { height: 200px; position: relative; border: 3px solid green; } .center { margin: 0; position: absolute; left: 50%; -ms-transform: translate(-50%, -50%); transform: translate(-50%, -50%); } </style> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('#myForm').submit(function() { $('#loaderImg').show(); return true; }); }); </script> <style> #loaderImg { position: absolute; top: 0; bottom: 0; left: 0; right: 0; margin: auto; border: 10px solid grey; border-radius: 50%; border-top: 10px solid black; width: 100px; height: 100px; animation: spin 1s linear infinite; } @keyframes spin { 0% { -webkit-transform: rotate(0deg); transform: rotate(0deg); } 100% { -webkit-transform: rotate(360deg); transform: rotate(360deg); } } </style> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div class="wrapper col2"> </div> <div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div> <form method="post" name="submit" id="myForm"> <table id="example2" class="table table-bordered table-hover"> <tbody> <?php $sqlpatient= "SELECT * FROM patient WHERE patientid='$_GET[patientid]'"; $qsqlpatient = mysqli_query($con,$sqlpatient); while($rspatient=mysqli_fetch_array($qsqlpatient)) { echo "<input type='hidden' name='patientid' id='patientid' value='$rspatient[patientid]'></td>"; } ?> </tr> <tr> <td height="62">Name of Medicine</td> <td><input type="text" name="drug" required></td> </tr> <tr> <td height="62">Dose (Mg)</td> <td><input type="text" placeholder="Dose in MG" name="dose" required></td> </tr> <tr> <td colspan="2" align="center"><button type="submit" name="submit" id="btn" class='btn btn-info'/>Add</button></td> </tr></tbody> </table> </form> <button onclick="location.href='kindetails.php?<?php echo"patientid=$_GET[patientid]";?>'" type="button" > <span style="color:white"> Next Page</span></button> <script> document.getElementById('btn').addEventListener("click", function(){ this.classList.add("loading"); this.innerHTML = "Loading..."; }); </script> <script> $(function () { $("#example1").DataTable({ "responsive": true, "autoWidth": false, }); $('#example2').DataTable({ "paging": true, "lengthChange": false, "searching": false, "ordering": true, "info": true, "autoWidth": false, "responsive": true, }); }); </script>