D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
junglebellresort.com
/
admin
/
Filename :
manage-gallery.php
back
Copy
<?php include'config.php'; include'function.php'; $action = $_GET['action']; $action_title = stringModify($action); $gallery_title = ""; $gallery_cat = ""; $gallery_img = ""; if($action == 'delete_photo'){ $del_id = $_GET['id']; $del_gallery = mysqli_query($conn, "DELETE FROM `image_gallery` WHERE gallery_id = '$del_id'"); if ($del_event) { echo '<script>alert("Image data deleted.")</script>'; echo '<script> window.location.href = "image_gallery.php";</script>'; } } if($action == 'edit_photo'){ $edit_id = $_GET['id']; $view_gallery = mysqli_query($conn, "SELECT * FROM image_gallery WHERE gallery_id = '$edit_id'"); while($row = mysqli_fetch_array($view_gallery)) { $gallery_title = $row['gallery_title']; $gallery_cat = $row['gallery_category']; $gallery_img = $row['gallery_img']; } } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Manage Gallery Images | Box of Events</title> <?php include'style.php'; ?> </head> <body> <!-- Begin page --> <div id="layout-wrapper"> <?php include'header.php'; ?> <!-- ============================================================== --> <!-- Start right Content here --> <!-- ============================================================== --> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <!-- start page title --> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18"><?php echo $action_title; ?> / <span class="mx-2"><a class="" href="image-gallery.php">Image Gallery</a></span> </h4> <div class="page-title-right"> <ol class="breadcrumb m-0"> <li class="breadcrumb-item"><a href="./">Admin</a></li> <li class="breadcrumb-item active"><?php echo $action_title; ?></li> </ol> </div> </div> </div> </div> <!-- end page title --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body p-4"> <div class="row"> <div class="col-lg-6"> <form action="" method="POST" enctype="multipart/form-data" > <div class="mb-3"> <label for="example-text-input" class="form-label">Image Title:</label> <input class="form-control" type="text" value="<?php echo $gallery_title; ?>" id="example-text-input" name="gallery_title" placeholder="Image Title"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Image Category:</label> <input class="form-control" type="text" value="<?php echo $gallery_cat; ?>" id="example-text-input" name="gallery_category" placeholder="Image Category"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Gallery Image:</label> <input class="form-control" type="file" value="<?php echo $gallery_img; ?>" id="example-img-input" name="gallery_img" placeholder="Gallery Image"> </div> <div class="mt-4"> <div class="btn_div"> <button type="submit" name="<?php echo $action; ?>" class="btn btn-primary w-md btn_manage"><?php echo $action_title; ?></button> </div> </div> </form> </div> </div> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <?php include'right-sidebar.php'; ?> <?php include'script.php'; ?> </body> </html> <?php if (isset($_POST['add_photo'])){ $gallery_title = $_POST['gallery_title']; $gallery_cat = $_POST['gallery_category']; $gallerydir = 'images-gallery'; if(!is_dir($gallerydir)){ mkdir($gallerydir); } $gallery_img = $_FILES['gallery_img']['name']; $tmp_gallery = $_FILES['gallery_img']['tmp_name']; $gallery_path = $gallerydir ."/". $gallery_img; if(move_uploaded_file($tmp_gallery, $gallery_path)){ echo $insert_gallery = "insert into image_gallery(gallery_id, gallery_title, gallery_category, gallery_img) values('', '$gallery_title', '$gallery_cat', '$gallery_img')"; $run_query = mysqli_query($conn, $insert_gallery); if ($run_query){ echo '<script>alert("Image uploaded in Gallery.")</script>'; echo '<script> window.location.href = "image-gallery.php";</script>'; } else{ echo '<script>alert("Image not uploaded in Gallery.")</script>'; } } else{ echo '<script>alert("Image not uploaded.")</script>'; } } if (isset($_POST['edit_photo'])) { $gallery_title = $_POST['gallery_title']; $gallery_cat = $_POST['gallery_category']; $ItemImg_Condition = ''; if ($_FILES['gallery_img']['name'] != '') { $gallery_img = $_FILES['gallery_img']['name']; $ItemImg_path = 'images-gallery/'.$gallery_img; move_uploaded_file($_FILES['gallery_img']['tmp_name'], $ItemImg_path); $ItemImg_Condition = ", gallery_img='$gallery_img'"; } $update_event = mysqli_query($conn, "UPDATE image_gallery SET `gallery_title`='$gallery_title', `gallery_category`='$gallery_cat' $ItemImg_Condition WHERE `gallery_id` = '$edit_id'"); if ($update_event){ echo '<script>alert("Gallery data edited.")</script>'; echo '<script> window.location.href = "image-gallery.php";</script>'; } else{ echo '<script>alert("Gallery data not edited.")</script>'; } } ?>