D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u166148318
/
public_html
/
admin
/
Filename :
view_objectives.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 `objectives` WHERE id = ?"); $verify_delete->execute([$delete_id]); if($verify_delete->rowCount() > 0){ $delete_bookings = $conn->prepare("DELETE FROM `objectives` WHERE id = ?"); $delete_bookings->execute([$delete_id]); $success_msg[] = 'One objective has been deleted!'; }else{ $warning_msg[] = 'objective 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>Objective</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 Objectives</h1> <form action="" method="POST" class="search-form"> <input type="text" name="search_box" placeholder="search An objective..." 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 `objectives` WHERE w_title LIKE '%{$search_box}%' "); $select_messages->execute(); }else{ $select_messages = $conn->prepare("SELECT * FROM `objectives`"); $select_messages->execute(); } if($select_messages->rowCount() > 0){ while($fetch_messages = $select_messages->fetch(PDO::FETCH_ASSOC)){ ?> <div class="box"> <p>This Is One Of Our Objectives 👇</p> <p>title : <span><?= $fetch_messages['w_title']; ?></span></p> <p>Details : <span><?= $fetch_messages['w_details']; ?></span></p> <form action="" method="POST"> <input type="hidden" name="delete_id" value="<?= $fetch_messages['id']; ?>"> <input type="submit" value="Delete this Objective" onclick="return confirm('Do you want to delete <?= $fetch_messages['w_title']; ?> ?');" 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 Objective!</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>