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: viewpro.php

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

// Handle activate/deactivate
if (isset($_GET['toggle']) && is_numeric($_GET['toggle'])) {
    $id = $_GET['toggle'];
    $status = $_GET['status'] == 1 ? 0 : 1;
    mysqli_query($con, "UPDATE products SET status = $status WHERE id = $id");

$_SESSION['msg'] = $status ? "Product activated successfully." : "Product deactivated successfully.";
    header("Location: viewpro.php");
    exit;
}

// Fetch categories for dropdown
$categories = [];
$catRes = mysqli_query($con, "SELECT id, name FROM categories WHERE status = 1 ORDER BY name");
while ($row = mysqli_fetch_assoc($catRes)) {
    $categories[] = $row;
}

$search = isset($_GET['search']) ? mysqli_real_escape_string($con, $_GET['search']) : '';
$category_id = isset($_GET['category_id']) ? (int)$_GET['category_id'] : '';

// Build WHERE clause
$where = [];
if (!empty($search)) {
    $where[] = "p.pro_name LIKE '%$search%'";
}
if ($category_id != '') {
    $where[] = "p.category_id = $category_id";
}

$whereClause = count($where) ? 'WHERE ' . implode(' AND ', $where) : '';

$query = "SELECT p.*, c.name AS cat_name 
          FROM products p 
          LEFT JOIN categories c ON p.category_id = c.id 
          $whereClause 
          ORDER BY p.id DESC";

$result = mysqli_query($con, $query);

include("includes/headermain.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="header-title">Product List</h4>
                        </div>
                    </div>
                </div>

<form method="get" class="row g-2 fw-bold mb-4">
                                <div class="col-md-4">
                                    <label class="form-label">Product Name</label>
                                    <input type="text" name="search" id="search" class="form-control form-control-sm" placeholder="Enter product name" value="<?= htmlspecialchars($search); ?>">
                                </div>
                                <div class="col-md-4">
                                    <label class="form-label">Category</label>
                                    <select name="category_id" class="form-control form-control-sm">
                                        <option value="">All Categories</option>
                                        <?php foreach ($categories as $cat): ?>
                                            <option value="<?= $cat['id'] ?>" <?= ($cat['id'] == $category_id) ? 'selected' : '' ?>>
                                                <?= htmlspecialchars($cat['name']) ?>
                                            </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                <div class="col-md-4 d-flex align-items-end">
                                    <button type="submit" class="btn btn-primary me-2 fw-bold">Search</button>&nbsp;&nbsp;
                                    <a href="viewpro.php" class="btn btn-primary fw-bold">Show All</a>
                                </div>
                            </form>

<div class="single-table">
                                <div class="table-responsive">
                                    <table class="table">
                                        <thead class="text-uppercase bg-primary text-white">
                                            <tr>
                                                <th>Sl.</th>
                                                <th>Date</th>
                                                <th>ProName</th>
                                                <th>Category</th>
                                                <th>Image</th>
                                                <th>Short Description</th>
                                                <th>Full Description</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $sl = 1;
                                            while ($row = mysqli_fetch_assoc($result)):
                                                $isDeactive = $row['status'] == 0;
                                            ?>
                                                <tr<?= $isDeactive ? ' style="background-color:#fdd;"' : '' ?>>
                                                    <td><?= $sl++; ?></td>
                                                    <td><?= date('d-m-Y', strtotime($row['created_at'])); ?></td>
                                                    <td><?= htmlspecialchars($row['pro_name']); ?></td>
                                                    <td><?= htmlspecialchars($row['cat_name']); ?></td>
                                                    <td>
                                                        <div style="display:flex; flex-wrap:wrap; gap:5px; max-width:250px;">
                                                            <?php
                                                            $imgFields = ['image', 'image1', 'image2', 'image3', 'image4', 'image5'];
                                                            foreach ($imgFields as $imgField):
                                                                if (!empty($row[$imgField])): ?>
                                                                    <a href="<?= $row[$imgField]; ?>" target="_blank">
                                                                        <img src="<?= $row[$imgField]; ?>" width="70" height="70" style="object-fit:cover; border:1px solid #ccc; border-radius:4px;">
                                                                    </a>
                                                            <?php endif;
                                                            endforeach;
                                                            ?>
                                                        </div>
                                                    </td>
                                                    
                                                    <td>
                                                        <div style="display:-webkit-box; -webkit-line-clamp:4; -webkit-box-orient:vertical; overflow:hidden;">
                                                            <?= strip_tags($row['discrip']); ?>
                                                        </div>
                                                        <?php if (!empty($row['discrip'])): ?>
                                                            <a href="#" class="read-more-link text-primary" data-bs-toggle="modal" data-bs-target="#readMoreModal" data-content="<?= htmlentities($row['discrip'], ENT_QUOTES, 'UTF-8') ?>">Read More</a>
                                                        <?php endif; ?>
                                                    </td>
                                                    
                                                    <td>
                                                        <div style="display:-webkit-box; -webkit-line-clamp:4; -webkit-box-orient:vertical; overflow:hidden;">
                                                            <?= strip_tags($row['full_discrip']); ?>
                                                        </div>
                                                        <?php if (!empty($row['full_discrip'])): ?>
                                                            <a href="#" class="read-more-link text-primary" data-bs-toggle="modal" data-bs-target="#readMoreModal" data-content="<?= htmlentities($row['full_discrip'], ENT_QUOTES, 'UTF-8') ?>">Read More</a>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <a href="addpro.php?edit=<?= $row['id'] ?>">Edit</a> |
                                                        <a href="viewpro.php?toggle=<?= $row['id']; ?>&status=<?= $row['status'] ?>">
                                                            <?= $isDeactive ? 'Activate' : 'Deactivate' ?>
                                                        </a>
                                                    </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                                <?php if (mysqli_num_rows($result) == 0): ?>
                                                    <tr>
                                                        <td colspan="8" class="text-center">No products found.</td>
                                                    </tr>
                                                <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>

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

<div class="modal fade" id="readMoreModal" tabindex="-1" aria-labelledby="readMoreModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg modal-dialog-scrollable">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="readMoreModalLabel">Full Description</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body" id="readMoreModalContent"></div>
            </div>
        </div>
    </div>

document.querySelectorAll('.read-more-link').forEach(function(link) {
                link.addEventListener('click', function(e) {
                    e.preventDefault();
                    let fullText = this.getAttribute('data-content') || 'No description found.';
                    modalContent.innerHTML = fullText; // render full HTML from CKEditor
                });
            });
        });
    </script>

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

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewpro.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation