1#@!#!123s

: / home3 / encodto1 / salvation.incrediblebengal.com / admin /
Filename : update_menu_category.php
back
<?php include'config.php';
include'function.php';
$page_title = "Update Menu Category";  
$cat_img = '';
$cat_name = '';
$cat_bnr = '';
$action_btn = 'add_item';

if (isset($_GET["delete_id"])) {
    $delete_Id = $_GET["delete_id"];
    $delQry = mysqli_query($conn, "delete FROM `recipe_category` WHERE recipe_category_id = $delete_Id") or mysqli_error($conn);
    if ($delQry) {
        echo '<script>alert("Data deleted successfully.")</script>';
        echo '<script>window.location.href="config-menu-category.php";</script>';
    }
    else{
        echo '<script>alert("Data not deleted successfully.")</script>';
    }
}
else if(isset($_GET["edit_id"])) {
    $show_item = "SELECT * FROM recipe_category WHERE recipe_category_id ='" . $_GET["edit_id"] . "'";
    $run_query = mysqli_query($conn, $show_item);
    $action_btn = "edit_item";
    while($row = mysqli_fetch_array($run_query)) { 
    $cat_id = $row['recipe_category_id'];
    $cat_name = $row['recipe_category_name'];
    $cat_bnr = $row['recipe_category_banner'];
    $cat_img = $row['recipe_category_img'];
    }
}


?>



<!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>Update Food Category</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)">Update Food Category</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">
                                    
                                    <form action="" method="POST" enctype="multipart/form-data">
                                        <div class="form-group">
                                            <label class="form_label">Category Name..</label>
                                            <input type="text" class="form-control" name="item_name" value="<?php echo $cat_name ?>" >
                                        </div>
                                        <div class="form-group">
                                            <img class="editable_img" id="editItem" src="images/icons/<?php echo $cat_img ?>" style="height: 50px;width: 50px;margin:10px;">
                                            <label class="form_label">Category Icon</label>
                                            <input class="form-control" type="file" name="item_icon">
                                        </div>
                                        <div class="form-group">
                                            <img class="editable_img" src="food_category_banner/<?php echo $cat_bnr ?>" style="height: 150px;width: 300px;">
                                            <label class="form_label">Category Image</label>
                                            <input class="form-control" type="file" name="item_banner">
                                        </div>

                                        <div class="form-group">
                                            <input class="bttn bttn-submit" type="submit" 
                                            name="<?= $action_btn; ?>" value="<?= $action_btn; ?>">
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
    <?php include'footer.php'; ?>

<script type="text/javascript">
$(document).ready(function(){
    var loadFile = function(event) {
    var image = document.getElementById('editItem');
    image.src = URL.createObjectURL(event.target.files[0]);
    };
    var loadBnr = function(event) {
    var image = document.getElementById('editbnr');
    image.src = URL.createObjectURL(event.target.files[0]);
    };
});
</script>
</body>
</html>

<?php 

if (isset($_POST['add_item'])) {
$item_name = $_POST['item_name']; 

    $iconsDir = 'images/category-icons';
    if(!is_dir($iconsDir)){ 
        mkdir($iconsDir);
    }
    $item_img = $_FILES['item_icon']['name'];
    $item_tmp = $_FILES['item_icon']['tmp_name'];
    $item_path = $iconsDir ."/". $item_img;

    if(move_uploaded_file($item_tmp, $item_path)){}
    else{echo '<script>alert("Category image not uploaded.")</script>';}

    $bannerDir = 'images/food-category-banner';
    if(!is_dir($bannerDir)){ 
        mkdir($bannerDir);
    }
    $item_banner = $_FILES['item_banner']['name'];
    $item_bannertmp = $_FILES['item_banner']['tmp_name'];
    $item_bannerpath = $bannerDir ."/". $item_banner;

    if(move_uploaded_file($item_bannertmp, $item_bannerpath)){
        echo '<script>alert("Category Banner uploaded.")</script>';
    }
    else{echo '<script>alert("Category Banner not uploaded.")</script>';}

    echo $catinsrt = "insert into recipe_category() values('', '$item_name', '$item_img', '$item_banner')";
    $run_query = mysqli_query($conn, $catinsrt) or die(mysqli_error($conn));
    if ($run_query){
        echo '<script>alert("Category data uploaded.")</script>';
        echo '<script> window.location.href ="config-menu-category.php";</script>';
    }
    else{
        echo '<script>alert("Category data not uploaded.")</script>';
       echo '<script>window.location.href="config-menu-category.php";</script>';
    }
}


if (isset($_POST['edit_item'])) {
    $catId = $_GET["edit_id"];
    $cat_name = $_POST['item_name'];
    $catBnnr_condition = ' ';
    $catIcon_condition = ' ';

    if ($_FILES['item_icon']['name'] != '') {
        unlink('images/category-icons/'.$cat_img);

        $cat_icon = $_FILES['item_icon']['name'];
        $catIcon_path = 'images/category-icons/'.$cat_icon;
        move_uploaded_file($_FILES['item_icon']['tmp_name'], $catIcon_path);
        $catIcon_condition = ", recipe_category_img='$cat_icon'";

    }

    if ($_FILES['item_banner']['name'] != '') {
        unlink('food-category-banner/'.$cat_banner);
        $cat_bnnr = $_FILES['item_banner']['name'];
        $catBnnr_path = 'images/food-category-banner/'.$cat_bnnr;
        move_uploaded_file($_FILES['item_banner']['tmp_name'], $catBnnr_path);
        $catBnnr_condition = ", recipe_category_banner='$cat_bnnr'";
    }

    echo $edit_query = "UPDATE recipe_category SET `recipe_category_name`='$cat_name' $catIcon_condition $catBnnr_condition WHERE recipe_category_id ='$catId'";  
    $run_query = mysqli_query($conn, $edit_query) or die();
    if ($run_query) {
       echo '<script>alert("Data updated successfully.")</script>';
       echo '<script>window.location.href="config-menu-category.php";</script>';
    }
    else{
        echo '<script>alert("Oops! Data not updated.")</script>';
       echo '<script>window.location.href="config-menu-category.php";</script>';
    }
}

?>