D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u166148318
/
public_html
/
admin
/
Filename :
view_team.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 `team` WHERE id = ?"); $verify_delete->execute([$delete_id]); if ($verify_delete->rowCount() > 0) { $select_images = $conn->prepare("SELECT * FROM `team` WHERE id = ?"); $select_images->execute([$delete_id]); while ($fetch_images = $select_images->fetch(PDO::FETCH_ASSOC)) { $image_01 = $fetch_images['team_pic']; unlink('./' . $image_01); } $delete_listings = $conn->prepare("DELETE FROM `team` WHERE id = ?"); $delete_listings->execute([$delete_id]); $success_msg[] = 'One Member deleted!'; } else { $warning_msg[] = 'Member 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>My team</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 team Members</h1> <form action="" method="POST" class="search-form"> <input type="text" name="search_box" placeholder="search member..." maxlength="100" 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 `team` WHERE name LIKE '%{$search_box}%' OR function LIKE '%{$search_box}%' ORDER BY id DESC"); $select_listings->execute(); } else { $select_listings = $conn->prepare("SELECT * FROM `team` ORDER BY id DESC"); $select_listings->execute(); } $select_listings = $conn->prepare("SELECT * FROM `team` 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"> <div class="thumb"> <img src="./<?= $fetch_listing['team_pic']; ?>" alt=""> </div> <p class="price"><?= $fetch_listing['name']; ?></p> </div> <form action="" method="POST"> <input type="hidden" name="delete_id" value="<?php echo $fetch_listing['id']; ?>"> <input type="submit" value="delete Member" onclick="return confirm('delete <?php echo $fetch_listing['name']; ?> from team?');" 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 Team member 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>