1#@!#!123s

: / home3 / encodto1 / salvation.incrediblebengal.com / admin /
Filename : manage_home_banner.php
back
<?php 
include'config.php';
include'function.php';
$page_title = "Update Home Banner"; 
$slider_id = '';
$slider_title = '';
$slider_content = '';
$slider_img = '';
$submit_bttn = 'add_banner';

if (isset($_GET["delete_id"])) {
    echo "delete Id: ".$_GET["delete_id"];
    // "delete FROM recipe_category WHERE recipe_category_id ='" . $_GET["delete_id"] . "'";
}
if (isset($_GET["edit_id"])) {
    $show_item = "SELECT * FROM home_banner WHERE home_banner_id ='" . $_GET["edit_id"] . "'";
    $run_query = mysqli_query($conn, $show_item);
    $cat_img = '';
    while($row = mysqli_fetch_array($run_query)) {
        $slider_id = $row['home_banner_id'];
        $slider_title = $row['home_banner_title'];
        $slider_content = $row['home_banner_content'];
        $slider_img = $row['home_banner_img'];
        $submit_bttn = 'edit_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>Manage Home Banner</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)">Manage Home Banner</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">Slider Title..</label>
                                            <input type="text" class="form-control" name="slider_title" value="<?php echo $slider_title ?>" >
                                        </div>
                                        <div class="form-group">
                                            <label class="form_label">Slider Content</label>
                                            <textarea type="text" class="form-control" name="slider_content"><?php echo $slider_content ?> </textarea>
                                        </div>
                                        <div class="form-group">
                                            <img class="editable_img" src="images/slides/<?php echo $slider_img ?>" style="height: 150px;width: 300px;">
                                            <label class="form_label">Slider Image</label>
                                            <input class="form-control" type="file" name="slider_img">
                                        </div>

                                        <div class="form-group">
                                            <input class="bttn bttn-submit" type="submit" name="<?php echo $submit_bttn; ?>" value="<?php echo $submit_bttn; ?>">
                                        </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]);
    };
    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_banner'])) {
    $slider_title = $_POST['slider_title'];
    $slider_content = $_POST['slider_content'];
    $sliderImg_condition = ' ';

    if ($_FILES['slider_img']['name'] != '') {
        $slider_img = $_FILES['slider_img']['name'];
        $sliderImg_path = 'images/slides/'.$slider_img;
        move_uploaded_file($_FILES['slider_img']['tmp_name'], $sliderImg_path);
        $sliderImg_condition = ", '$slider_img'";
    }

    $insert_query = "INSERT INTO home_banner(`home_banner_id`, `home_banner_title`, `home_banner_content`, `home_banner_img`) VALUES('', '$slider_title', '$slider_content' $sliderImg_condition)";
    $run_query = mysqli_query($conn, $insert_query) or die();
    if ($run_query) {
       echo '<script>alert("Data inserted successfully.")</script>';
       // echo '<script>window.location.href="config-home-bnnr.php";</script>';
       redirect('config-home-bnnr.php');
    }
    else{
        echo '<script>alert("Oops! not inserted.")</script>';
    }
}

if (isset($_POST['edit_item'])) {
    $slider_id = $_GET["edit_id"];
    $slider_title = $_POST['slider_title'];
    $slider_content = $_POST['slider_content'];
    $sliderImg_condition = ' ';

    if ($_FILES['slider_img']['name'] != '') {
        $slider_img = $_FILES['slider_img']['name'];
        $sliderImg_path = 'images/slides/'.$slider_img;
        move_uploaded_file($_FILES['slider_img']['tmp_name'], $sliderImg_path);
        $sliderImg_condition = ", home_banner_img='$slider_img'";
    }

    $edit_query = "UPDATE home_banner SET `home_banner_title`='$slider_title', `home_banner_content`='$slider_content' $sliderImg_condition WHERE home_banner_id ='$slider_id'";
    $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-home-bnnr.php";</script>';
    }
    else{
        echo '<script>alert("Oops! not updated.")</script>';
    }

}

?>