관리-도구

편집 파일: all-academics.php

<!DOCTYPE html>
<html lang="en" dir="ltr">

<head>
    <?php include('include/head_admin.php');
    if (isset($_GET['type']) && $_GET['type'] != '') {
        $type = get_safe_value($con, $_GET['type']);
        if ($type == 'status') {
            $operation = get_safe_value($con, $_GET['operation']);
            $id = get_safe_value($con, $_GET['id']);
            if ($operation == 'active') {
                $status = '1';
            } else {
                $status = '0';
            }
            $update_status_sql = "update academics set status='$status' where id='$id'";
            mysqli_query($con, $update_status_sql);
        }

if ($type == 'delete') {
            $id = get_safe_value($con, $_GET['id']);
            $select_sql = "SELECT image FROM academics WHERE id='$id'";
            $result = mysqli_query($con, $select_sql);

if ($result) {
                $row = mysqli_fetch_assoc($result);
                $filename = $row['image'];

// Step 2: Delete record from the database
                $delete_sql = "DELETE FROM academics WHERE id='$id'";
                mysqli_query($con, $delete_sql);

// Step 3: Unlink the image file from the storage
                $uploadsDirectory = '../media/academics/';
                $filePath = $uploadsDirectory . $filename;

// Check if the file exists before attempting to delete it
                if (file_exists($filePath)) {
                    unlink($filePath); // Delete the file
                    echo "academics and image file deleted successfully";
                } else {
                    echo "Image file not found in the storage";
                }
                header('location:all-academics.php');
            }
        }
    }

$sql = "select * from academics ";
    $res = mysqli_query($con, $sql);
    ?>
</head>

<div class="page-wrapper compact-wrapper" id="pageWrapper">
        
        <?php include('include/header_admin.php'); ?>

<div class="page-body-wrapper">
            
            <?php include('include/sidebar_admin.php'); ?>

<div class="page-body">
                
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="card card-table">
                                <div class="card-body">
                                    <div class="title-header option-title">
                                        <h5>All Academics</h5>
                                        <form class="d-inline-flex">
                                            <a href="add-academics.php" class="align-items-center btn btn-theme d-flex">
                                                <i data-feather="plus-square"></i>Add Academics
                                            </a>
                                        </form>
                                    </div>

<div class="table-responsive category-table">
                                        <div>
                                            <table class="table all-package theme-table" id="table_id">
                                                <thead>
                                                    <tr>
                                                        <th>S. No.</th>
                                                        <th>Name</th>
                                                        
                                                        <th>Image</th>
                                                        
                                                        <th>Option</th>
                                                    </tr>
                                                </thead>

</tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php include('include/footer_admin.php'); ?>
            </div>
            
        </div>

</div>

<?php include('include/foot_admin.php'); ?>
</body>

</html>