Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.0.30

User:

u885320773

Directory:

/home/u885320773/domains/sugatu.in/public_html/process

Free Space:

2.65 TB

🔧 Quick Actions

✏️ Editing: getCartDetails.php

<?php
// Function to fetch product details based on product_id
function getProductDetails($productId, $conn) {
    // Modify the query to fetch product details based on $productId
    $query = "SELECT p.id as pid, p.gmain, p.g1, p.ptitle, pc1.cname AS parentCategory, pc2.cname AS subCategory, p.discounterprice, p.mrp 
                FROM products p
                LEFT JOIN productcategory pc1 ON p.parentCategory = pc1.id
                LEFT JOIN productcategory pc2 ON p.subCategory = pc2.id
                WHERE p.id = ?";
    
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $productId); // Assuming $productId is an integer (use "s" for string)
    $stmt->execute();
    $stmt->bind_result($pid, $gmain, $g1, $ptitle, $parentCategory, $subCategory, $discounterprice, $mrp);
    
    // Fetch product details
    if ($stmt->fetch()) {
        // Construct an array with product details
        $productDetails = array(
            'name' => $ptitle,
            'image' => $gmain, // Assuming this column contains image path
            'price' => '₹' . $discounterprice // Modify as needed based on your actual columns
            // Add other product details as needed
        );

// Return product details array
        return $productDetails;
    } else {
        // Return an empty array if no product found (or handle as per your logic)
        return array();
    }

// Close statement (Not needed here if using in multiple queries, close it after everything is done)
    $stmt->close();
}

session_start();
include '../admin/config.php'; // Your database connection file

// Fetch cart details for the current session
$sessionId = session_id();

// Fetch the count of products in the cart for the session
$countQuery = $conn->prepare("SELECT COUNT(*) AS productCount FROM cart WHERE session_id = ?");
$countQuery->bind_param("s", $sessionId);
$countQuery->execute();
$countQuery->bind_result($productCount);
$countQuery->fetch();
$countQuery->close();

// Fetch the cart items for the session
$cartItemsQuery = $conn->prepare("SELECT * FROM cart WHERE session_id = ?");
$cartItemsQuery->bind_param("s", $sessionId);
$cartItemsQuery->execute();

// Bind result variables
$cartItemsQuery->bind_result($id, $session_id, $product_id, $quantity);

// Fetch results into an array
$cartItems = array();
while ($cartItemsQuery->fetch()) {
    $cartItems[] = array(
        'id' => $id,
        'session_id' => $session_id,
        'product_id' => $product_id,
        'quantity' => $quantity
    );
}
$cartItemsQuery->close();

// Prepare an array to hold cart items HTML
$cartItemsHTML = '';

foreach ($cartItems as $row) {
    // Get product details for the current item
    $productDetails = getProductDetails($row['product_id'], $conn);

// Generate HTML for each cart item
    $cartItemsHTML .= '<li>';
    $cartItemsHTML .= '<div class="row">';
    $cartItemsHTML .= '<div class="col-3">';
    $cartItemsHTML .= '<div class="shopping-cart-img">';
    $cartItemsHTML .= '<a href="#"><img alt="Nest" src="admin/assets/imgs/products/' . $productDetails['image'] . '" /></a>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '<div class="col-8">';
    $cartItemsHTML .= '<div class="shopping-cart-title">';
    $cartItemsHTML .= '<h4><a href="#">' . $productDetails['name'] . '</a></h4>';
    $cartItemsHTML .= '<h4><span>' . $row['quantity'] . ' × </span>' . $productDetails['price'] . '</h4>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '<div class="col-1">';
    $cartItemsHTML .= '<div class="shopping-cart-delete">';
    $cartItemsHTML .= '<a href="#" class="delete-from-cart" data-product-id="' . $row['product_id'] . '"><i class="fi-rs-cross-small"></i></a>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '</div>';
    $cartItemsHTML .= '</li>';
}

// Create an array to hold the data to be returned
$response = [
    'productCount' => $productCount,
    'cartItemsHTML' => $cartItemsHTML
];

// Return JSON response
header('Content-Type: application/json');
echo json_encode($response);

// Close connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: getCartDetails.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation