| Server IP : 162.240.98.243 / Your IP : 3.137.198.239 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/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>