Tiny File Manager

Back Back Up Advanced Editor

<?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 = 'Name: ' . $row["name"] . '' .
 'Supplier: ' . $row["supplier_name"] . '' .
 'Batch: ' . $row["batch_no"] . '' .
 'Expiry: ' . $row["expiry"] . '' .
 'Rack No: ' . $row["rack_no"] . '' .
 'Price: Rs ' . $row["price"] . ' /-';
 echo $productDetails;
 } else {
 echo "Product not found";
 }
} else {
 echo "Product ID not provided";
}
?>