Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/rprajaenterprises.com/public_html/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewblogs.php

<?php
ob_start();
session_start();
include("includes/inall.php");

// Toggle status
if (isset($_GET['toggle']) && is_numeric($_GET['toggle'])) {
    $id = $_GET['toggle'];
    $status = $_GET['status'] == 1 ? 0 : 1;
    mysqli_query($con, "UPDATE posts SET status = $status WHERE id = $id");
    $_SESSION['msg'] = "Blog status updated.";
    header("Location: viewblogs.php");
    exit;
}

// Delete blog
if (isset($_GET['delete']) && is_numeric($_GET['delete'])) {
    $id = $_GET['delete'];
    mysqli_query($con, "DELETE FROM posts WHERE id = $id");
    $_SESSION['msg'] = "Blog deleted successfully.";
    header("Location: viewblogs.php");
    exit;
}

// Filter date
$from = $_GET['from'] ?? '';
$to = $_GET['to'] ?? '';
$where = "";

if (!empty($from) && !empty($to)) {
    $where = "WHERE DATE(created_at) BETWEEN '$from' AND '$to'";
}

// Pagination
$limit = 10;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;

$totalRes = mysqli_query($con, "SELECT COUNT(*) as total FROM posts $where");
$totalRow = mysqli_fetch_assoc($totalRes);
$totalBlogs = $totalRow['total'];
$totalPages = ceil($totalBlogs / $limit);

$res = mysqli_query($con, "SELECT * FROM posts $where ORDER BY created_at DESC LIMIT $offset, $limit");

include("includes/headermain.php");
?>

<body>
    
    
    <div id="preloader">
        <div class="loader"></div>
    </div>
    
    
    <div class="page-container">
        
        <?php include("includes/leftmenu.php"); ?>
        
        
        <div class="main-content">
            
            <?php include("includes/header.php"); ?>
            
            <div class="main-content-innera">
                <div class="page-breadcrumb">
                    <div class="row">
                        <div class="col-12 d-flex no-block align-items-center">
                            <h4 class="mb-3">View Blogs</h4>
                        </div>
                    </div>
                </div>

<?php if (!empty($_SESSION['msg'])): ?>
                                <div class="alert alert-success"><?= $_SESSION['msg'];
                                                                    unset($_SESSION['msg']); ?></div>
                            <?php endif; ?>

<form method="get" class="form-row mb-4">
                                <div class="form-group col-md-3">
                                    <label for="from">From:</label>
                                    <input type="date" name="from" id="from" value="<?= htmlspecialchars($from) ?>" class="form-control">
                                </div>
                                <div class="form-group col-md-3">
                                    <label for="to">To:</label>
                                    <input type="date" name="to" id="to" value="<?= htmlspecialchars($to) ?>" class="form-control">
                                </div>
                                <div class="form-group col-md-3 d-flex align-items-end">
                                    <div>
                                        <button type="submit" class="btn btn-primary">Search</button>
                                        <a href="viewblogs.php" class="btn btn-secondary ml-2">Show All</a>
                                    </div>
                                </div>
                            </form>

<div class="card">
                                <div class="table-responsive">
                                    <table class="table">
                                        <thead class="text-uppercase bg-primary">
                                            <tr class="text-white">
                                                <th align="left">Sl.</th>
                                                <th align="left">Date</th>
                                                <th align="left">Image</th>
                                                <th align="left">Title</th>
                                                <th align="left">Content</th>
                                                <th align="left">Status</th>
                                                <th align="left">Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $sl = $offset;
                                            while ($row = mysqli_fetch_assoc($res)):
                                                $sl++;
                                                $image = !empty($row['image']) ? $row['image'] : "assets/images/default-blog.jpg";
                                                $title = htmlspecialchars($row['title'], ENT_QUOTES);
                                                $content = htmlspecialchars($row['content'], ENT_QUOTES);
                                                $statusText = $row['status'] == 1 ? "Active" : "Inactive";
                                                $statusClass = $row['status'] == 0 ? 'style="background-color:#ffe6e6;"' : '';
                                            ?>
                                                <tr <?= $statusClass ?>>
                                                    <td align="left"><?= $sl ?></td>
                                                    <td align="left"><?= date("d-m-Y", strtotime($row['created_at'])) ?></td>
                                                    <td align="left"><img src="<?= $image ?>" width="80" height="60" style="object-fit:cover;"></td>
                                                    <td align="left"><?= $title ?></td>
                                                    <td align="left">
                                                        <?= substr(strip_tags($row['content']), 0, 60) ?>...
                                                        <a href="javascript:void(0)" onclick="openModal('<?= $title ?>', `<?= $content ?>`)">Read More</a>
                                                    </td>
                                                    <td align="left">
                                                        <a href="addblog.php?edit=<?= $row['id'] ?>">Edit</a>&nbsp;|
                                                        <a href="?delete=<?= $row['id'] ?>" onclick="return confirm('Are you sure?')">Delete</a>&nbsp;|
                                                        <a href="?toggle=<?= $row['id'] ?>&status=<?= $row['status'] ?>">
                                                            <?= $row['status'] == 1 ? "Deactivate" : "Activate" ?>
                                                        </a>
                                                    </td>
                                                </tr>
                                            <?php endwhile; ?>
                                            <?php if ($sl == $offset): ?>
                                                <tr>
                                                    <td colspan="7" class="text-center">No blogs found.</td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>

<nav>
                                        <ul class="pagination justify-content-center">
                                            <?php for ($i = 1; $i <= $totalPages; $i++): ?>
                                                <li class="page-item <?= $i == $page ? 'active' : '' ?>">
                                                    <a class="page-link" href="?page=<?= $i ?>&from=<?= $from ?>&to=<?= $to ?>"><?= $i ?></a>
                                                </li>
                                            <?php endfor; ?>
                                        </ul>
                                    </nav>
                                </div>
                            </div>

</div>
                    </div>
                </div>
            </div>

<div class="modal fade" id="readMoreModal" tabindex="-1" role="dialog" aria-labelledby="readMoreLabel" aria-hidden="true">
                <div class="modal-dialog modal-lg" role="document">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="readMoreTitle"></h5>
                            <button type="button" class="close" data-dismiss="modal"><span>&times;</span></button>
                        </div>
                        <div class="modal-body" id="readMoreContent"></div>
                    </div>
                </div>
            </div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
            <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.bundle.min.js"></script>

<script>
                function openModal(title, content) {
                    document.getElementById('readMoreTitle').innerText = title;
                    document.getElementById('readMoreContent').innerHTML = content;
                    $('#readMoreModal').modal('show');
                }
            </script>

<?php include("includes/footer.php"); ?>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewblogs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation