D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u166148318
/
domains
/
avrd.org
/
public_html
/
admin
/
Filename :
view_event.php
back
Copy
<?php include '../components/connect.php'; if (isset($_POST['delete'])) { $delete_id = $_POST['delete_id']; $delete_id = filter_var($delete_id, FILTER_SANITIZE_STRING); $verify_delete = $conn->prepare("SELECT * FROM `event` WHERE id = ?"); $verify_delete->execute([$delete_id]); if ($verify_delete->rowCount() > 0) { $select_images = $conn->prepare("SELECT * FROM `event` WHERE id = ?"); $select_images->execute([$delete_id]); while ($fetch_images = $select_images->fetch(PDO::FETCH_ASSOC)) { $image_01 = $fetch_images['event_photo']; unlink('./' . $image_01); } $delete_listings = $conn->prepare("DELETE FROM `event` WHERE id = ?"); $delete_listings->execute([$delete_id]); $success_msg[] = 'One Event deleted!'; } else { $warning_msg[] = 'Event deleted already!'; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Event</title> <!-- font awesome cdn link --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css"> <!-- custom css file link --> <link rel="stylesheet" href="./css/admin_style.css"> </head> <body> <!-- header section starts --> <?php include '../components/admin_header.php'; ?> <!-- header section ends --> <section class="listings"> <h1 class="heading">My posted Events </h1> <form action="" method="POST" class="search-form"> <input type="text" name="search_box" placeholder="search Event..." maxlength="200" required> <button type="submit" class="fas fa-search" name="search_btn"></button> </form> <div class="box-container"> <?php if (isset($_POST['search_box']) or isset($_POST['search_btn'])) { $search_box = $_POST['search_box']; $search_box = filter_var($search_box, FILTER_SANITIZE_STRING); $select_listings = $conn->prepare("SELECT * FROM `event` WHERE event_title LIKE '%{$search_box}%' OR event_date LIKE '%{$search_box}%' ORDER BY id DESC"); $select_listings->execute(); } else { $select_listings = $conn->prepare("SELECT * FROM `event` ORDER BY id DESC"); $select_listings->execute(); } $select_listings = $conn->prepare("SELECT * FROM `event` ORDER BY id DESC"); $select_listings->execute(); $total_images = 0; if ($select_listings->rowCount() > 0) { while ($fetch_listing = $select_listings->fetch(PDO::FETCH_ASSOC)) { ?> <div class="box"> <div class="thumb"> <p><span><?= $fetch_listing['event_address']; ?></span></p> <img src="./<?= $fetch_listing['event_photo']; ?>" alt=""> </div> <p class="price"><?= $fetch_listing['event_date']; ?></p> <h3 class="name"><?= $fetch_listing['event_title']; ?></h3> <p class="location"><?= $fetch_listing['event_concern']; ?></p> <form action="" method="POST"> <input type="hidden" name="delete_id" value="<?php echo $fetch_listing['id']; ?>"> <input type="submit" value="delete Event" onclick="return confirm('delete <?php echo $fetch_listing['event_title']; ?> from Event?');" name="delete" class="delete-btn"> </form> </div> <?php } ?> <?php } elseif (isset($_POST['search_box']) or isset($_POST['search_btn'])) { echo '<p class="empty">no results found!</p>'; } else { echo '<p class="empty">no Event posted yet!</p>'; } ?> </div> </section> <script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/2.1.2/sweetalert.min.js"></script> <!-- custom js file link --> <script src="./js/admin_script.js"></script> <?php include '../components/message.php'; ?> </body> </html>