1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / www /
Filename : download-product.php
back
<?php
session_start();
include('include/connect.php');

// Get the product slug from the URL
$product_slug = isset($_GET['product']) ? $_GET['product'] : '';

// Fetch product details from the database
$sql = "SELECT * FROM product WHERE product_slug = ?";
$stmt = $con->prepare($sql);
$stmt->bind_param("s", $product_slug);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $product = $result->fetch_assoc();

    // Sanitize product name to be used in filename
    $safe_product_name = preg_replace("/[^a-zA-Z0-9-_]/", "_", $product['product_name']); // Replace non-alphanumeric characters

    // Set headers to force download of the text file with the product name
    header('Content-Type: text/plain');
    header('Content-Disposition: attachment; filename="' . $safe_product_name . '-details.txt"');

    // Function to convert HTML to plain text, preserving line breaks
    function convertHtmlToPlainText($html) {
        // Remove HTML tags and convert <br> to new lines
        $html = strip_tags($html); // Remove all HTML tags
        $html = preg_replace("/<br\s*\/?>/", "\n", $html); // Replace <br> tags with new lines
        $html = preg_replace("/\r\n|\r|\n/", "\n", $html); // Normalize line breaks
        return $html;
    }

    // Prepare the content to be written to the text file
    $product_details = "Product Details:\n\n";
    $product_details .= "Product Name: " . $product['product_name'] . "\n";
    $product_details .= "Product Description: " . convertHtmlToPlainText($product['product_description']) . "\n";
    $product_details .= "Product Specification: " . convertHtmlToPlainText($product['product_specification']) . "\n";
    $product_details .= "Product Selling Price: " . $product['product_selling_price'] . "\n";
    $product_details .= "Product Status: " . $product['product_status'] . "\n";

    // Output the product details to be downloaded
    echo $product_details;
} else {
    echo "Product not found.";
}

// Close the database connection
$con->close();
?>