Server IP : 162.240.98.243 / Your IP : 3.145.55.198 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/Pharmacy/ |
Upload File : |
<?php session_start(); include("dbconnection.php"); require_once('../../DBManager.php'); require_once("../../LoginManager.php"); require_once('../../patientmanager.php'); include("header.php"); include("menu.php"); if(isset($_POST[opdmedicine])) { $sql="UPDATE medicine_stok SET Category='$_POST[Category]',DRUGS_name='$_POST[DRUGS_name]',Dose='$_POST[Dose]',size='$_POST[size]',Name_brand='$_POST[Name_brand]',Contain='$_POST[Contain]',QtyContain='$_POST[QtyContain]' WHERE medicine_id='$_GET[medicine_id]'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('Update successfully');</script><script> window.history.go(-2)</script>"; } } ?> <!DOCTYPE html> <html> <head> <title>Medicine in Stock</title> </head> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <body> <h2 Align="center">Medicine in Stock </h2> </tbody> <tfoot> </tfoot> </table> <form class='form1' name="opdmedicine" method="post"> <?php include("dbconnection.php"); require_once('../../DBManager.php'); require_once('../../LoginManager.php'); $sql ="SELECT * FROM medicine_stok WHERE medicine_id='$_GET[medicine_id]'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { echo " <label>Category</label> <select onchange='cotegory(this.value)' class='form-control' name='Category' id='Category'> <option value='$rs[Category]'> $rs[Category]</option> <option value='Injectable'>Injectable </option> <option value='IV Fluid'>IV Fluid </option> <option value='Capsule'>Capsule </option> <option value='Tablet'>Tablet </option> <option value='Syrup'>Syrup </option> <option value='Powder'>Powder </option> <option value='Ointment'>Ointment</option> </select> <label>Name of Medicine</label> <input type='text' placeholder='Name of Medicine' name='DRUGS_name' value='$rs[DRUGS_name]' id='DRUGS_name' class='form-control' /> <label>Dose</label> <input type='text' placeholder='In mg' value='$rs[Dose]' name='Dose' id='dose' class='form-control' /> <label>Packaging Size</label> <input type='text' placeholder='Packaging Size' value='$rs[size]' name='size' id='size' class='form-control' /> <input type='text' placeholder='Packaging Size' value='$rs[QtyContain]' name='QtyContain' id='QtyContain' class='form-control' /> <label>Name of Brand</label> <input type='text' value='$rs[Name_brand]' onkeyup='this.value = this.value.toUpperCase();' placeholder='Name of Brand' name='Name_brand' id='Name_brand' class='form-control' /> <label>Contain</label> <input type='text' value='$rs[Contain]' onkeyup='this.value = this.value.toUpperCase();' placeholder='Contain' name='Contain' id='Contain' class='form-control' /> <br> <input type='submit' value='Update' name='opdmedicine'> </form> "; } ?> </div> </div> </div> </body> </html>