D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u166148318
/
public_html
/
admin
/
Filename :
view_attendance.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 `attendance` WHERE id = ?"); $verify_delete->execute([$delete_id]); if($verify_delete->rowCount() > 0){ $delete_bookings = $conn->prepare("DELETE FROM `attendance` WHERE id = ?"); $delete_bookings->execute([$delete_id]); $success_msg[] = 'One attendance deleted!'; }else{ $warning_msg[] = 'attendance 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>attendance</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 --> <!-- messages section starts --> <section class="grid"> <h1 class="heading">My Attendance list</h1> <form action="" method="POST" class="search-form"> <input type="text" name="search_box" placeholder="filter Attendance..." 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_messages = $conn->prepare("SELECT * FROM `attendance` WHERE name LIKE '%{$search_box}%' OR email LIKE '%{$search_box}%' OR event LIKE '%{$search_box}%'"); $select_messages->execute(); }else{ $select_messages = $conn->prepare("SELECT * FROM `attendance`"); $select_messages->execute(); } if($select_messages->rowCount() > 0){ while($fetch_messages = $select_messages->fetch(PDO::FETCH_ASSOC)){ ?> <div class="box"> <p>This person wants to Attand</p> <p><span><?= $fetch_messages['name']; ?></span></p> <p>email : <a href="mailto:<?= $fetch_messages['email']; ?>"><?= $fetch_messages['email']; ?></a></p> <p>number : <a href="tel:<?= $fetch_messages['phone']; ?>"><?= $fetch_messages['phone']; ?></a></p> <p>Reason : <span><?= $fetch_messages['reason']; ?></span></p> <p>Event : <span><?= $fetch_messages['event']; ?></span></p> <form action="" method="POST"> <input type="hidden" name="delete_id" value="<?= $fetch_messages['id']; ?>"> <input type="submit" value="Delete This Attendance" onclick="return confirm('Do you want to delete <?= $fetch_messages['name']; ?> From Attendance?');" name="delete" class="delete-btn"> </form> </div> <?php } }elseif(isset($_POST['search_box']) OR isset($_POST['search_btn'])){ echo '<p class="empty">results not found!</p>'; }else{ echo '<p class="empty">you have no Attendee Yet!</p>'; } ?> </div> </section> <!-- messages section ends --> <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>