Server IP : 162.240.98.243 / Your IP : 3.143.25.6 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("workdeskmenu.php"); ?> <!DOCTYPE html> <html> <head> <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"> <script src="https://code.jquery.com/jquery-1.12.4.js"></script> <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script> <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 action="Add_inventory_ontime2.php" 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); while($rs = mysqli_fetch_array($qsql)) { echo " <h4 align='center'>$rs[DRUGS_name]-$rs[Dose]$rs[dose_value]</h4> "; } ?> <table id='example2' class='table table-bordered table-hover'> <tr><th>Batch number</th><th>Price</th><th>Expiry Date</th><th>Quantity</th></tr> <?php include("dbconnection.php"); require_once('../DBManager.php'); require_once('../LoginManager.php'); $sql ="SELECT * FROM medicine_inventory WHERE medicine_id='$_GET[medicine_id]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo " <tr><td>$rs[Batch_number]</td><td>$rs[mrp]</td><td>$rs[Expiry_Date]</td><td>$rs[Quantity] <a href='#'>Edit </a></td> </tr>"; } ?> <tr> <td><input type='text' placeholder='Batch number' name='Batch_number[]' id='Batch_number' class='form-control'> </td> <td><input type='text' placeholder='Price' name='mrp[]' id='mrp' class='form-control'></td> <td><input type='date' placeholder='price' name='Expiry_Date[]' id='Expiry_Date' class='form-control'></td> <td><input type='text' placeholder='Quantity' name='Quantity[]' id='Quantity' class='form-control'></td> </tr> <?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); while($rs = mysqli_fetch_array($qsql)) { echo " <input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'> "; } ?> <?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); while($rs = mysqli_fetch_array($qsql)) { echo " <input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'> "; } ?> <?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); while($rs = mysqli_fetch_array($qsql)) { echo " <input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'> "; } ?> <?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); while($rs = mysqli_fetch_array($qsql)) { echo " <input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'> "; } ?> <?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); while($rs = mysqli_fetch_array($qsql)) { echo " <input type='hidden' name='medicine_id[]' value='$rs[medicine_id]'> "; } ?> </table> <script> let lineNo = 1; $(document).ready(function () { $(".add-row").click(function () { markup = "<tr><td><input type='text' placeholder='Batch number' name='Batch_number[]' class='form-control'></td><td><input type='text' placeholder='Price' name='mrp[]' class='form-control'></td><td><input type='date' placeholder='Expiry_Date' name='Expiry_Date[]' class='form-control'></td><td><input type='text' placeholder='Quantity' name='Quantity[]' class='form-control'></td>" "</tr>"; tableBody = $("table tbody"); tableBody.append(markup); lineNo++; }); }); </script> <br> <br> <input type="button" align="right" value="Add More" class="add-row"> <br> <br> <input type="submit" value="Submit"> </form> </div> </div> </div> </body> </html>