Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/domains/allspikes.in/public_html/admin

Free Space:

2 TB

🔧 Quick Actions

✏️ Editing: enquiry_page.php

<?php
require 'config.php';
require 'header.php';

function fetchDistinctValues($column, $condition = '')
{
    global $con;
    $query = "SELECT DISTINCT $column FROM inventory WHERE status = 'In Stock'";
    if ($condition) {
        $query .= " AND $condition";
    }
    $query .= " ORDER BY $column";
    $result = mysqli_query($con, $query);

$values = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $values[] = $row[$column];
    }

return $values;
}

// Initialize variables to store selected values
$size = $model = $event = $color = $brand = $status = $name = '';

// Handle form submission
$filteredResults = [];
$colors = [];
$models = [];
$brands = [];
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $size = mysqli_real_escape_string($con, $_POST['size'] ?? '');
    $model = mysqli_real_escape_string($con, $_POST['model'] ?? '');
    $event = mysqli_real_escape_string($con, $_POST['event'] ?? '');
    $color = mysqli_real_escape_string($con, $_POST['colour'] ?? '');
    $brand = mysqli_real_escape_string($con, $_POST['brand'] ?? '');
    $name = mysqli_real_escape_string($con, $_POST['name'] ?? '');

// Fetch colors based on selected event
    
    if ($event) {
        $conditions = "event = '$event' AND status = 'In Stock'";
        $colors = fetchDistinctValues('colour', $conditions);
        $models = fetchDistinctValues('model', $conditions);
        $brands = fetchDistinctValues('brand', $conditions);
    }

// Build the query based on selected filters
    $conditions = [];
    if ($size) $conditions[] = "size = '$size'";
    if ($model) $conditions[] = "model = '$model'";
    if ($event) $conditions[] = "event = '$event'";
    if ($color) $conditions[] = "colour = '$color'";
    if ($brand) $conditions[] = "brand = '$brand'";
    if ($name) $conditions[] = "model LIKE '%$name%'";

$query = "SELECT * FROM inventory WHERE status = 'In Stock'";
    if ($conditions) {
        $query .= " AND " . implode(' AND ', $conditions);
    }

$result = mysqli_query($con, $query);
    while ($row = mysqli_fetch_assoc($result)) {
        $filteredResults[] = $row;
    }
}
?>

<main role="main" class="main-content">
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-12">
                <h2 class="page-title">Product Enquiry</h2>
                <div class="row">
                    <div class="col-md-12">
                        <div class="card shadow mb-4">
                            <div class="card-header">
                                <strong class="card-title">Search Products</strong>
                            </div>
                            <div class="card-body">
                                <form method="POST" id="search-form">
                                    <div class="form-row">
                                        <div class="col-md-4 mb-4">
                                            <label for="name" class="form-label">Shoe Name</label>
                                            <input type="text" class="form-control" name="name" id="name" placeholder="Enter Shoe Name" value="<?php echo htmlspecialchars($name); ?>">
                                        </div>
                                    </div>
                                    <div class="form-row">
                                        <div class="col-md-4 mb-4">
                                            <label for="event" class="form-label">Event</label>
                                            <select class="custom-select" name="event" id="event">
                                                <option value="">Select Event</option>
                                                <?php
                                                $events = fetchDistinctValues('event');
                                                foreach ($events as $item) {
                                                    $selected = ($item === $event) ? 'selected' : '';
                                                    echo "<option value=\"$item\" $selected>$item</option>";
                                                }
                                                ?>
                                            </select>
                                        </div>
                                        <div class="col-md-4 mb-4">
                                            <label for="size" class="form-label">Size</label>
                                            <select class="custom-select" name="size" id="size">
                                                <option value="">Select Size</option>
                                                <?php
                                                $sizes = fetchDistinctValues('size');
                                                foreach ($sizes as $item) {
                                                    $selected = ($item === $size) ? 'selected' : '';
                                                    echo "<option value=\"$item\" $selected>$item</option>";
                                                }
                                                ?>
                                            </select>
                                        </div>
                                        <div class="col-md-4 mb-4">
                                            <label for="model" class="form-label">Model</label>
                                            <select class="custom-select" name="model" id="model">
                                                <option value="">Select Model</option>
                                                <?php
                                                foreach ($models as $item) {
                                                    $selected = ($item === $model) ? 'selected' : '';
                                                    echo "<option value=\"$item\" $selected>$item</option>";
                                                }
                                                ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="form-row">
                                        <div class="col-md-4 mb-4">
                                            <label for="colour" class="form-label">Colour</label>
                                            <select class="custom-select" name="colour" id="colour">
                                                <option value="">Select Colour</option>
                                                <?php
                                                foreach ($colors as $item) {
                                                    $selected = ($item === $color) ? 'selected' : '';
                                                    echo "<option value=\"$item\" $selected>$item</option>";
                                                }
                                                ?>
                                            </select>
                                        </div>
                                        <div class="col-md-4 mb-4">
                                            <label for="brand" class="form-label">Brand</label>
                                            <select class="custom-select" name="brand" id="brand">
                                                <option value="">Select Brand</option>
                                                <?php
                                                foreach ($brands as $item) {
                                                    $selected = ($item === $brand) ? 'selected' : '';
                                                    echo "<option value=\"$item\" $selected>$item</option>";
                                                }
                                                ?>
                                            </select>
                                        </div>
                                    </div>
                                </form>

<?php if ($filteredResults): ?>
                                    <h2 class="text-center my-4">Total : <?php echo count($filteredResults); ?> Items</h2>
                                    <table class="table table-bordered table-striped">
                                        <thead class="thead-dark">
                                            <tr>
                                                <th>SNo.</th>
                                                <th>Brand</th>
                                                <th>Event</th>
                                                <th>Product ID</th>
                                                <th>Article No</th>
                                                <th>Model</th>
                                                <th>Colour</th>
                                                <th>Size</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($filteredResults as $key => $row): ?>
                                                <tr>
                                                    <td><?php echo ++$key; ?></td>
                                                    <td><?php echo htmlspecialchars($row['brand']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['event']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['product_id']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['article_no']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['model']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['colour']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['size']); ?></td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                <?php elseif ($_SERVER['REQUEST_METHOD'] == 'POST'): ?>
                                    <div class="alert alert-info" role="alert">
                                        No results found for your query.
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>

<?php require 'footer.php'; ?>

selects.forEach(select => {
            select.addEventListener('change', function() {
                if (this.id === 'event' || this.id === 'brand') {
                    colorSelect.selectedIndex = 0;
                    modelSelect.selectedIndex = 0;
                }else if(this.id === 'model'){
                    colorSelect.selectedIndex = 0;
                    brandSelect.selectedIndex = 0;
                }
                nameInput.value='';
                form.submit();
            });
        });
        
        let typingTimer;
        const typingInterval = 3000; // 3 seconds

// Event listener for the input box
        nameInput.addEventListener('input', function() {
            clearTimeout(typingTimer); // Clear the previous timer
    
            // Immediately reset all dropdowns to default when typing starts
            form.querySelectorAll('select').forEach(select => {
                select.selectedIndex = 0; // Reset all selects to default
            });
    
            // Start the typing timer before form submission
            typingTimer = setTimeout(function() {
                form.submit(); // Submit the form after typing has stopped for 3 seconds
            }, typingInterval);
        });
    });
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: enquiry_page.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation