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-scripts.php

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

// Handle Approve and Decline actions
if (isset($_GET['action']) && isset($_GET['id'])) {
    $file_id = $_GET['id'];
    $action = $_GET['action']; // 'approve' or 'decline'

// Ensure the action is either 'approved' or 'declined'
    if ($action == 'approved' || $action == 'declined') {
        // Update the action column in the database
        $query = "UPDATE media_scripts SET action = '$action' WHERE id = '$file_id'";

if (mysqli_query($conn, $query)) {
            // Redirect to the page after updating the action
            header("Location: media-scripts.php");
            exit;
        } else {
            echo "Error updating file status.";
        }
    }
}

<!doctype html>
<html lang="en">
<head>
    <title>Admin | Media Scripts</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="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center mb-3">
                                        <h2 class="card-title">Media Scripts</h2>
                                        <a href="add-media-script.php" class="btn btn-primary">+ Add Script</a>  
                                    </div>

<table id="datatable" class="table table-bordered dt-responsive nowrap" style="width:100%;">
                                        <thead>
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Title</th>
                                                <th>Scripts Description</th>
                                                <th>File</th>
                                                <th>Reference</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Fetch all records from the media_scripts table
                                            $query = "SELECT * FROM media_scripts ORDER BY id DESC";
                                            $result = mysqli_query($conn, $query);
                                            $serial = 1;

if ($result && mysqli_num_rows($result) > 0) {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    // Limit the description to the first 7 words
                                                    $description = $row['script_desc'];
                                                    $description_words = explode(' ', $description);  // Split the description into words
                                                    $short_desc = implode(' ', array_slice($description_words, 0, 7));  // Get the first 7 words

// Apply color based on the action status
                                                    $status_color = ($row['action'] == 'approved') ? 'green' : 'red';  // Green for approved, red for others

echo "<tr>";
                                                    echo "<td>" . $serial++ . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['title']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($short_desc) . "...</td>";  // Show truncated description
                                                    echo "<td><a href='../uploads/scripts/{$row['script_file']}' target='_blank'>View File</a></td>";
                                                    echo "<td>" . htmlspecialchars($row['reference']) . "</td>";
                                                    echo "<td style='color: $status_color;'>" . ucfirst($row['action']) . "</td>";  // Apply color to status
                                                    echo "<td>
                                                            <a href='media-scripts.php?action=approved&id={$row['id']}' class='btn btn-sm btn-success'>Approve</a>
                                                            <a href='media-scripts.php?action=declined&id={$row['id']}' class='btn btn-sm btn-danger'>Decline</a>
                                                            <a href='view-media-script.php?id={$row['id']}' class='btn btn-sm btn-info'>View</a> 
                                                            <a href='delete-script.php?delete_id={$row['id']}' class='btn btn-sm btn-danger' onclick=\"return confirm('Are you sure you want to delete this script?');\"><i class='fas fa-trash'></i></a>
                                                          </td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='7' class='text-center'>No media scripts 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-scripts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation