D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
aviscollection.com
/
admin
/
Filename :
manage-review.php
back
Copy
<?php include'config.php'; include'function.php'; $action = $_GET['action']; $action_title = stringModify($action); $review_name = ""; $review_address = ""; $review_content = ""; $review_status = ""; $review_img = ""; if($action == 'delete_review'){ $del_id = $_GET['id']; $del_event = mysqli_query($conn, "DELETE FROM `reviews` WHERE review_id = '$del_id'"); if ($del_event){ echo '<script>alert("Review data deleted.")</script>'; echo '<script> window.location.href = "review-list";</script>'; } } if($action == 'edit_review'){ $edit_id = $_GET['id']; $review_qury = mysqli_query($conn, "SELECT * FROM `reviews` WHERE review_id = '$edit_id'") or die(mysqli_error($conn)); while($row = mysqli_fetch_assoc($review_qury)) { echo $review_name = $row['review_name']; echo $review_address = $row['review_address']; echo $review_content = $row['review_content']; echo $review_status = $row['review_status']; echo $review_img = $row['review_img']; } } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Manage Clients Review | <?php echo $company; ?></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">Reviews</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">Review Name:</label> <input class="form-control" type="text" value="<?php echo $review_name; ?>" name="review_name" placeholder="Review Title"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Review Address:</label> <input class="form-control" type="text" value="<?php echo $review_address; ?>" name="review_address" placeholder="Review Address"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Review Content:</label> <textarea class="form-control" name="review_content" rows="4" placeholder="Review Content" ><?php echo $review_content; ?></textarea> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Review Image:</label> <input class="form-control" type="file" value="<?php echo $review_img; ?>" name="review_img" placeholder="Review Image"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Review Status:</label> <?php if($review_status == 1){ echo '<div class="form-check"> <input class="form-check-input" type="radio" name="review_status" id="flexRadioDefault1" value="1" checked> <label class="form-check-label" for="flexRadioDefault1">Active</label> </div> <div class="form-check"> <input class="form-check-input" type="radio" name="review_status" id="flexRadioDefault2" value="0"> <label class="form-check-label" for="flexRadioDefault2">Inactive</label> </div>'; } elseif ($review_status === 0) { echo '<div class="form-check"> <input class="form-check-input" type="radio" name="review_status" id="flexRadioDefault1" value="1" > <label class="form-check-label" for="flexRadioDefault1">Active</label> </div> <div class="form-check"> <input class="form-check-input" type="radio" name="review_status" id="flexRadioDefault2" value="0" checked> <label class="form-check-label" for="flexRadioDefault2">Inactive</label> </div>'; } else{ echo '<div class="form-check"> <input class="form-check-input" type="radio" name="review_status" id="flexRadioDefault1" value="1" checked> <label class="form-check-label" for="flexRadioDefault1">Active</label> </div> <div class="form-check"> <input class="form-check-input" type="radio" name="review_status" id="flexRadioDefault2" value="0"> <label class="form-check-label" for="flexRadioDefault2">Inactive</label> </div>'; }?> </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_review'])){ $review_name = $_POST['review_name']; $review_address = $_POST['review_address']; $review_content = $_POST['review_content']; $review_status = $_POST['review_status']; $itemImgdir = 'review-images'; if(!is_dir($itemImgdir)){ mkdir($itemImgdir); } $review_img = $_FILES['review_img']['name']; $tmp_review = $_FILES['review_img']['tmp_name']; $review_path = $itemImgdir ."/". $review_img; move_uploaded_file($tmp_review, $review_path); $insert_review = "insert into reviews(review_id, review_name, review_address, review_content, review_status, review_img) values('', '$review_name', '$review_address', '$review_content', '$review_status', '$review_img')"; $run_query = mysqli_query($conn, $insert_review) or die(mysqli_error($conn)); if ($run_query){ // echo '<script>alert("Image uploaded in Gallery.")</script>'; // echo '<script> window.location.href = "image-gallery.php";</script>'; ?> <script> var ask = window.confirm('Are you sure you want to Add more Reviews?'); if (ask) { window.alert('review uploaded in Review List.'); } else{ window.alert('review uploaded in Review List.'); window.location.href = "review-list.php"; } </script> <?php } else{ echo '<script>alert("review not uploaded in Review List.")</script>'; } } if (isset($_POST['edit_review'])) { $review_name = $_POST['review_name']; $review_address = $_POST['review_address']; $review_content = $_POST['review_content']; $review_status = $_POST['review_status']; $ItemImg_Condition = ''; if ($_FILES['review_img']['name'] != '') { $review_img = $_FILES['review_img']['name']; $ItemImg_path = 'review-images/'.$review_img; move_uploaded_file($_FILES['review_img']['tmp_name'], $ItemImg_path); $ItemImg_Condition = ", review_img='$review_img'"; } $update_event = mysqli_query($conn, "UPDATE reviews SET `review_name`='$review_name', `review_address`='$review_address', `review_content`='$review_content', `review_status`='$review_status' $ItemImg_Condition WHERE `review_id` = '$edit_id'"); if ($update_event){ echo '<script>alert("Review data edited.")</script>'; echo '<script> window.location.href = "review-list.php";</script>'; } else{ echo '<script>alert("Review data not edited.")</script>'; } } ?>