Server IP : 162.240.98.243 / Your IP : 52.14.82.217 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 : |
<table id="example2" class="table table-bordered table-hover"> <thead> <tr> <th>Medication Details</th> <th>Action</th> </tr> </thead> <?php include("dbconnection.php"); $sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo" <tr>"; echo "<td> <b>Date & Time : </b>$rs[created_at]<br><b>Drug : </b> "; if (is_numeric($rs[DRUGS])) { $sql1 ="SELECT * FROM medicine_stok WHERE medicine_id='$rs[DRUGS]'"; $qsql1 = mysqli_query($con,$sql1); while($rs1 = mysqli_fetch_array($qsql1)) echo"$rs1[DRUGS_name]"; } else { echo"$rs[DRUGS]"; } echo" <br><b>Dose : </b>$rs[Dose]<br><b>Route : </b>$rs[Route]<br>"; echo "<b>Frequency :</b> "; switch ($rs[Frequency]) { case '01': echo "OD (Once Daily)"; break; case '2': echo "BID/b.i.d. (twice a day)"; break; case '3': echo "TID/t.id. (three times a day)"; break; case '04': echo "QID/q.i.d. (four times a day)"; break; case '1': echo "QHS (every bedtime)"; break; case '6': echo "Q4h (every 4 hours)"; break; case '4': echo "Q4-6h (every 4 to 6 hours)"; break; case '0.143': echo "QWK (every week)"; break; default: echo ""; } echo"<br><b>Duration : </b> $rs[duration] "; switch ($rs[durationselect]) { case '1': echo "Days"; break; case '7': echo "Week"; break; case '28': echo "Month"; break; default: echo ""; } echo" </td>"; echo" <td> <a href='medication/$rs[potential]'>Edit</a>|<form method='post' action='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' name='status'><input type='submit' name='status' Value='Remove'></form></td> </tr> "; } ?> </tbody> <tfoot> </tfoot> </table>