1#@!#!123s

: / home / u193541357 / domains / racysanitaryware.com / public_html / dev / admin /
Filename : submit-product(30012025).php
back
<?php
include('../db.php');

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $id = isset($_POST['id']) ? $_POST['id'] : ''; // Get the product ID, if provided
    $category_id = $conn->real_escape_string($_POST['category_id']);
    $product_name = $conn->real_escape_string($_POST['product_name']);
    $product_codeno1 = $conn->real_escape_string($_POST['product_codeno1']);
    $product_desc1 = $conn->real_escape_string($_POST['product_desc1']);
    $product_codeno2 = $conn->real_escape_string($_POST['product_codeno2']);
    $product_desc2 = $conn->real_escape_string($_POST['product_desc2']);
    $product_codeno3 = $conn->real_escape_string($_POST['product_codeno3']);
    $product_desc3 = $conn->real_escape_string($_POST['product_desc3']);
    $product_description = $conn->real_escape_string($_POST['product_description']);
    $product_extra_description = $conn->real_escape_string($_POST['product_extra_description']);
    $product_icons = isset($_POST['product_icons']) ? implode(',', $_POST['product_icons']) : null;

    // Generate the product slug
    $product_slug = strtolower(str_replace(' ', '-', $product_name));

    // Define the base directory for images
    $baseDir = "img/products/";

    // Check if the base directory exists, if not, create it
    if (!is_dir($baseDir)) {
        mkdir($baseDir, 0777, true);
    }

    // Handle product image upload
    $product_image = '';
    if (isset($_FILES['product_image']) && $_FILES['product_image']['error'] === UPLOAD_ERR_OK) {
        $fileName = basename($_FILES['product_image']['name']);
        $targetFilePath = $baseDir . time() . "_product_" . $fileName;

        if (move_uploaded_file($_FILES['product_image']['tmp_name'], $targetFilePath)) {
            $product_image = $targetFilePath;
        } else {
            die("Error uploading product image.");
        }
    }

    // Handle product drawing upload
    $product_drawing = '';
    if (isset($_FILES['product_drawing']) && $_FILES['product_drawing']['error'] === UPLOAD_ERR_OK) {
        $fileName = basename($_FILES['product_drawing']['name']);
        $targetFilePath = $baseDir . time() . "_drawing_" . $fileName;

        if (move_uploaded_file($_FILES['product_drawing']['tmp_name'], $targetFilePath)) {
            $product_drawing = $targetFilePath;
        } else {
            die("Error uploading product drawing.");
        }
    }

    // If updating and no new images are uploaded, retain the existing images
    if (!empty($id)) {
        $sql = "SELECT product_image, product_drawing FROM products WHERE id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param('i', $id);
        $stmt->execute();
        $result = $stmt->get_result();
        $row = $result->fetch_assoc();

        if (empty($product_image)) $product_image = $row['product_image'];
        if (empty($product_drawing)) $product_drawing = $row['product_drawing'];

        $stmt->close();
    }


    if (!empty($id)) {
        // Update the existing product (no need to include 'id' in the INSERT statement)
        $sql = "UPDATE products SET category_id = ?, product_name = ?, product_slug = ?, product_codeno1 = ?, product_desc1 = ?, product_codeno2 = ?, product_desc2 = ?, product_codeno3 = ?, product_desc3 = ?, product_description = ?, product_image = ?, product_drawing = ?, product_extra_description = ?, product_icon_ids = ?, status = 1 WHERE id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param(
            'isssssssssssssi',
            $category_id,
            $product_name,
            $product_slug,
            $product_codeno1,
            $product_desc1,
            $product_codeno2,
            $product_desc2,
            $product_codeno3,
            $product_desc3,
            $product_description,
            $product_image,
            $product_drawing,
            $product_extra_description,
            $product_icons,
            $id
        );

        if ($stmt->execute()) {
            header("Location: view-product.php");
            exit();
        } else {
            echo "Error: " . $stmt->error;
        }
    } else {
        // Insert a new product (no 'id' provided in the form, and it will auto-increment)
        $sql = "INSERT INTO products (category_id, product_name, product_slug, product_codeno1, product_desc1, product_codeno2, product_desc2, product_codeno3, product_desc3, product_description, product_image, product_drawing, product_extra_description, product_icon_ids, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 1)";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param('isssssssssssss', $category_id, $product_name, $product_slug, $product_codeno1, $product_desc1, $product_codeno2, $product_desc2, $product_codeno3, $product_desc3, $product_description, $product_image, $product_drawing, $product_extra_description, $product_icons);

        if ($stmt->execute()) {
            echo "Product added successfully!";
        } else {
            echo "Error: " . $stmt->error;
        }
    }

    $stmt->close();
    $conn->close();

    // Redirect to the product view page
    header("Location: view-product.php");
    exit();
}