D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
salvation.incrediblebengal.com
/
admin
/
Filename :
update_sell_stock.php
back
Copy
<?php include'config.php'; include'get_session_access.php'; $page_title = "Edit Purchase Items"; // if (isset($_GET['delete_id'])) { // echo $delete_id = $_GET['delete_id']; // $delete_item = mysqli_query($conn, "DELETE FROM food_item WHERE food_id = '$delete_id'"); // if ($sql_delete) { // echo "<script>alert('Data of ".$food_id." deleted.')</script>"; // echo '<script>window.location.href="inventory.php";</script>'; // } // else{ // echo "<script>alert('Data of ".$food_id." not deleted.')</script>"; // } // } if (isset($_GET['edit_id'])) { $edit_id = $_GET['edit_id']; $show_item = "SELECT * FROM food_item WHERE food_id ='$edit_id'"; $run_query = mysqli_query($conn, $show_item); ?> <!DOCTYPE html> <html lang="en"> <head> <title>Encode Restaurent - Admin Dashboard </title> <?php include'style.php'; ?> </head> <body> <div id="main-wrapper"> <?php include'header.php'; ?> <?php include'sidebar.php'; ?> <!--********************************** Content body start ***********************************--> <div class="content-body"> <!-- row --> <div class="container-fluid"> <div class="row page-titles mx-0"> <div class="col-sm-6 p-md-0"> <div class="welcome-text"> <h4>Edit Food Stock Details</h4> </div> </div> <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex"> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="javascript:void(0)">Edit Food Item Details</a></li> <li class="breadcrumb-item active"><a href="admin-panel.php">Dashboard</a></li> </ol> </div> </div> <!-- row --> <div class="row gx-1"> <div class="col-xl-6 col-lg-6"> <div class="card"> <div class="card-body"> <div class="basic-form staff_profile"> <?php $row = mysqli_fetch_array($run_query); $food_id = $row['food_id']; $food_name = $row['food_name']; $food_qty = $row['food_qty']; $food_stock = $row['food_stock']; $food_img = $row['food_img']; ?> <form action="" method="POST" enctype="multipart/form-data"> <div class="form-group"> <img class="p-2 mb-3 border" style="width: 200px;" src="images/food-images/<?php echo $food_img ?>"> </div> <div class="form-group"> <label class="form_label">Item Name..</label> <input type="text" class="form-control" name="item_name" value="<?php echo $food_name ?>" autocomplete="off" readonly> </div> <div class="form-group"> <label class="form_label">Item Quantity..</label> <input type="number" class="form-control" name="item_qty" value="<?php echo $food_qty ?>" autocomplete="off"> </div> <div class="form-group"> <label class="form_label">Stock Limit</label> <input class="form-control" type="number" name="item_stock" value="<?php echo $food_stock ?>" autocomplete="off"> </div> <div class="form-group"> <input class="bttn bttn-submit" type="submit" name="edit_item" value="Edit Item"> </div> </form> </div> </div> </div> </div> </div> </div> </div> <!--********************************** Content body end ***********************************--> <?php include'footer.php'; ?> <!-- <script type="text/javascript"> var loadFile = function(event) { var image = document.getElementById('editItem'); image.src = URL.createObjectURL(event.target.files[0]); }; </script> --> </body> </html> <?php if (isset($_POST['edit_item'])) { $food_qty = $_POST['item_qty']; $food_stock = $_POST['item_stock']; echo $edit_query = "UPDATE food_item SET `food_qty`='$food_qty', `food_stock`='$food_stock' WHERE `food_id`='$edit_id'"; $run_query = mysqli_query($conn, $edit_query); if ($run_query) { echo '<script>alert("Data updated successfully.")</script>'; echo '<script>window.location.href="inventory.php";</script>'; } else{ echo '<script>alert("Oops! not updated.")</script>'; } } } ?>