Server IP : 162.240.98.243 / Your IP : 18.216.151.164 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(); require_once('../dbconnection.php'); include('header.php'); include('menu.php'); if(isset($_POST['signup'])) { $sql="UPDATE consumable_inventory SET invoice_no='$_POST[invoice_no]',dateOfPurchase='$_POST[dateOfPurchase]',Vendor='$_POST[Vendor]',cmrp='$_POST[cmrp]',batchno='$_POST[batchno]',HSN='$_POST[HSN]',mrp='$_POST[mrp]',gst='$_POST[gst]',qty='$_POST[qty]',totalQty='$_POST[totalQty]',expiryDate='$_POST[expiryDate]' WHERE inventory_id='$_GET[inventory_id]'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('Update successfully');</script><script> window.history.go(-2)</script>"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <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; z-index:10000000; } @keyframes spin { 0% { -webkit-transform: rotate(0deg); transform: rotate(0deg); } 100% { -webkit-transform: rotate(360deg); transform: rotate(360deg); } } </style> </head> <body> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div> <form name='signup' id="myForm" method="POST"> <table id='example2' class='table table-bordered table-hover'> <?php $sql ="SELECT * FROM consumable_inventory WHERE inventory_id='$_GET[inventory_id]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo " <tr> <td width='50%'>Invoice No :</td><td width='50%'><input type='text' placeholder='Invoice No' name='invoice_no' value='$rs[invoice_no]' class='form-control'> </td> </tr> <tr> <td width='50%'>Date of Purchase :</td><td width='50%'><input type='date' placeholder='Invoice No' name='dateOfPurchase' value='$rs[dateOfPurchase]' class='form-control'> </td> </tr> <tr> <td width='50%'>Vendor:</td><td width='50%'> <select id='select-state' name='Vendor' required='true'>"; $narayan=LoginManager::currentUser(); $hari=LoginManager::getUserTypeByuname("$narayan"); $sql ="SELECT * FROM site_users WHERE userno='$hari'"; $qsql = mysqli_query($con,$sql); if($re = mysqli_fetch_array($qsql)) $VenderList=$con->query("SELECT * FROM `list_vendor` where adminid='$re[entered_by]'"); while($RowVL=$VenderList->fetch_array()){ ?> <option value='<?php echo $RowVL['vid'] ?>' <?php echo($rs[Vendor]==$RowVL[vid])? 'selected':''; ?> ><?php echo $RowVL[name] ?></option> <? } echo" </select> </td> </tr> <tr> <td width='50%'>Rate Per Unit:</td><td width='50%'><input type='text' placeholder='Cost Price' name='cmrp' value='$rs[cmrp]' class='form-control'> </td> </tr> <tr> <td width='50%'>Batch Number :</td><td width='50%'><input type='text' placeholder='Batch number' name='batchno' value='$rs[batchno]' id='batchno' class='form-control'> </td> </tr> <tr> <td width='50%'>HSN No :</td><td width='50%'><input type='text' placeholder='HSN No' name='HSN' value='$rs[HSN]' id='HSN' class='form-control'> </td> </tr> <tr> </td> </tr><tr> <td width='50%'>MRP :</td><td width='50%'><input type='text' placeholder='Price' name='mrp' id='mrp' value='$rs[mrp]' class='form-control'></td></tr> <tr> <td width='50%'>GST % :</td><td width='50%'><input type='text' placeholder='GST in %' name='gst' id='gst' value='$rs[gst]' class='form-control'></td></tr><tr> <td width='50%'>Expiry Date : </td> <td width='50%'><input type='date' value='$rs[expiryDate]' placeholder='price' name='expiryDate' id='expiryDate' class='form-control'></td></tr><tr> <td width='50%'>qty :</td><td width='50%'><input type='text' placeholder='qty' name='qty' id='qty' value='$rs[qty]' class='form-control' readonly /></td></tr><tr> <td width='50%'>Total qty :</td><td width='50%'><input type='text' placeholder='Total qty' name='totalQty' id='totalQty' value='$rs[totalQty]' class='form-control'></td> </tr> "; } ?> </table> <input type="submit" value="Update" name="signup"> </form> </div></div>