D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
salvation.incrediblebengal.com
/
admin
/
Filename :
edit-fooditem.php
back
Copy
<?php include'config.php'; include'get_session_access.php'; $page_title = "Update Food Items"; if (isset($_GET["delete_id"])) { $del_id = $_GET["delete_id"]; $delQry = "DELETE FROM `food_item` WHERE food_id = $del_id"; $runQry = mysqli_query($conn, $delQry) or mysqli_error($conn); if($runQry) { echo '<script>alert("Data deleted successfully.")</script>'; echo '<script>window.location.href="menulist.php";</script>'; } else{ echo '<script>alert("Data not deleted successfully.")</script>'; echo '<script>window.location.href="menulist.php";</script>'; } } $show_item = "SELECT * FROM food_item WHERE food_id ='" . $_GET["edit_id"] . "'"; $run_query = mysqli_query($conn, $show_item); ?> <!DOCTYPE html> <html lang="en"> <head> <title>Encode Restaurent - <?= $page_title; ?> </title> <?php include'style.php'; ?> </head> <body> <div id="main-wrapper"> <?php include'header.php'; ?> <?php include'sidebar.php'; ?> <?php $show_cat = mysqli_query($conn, "SELECT * FROM `recipe_category`") or die($conn); //while($cats = mysqli_fetch_assoc($show_cat)){ //echo $cats['recipe_category_name']."<br>"; //} //echo "<pre>"; print_r($cats); exit(); ?> <div class="content-body"> <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 Item 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 while($row = mysqli_fetch_array($run_query)) { $f_id = $row['food_id']; $f_name = $row['food_name']; $f_price = $row['food_price']; $f_desc = $row['food_desc']; $f_qty = $row['food_qty']; $f_category = $row['food_category']; $f_stock = $row['food_stock']; echo $foodImg = $row['food_img']; } ?> <form class="mt-3" action="" method="POST" enctype="multipart/form-data"> <div class="form-group"> <label class="form_label">Food Name..</label> <input type="text" class="form-control" name="food_name" value="<?php echo $f_name ?>" > </div> <div class="form-group"> <label class="form_label">Food Price</label> <input class="form-control" type="number" name="food_price" value="<?php echo $f_price ?>"> </div> <div class="form-group"> <label class="form_label">Food Description</label> <textarea class="form-control" type="text" name="food_desc"><?php echo $f_desc; ?></textarea> </div> <div class="form-group"> <label class="form_label">Food Qty</label> <input class="form-control" type="text" name="food_qty" value="<?php echo $f_qty ?>"> </div> <div class="form-group"> <label class="form_label">Food stock</label> <input class="form-control" type="text" name="food_stock" value="<?php echo $f_stock ?>"> </div> <div class="form-group"> <label class="form_label">Food Category</label> <!-- <input class="form-control" type="text" name="food_category" value="<?php echo $f_category ?>"> --> <select class="form-control" name="food_category"> <?php $res = ''; while($cats = mysqli_fetch_assoc($show_cat)){ ?> <option value="<?= $cats['recipe_category_name'];?>" <?php if($f_category == $cats['recipe_category_name']){ echo ' selected="selected"'; } ?> ><?= $cats['recipe_category_name'];?></option> <?php } ?> </select> </div> <div class="form-group"> <label class="form_label text-primary">Food Image</label> <input class="form-control" type="file" name="food_img"> </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> <?php include'footer.php'; ?> </body> </html> <?php if (isset($_POST['edit_item'])) { $f_name = $_POST['food_name']; $f_price = $_POST['food_price']; $f_qty = $_POST['food_qty']; $f_stock = $_POST['food_stock']; $f_category = $_POST['food_category']; $f_desc = $_POST['food_desc']; $foodImg_condition = ''; if ($_FILES['food_img']['name'] != '') { echo $deleteImg = 'images/food-images/'.$foodImg; unlink($deleteImg); echo "<br>"; $fImg = $_FILES['food_img']['name']; $fImg_temp = $_FILES['food_img']['tmp_name']; $fImg_path = 'images/food-images/'.$fImg; if(move_uploaded_file($fImg_temp, $fImg_path)){ echo '<script>alert("Food image updated")</script>';} else{ echo '<script>alert("Food image not updated")</script>';} $foodImg_condition = ", `food_img`='$fImg'"; } echo "<br>"; echo $edit_query = "UPDATE food_item SET `food_name`='$f_name',`food_price`='$f_price',`food_qty`='$f_qty',`food_stock`='$f_stock',`food_category`='$f_category',`food_desc`='$f_desc' $foodImg_condition WHERE `food_id`='$f_id'"; $run_query = mysqli_query($conn, $edit_query) or mysqli_error($conn); if ($run_query) { echo '<script>alert("Data updated successfully.")</script>'; echo '<script>window.location.href="menulist.php";</script>'; } else{ echo '<script>alert("Oops! not updated.")</script>'; } } ?>