Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/admin

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: media-posts.php

<?php 
include('config/db.php');

// Handle Delete action
if (isset($_GET['delete_id'])) {
    $delete_id = $_GET['delete_id'];

// Delete the post from the media_posts table
    $delete_query = "DELETE FROM media_posts WHERE id = '$delete_id'";

if (mysqli_query($conn, $delete_query)) {
        // Redirect to the page after deleting the record
        header("Location: media-posts.php");
        exit;
    } else {
        echo "Error deleting the post: " . mysqli_error($conn);
    }
}

// Fetch all records from the media_posts table
$query = "SELECT * FROM media_posts ORDER BY id DESC";
$result = mysqli_query($conn, $query);

// Check if the query was successful
if (!$result) {
    die('Error executing query: ' . mysqli_error($conn));
}

// Initialize an array to store the fetched data
$posts = [];

// Fetch all rows from the query result and store them in the $posts array
while ($row = mysqli_fetch_assoc($result)) {
    $posts[] = $row;
}

$serial = 1;
?>

<!doctype html>
<html lang="en">
<head>
    <title>Admin | Media Posts</title>
    <?php include('links/head.php'); ?>
    
    
</head>
<body data-sidebar="dark">
    <div id="preloader">
        <div id="status">
            <div class="spinner"></div>
        </div>
    </div>

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center mb-3">
                                <h4 class="card-title">Media Posts</h4>
                                <a href="add-media-post.php" class="btn btn-primary btn-sm">
                                    <i class="fas fa-plus me-1"></i> Add Post
                                </a>
                            </div>

<div class="table-responsive">
                                <table id="media-posts-table" class="table table-bordered dt-responsive nowrap w-100">
                                    <thead>
                                        <tr>
                                            <th>S.No.</th>
                                            <th>Post Name</th>
                                            <th>Caption</th>
                                            <th>File</th>
                                            <th>Platform</th>
                                            <th>Post Date</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        if (count($posts) > 0) {
                                            foreach ($posts as $row) {
                                                echo "<tr>";
                                                echo "<td>" . $serial++ . "</td>";
                                                echo "<td>" . htmlspecialchars($row['post_name']) . "</td>";
                                                echo "<td>" . htmlspecialchars(substr($row['caption'], 0, 50)) . (strlen($row['caption']) > 50 ? '...' : '') . "</td>";
                                                echo "<td><a href='../uploads/posts/{$row['file']}' class='text-primary' target='_blank'><i class='fas fa-eye me-1'></i>View</a></td>";
                                                echo "<td>" . htmlspecialchars($row['platform']) . "</td>";
                                                echo "<td>" . htmlspecialchars($row['post_date']) . "</td>";
                                                echo "<td>
                                                <a href='view-media-post.php?id={$row['id']}' class='btn btn-outline-info btn-sm'><i class='fas fa-eye'></i></a>
                                                        <a href='edit-media-post.php?id={$row['id']}' class='btn btn-outline-warning btn-sm'><i class='fas fa-edit'></i></a>
                                                        <a href='media-posts.php?delete_id={$row['id']}' class='btn btn-outline-danger btn-sm' onclick=\"return confirm('Are you sure you want to delete this post?');\"><i class='fas fa-trash'></i></a>
                                                      </td>";
                                                echo "</tr>";
                                            }
                                        } else {
                                            echo "<tr><td colspan='7' class='text-center'>No media posts found.</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div> 
        </div>
        <?php include('includes/footer.php'); ?>
    </div>
</div>

<?php include('includes/rightbar.php'); ?>
<div class="rightbar-overlay"></div>
<?php include('links/scripts.php'); ?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: media-posts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation