File "get_product_details.php"

Full path: /home/atrmarke/public_html/atrdemolive.site/bshop/log/qrcodes/get_product_details.php
File size: 1.08 KB B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
include("db/cn.php");

if(isset($_POST['product_id'])) {
    $productId = $_POST['product_id'];

    // Fetch product details from the database
    $product_query = "SELECT * FROM products WHERE product_id = $productId";
    $product_result = $connection->query($product_query);

    if ($product_result->num_rows > 0) {
        $row = $product_result->fetch_assoc();
        // Prepare HTML to display product details
        $productDetails = '<p><strong>Name:</strong> ' . $row["name"] . '</p>' .
                          '<p><strong>Supplier:</strong> ' . $row["supplier_name"] . '</p>' .
                          '<p><strong>Batch:</strong> ' . $row["batch_no"] . '</p>' .
                          '<p><strong>Expiry:</strong> ' . $row["expiry"] . '</p>' .
                          '<p><strong>Rack No:</strong> ' . $row["rack_no"] . '</p>' .
                          '<p><strong>Price:</strong> Rs ' . $row["price"] . ' /-</p>';
        echo $productDetails;
    } else {
        echo "Product not found";
    }
} else {
    echo "Product ID not provided";
}
?>