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

<?php
require 'header.php';
$name = '';
$color = '';
$details = mysqli_query($conn, "SELECT * FROM product WHERE latest_arrival_position_no is not null");
$products = mysqli_fetch_all($details, MYSQLI_ASSOC);
if (isset($_POST['submit'])) {
    $pos = $_POST['position'];
    $name = $_POST['name'];
    $color = $_POST['color'];

if ($pos === "last") {
        // Set product to the last position without affecting other products
        $maxPositionQuery = mysqli_query($conn, "SELECT MAX(latest_arrival_position_no) as max_position FROM product");
        $maxPosition = mysqli_fetch_assoc($maxPositionQuery)['max_position'] + 1;

$updateQuery = mysqli_query($conn, "UPDATE product SET latest_arrival_position_no = $maxPosition WHERE name = '$name' AND color = '$color'");
    } else {
        // Increment positions at or after the selected position by +1
        mysqli_query($conn, "UPDATE product SET latest_arrival_position_no = latest_arrival_position_no + 1 WHERE latest_arrival_position_no > $pos");

// Update selected product's position
        $updateQuery = mysqli_query($conn, "UPDATE product SET latest_arrival_position_no = $pos WHERE name = '$name' AND color = '$color'");
    }

if ($updateQuery) {
        $msg = '<div class="alert alert-primary alert-dismissible fade show" role="alert">
                    Latest arrival added Successfully.
                    </div>';
        echo "<script>setTimeout(function(){ window.location = 'latestarrivalslist.php'; },2000);</script>";
    } else {
        $msg = '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                    Error! Please try again...
                    </div>';
        echo "<script>setTimeout(function(){ window.location = 'latestarrivalslist.php'; },2000);</script>";
    }
} else {
    $msg11 = "Error!! Could Not Add";
}
?>
<main role="main" class="main-content">
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-12">
                <h2 class="page-title">Add Product To Latest Arrivals</h2>

<div class="col-md-12">
                        <div class="card shadow mb-4">
                            <div class="card-header">
                                <a href="latestarrivalslist.php" class="btn btn-primary float-right ml-3" type="button"><i class="fe fe-arrow-left "></i>Latest Arrivals List</a>

</div>
                            <div class="card-body">
                                <form method="POST">
                                    <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 class="col-md-4 mb-4">
                                            <label for="color" class="form-label">Color</label>
                                            <input type="text" class="form-control" name="color" id="color" placeholder="Enter Color Name" value="<?php echo htmlspecialchars($color); ?>">
                                        </div>
                                        <div class="col-md-4 mb-4">
                                            <label for="position" class="form-label">Position</label>
                                            <select class="custom-select" name="position" id="position">
                                                <option value="">Select Position</option>
                                                <option value="1">At First</option>
                                                <?php foreach ($products as $product): ?>
                                                    <option value="<?php echo $product['latest_arrival_position_no'] + 1; ?>">
                                                        <?php echo htmlspecialchars($product['name']); ?> (After Position <?php echo $product['latest_arrival_position_no']; ?>)
                                                    </option>
                                                <?php endforeach; ?>
                                                <option value="last">Last Position</option>
                                            </select>
                                        </div>
                                    </div>
                                    <button class="btn btn-primary" name="submit" type="submit">Submit form</button>
                                </form>
                            </div> 
                        </div> 
                    </div> 
                </div> 
            </div> 
        </div> 
    </div>

</main>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addlatestarrivals.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation