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

<?php
require 'header.php';

if (isset($_GET['id'])) {
    $pid = $_GET['id'];

// Retrieve the current position of the product being deleted
    $positionQuery = mysqli_query($conn, "SELECT latest_arrival_position_no FROM product WHERE id = '$pid'");
    $positionData = mysqli_fetch_assoc($positionQuery);
    $currentPosition = $positionData['latest_arrival_position_no'];

// Set the product's position to NULL
    $delete = mysqli_query($conn, "UPDATE product SET latest_arrival_position_no = NULL WHERE id = '$pid'");

if ($delete) {
        // Decrement the positions of other products that have a position greater than the removed one
        mysqli_query($conn, "UPDATE product SET latest_arrival_position_no = latest_arrival_position_no - 1 WHERE latest_arrival_position_no > $currentPosition");

echo "<script>window.location.assign('latestarrivalslist.php');</script>";
    } else {
        echo "<script>alert('Error! Please try again.'); window.location.assign('latestarrivalslist.php');</script>";
    }
}
?>
<main role="main" class="main-content">
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-12">
                <h2 class="mb-2 page-title" style="display:inline;">Manage Latest Arrivals</h2>
                <a href="addlatestarrivals.php" class="btn btn-primary float-right ml-3" type="button">Add more <i class="fe fe-plus fe-16"></i></a>
                <div class="row my-4">
                    
                    <div class="col-md-12">
                        <div class="card shadow">
                            <div class="card-body">

<table class="table datatables" id="dataTable-1">
                                    <thead>
                                        <tr>
                                            <th>Sr.No.</th>
                                            <th>Image</th>
                                            <th>Name</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php $selecttest = mysqli_query($conn, "SELECT * FROM product WHERE status = '1' AND latest_arrival_position_no is not null Order By latest_arrival_position_no asc");
                                        $i = 1;
                                        while ($fetchtest = mysqli_fetch_array($selecttest)) {

?>
                                            <tr>
                                                <td><?php echo $i; ?></td>
                                                <td>
                                                    <?php
                                                    $image = explode(",", $fetchtest['image']);
                                                    foreach ($image as $img) {
                                                    ?>
                                                        <img src="image/<?php echo $img; ?>" width="80px">

<?php break;
                                                    } ?>
                                                </td>
                                                <td><?php echo $fetchtest['name']; ?></td>
                                                <td>
                                                    <a class="btn mb-2 btn-info" href="editbrands.php?pid=<?php echo $fetchtest['id']; ?>">Edit</a>
                                                    <a class="btn mb-2 btn-danger" href="latestarrivalslist.php?id=<?php echo $fetchtest['id']; ?>&status=2">Remove</a>
                                                </td>

</tr>
                                        <?php $i++;
                                        } ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div> 
                </div> 
            </div> 
        </div> 
    </div>

</main>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: latestarrivalslist.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation