1#@!#!123s

: / home3 / encodto1 / tresboutique.in / tresadmin /
Filename : add_product.php
back
<?php
include 'config.php';

$query = "SELECT product_category_id, product_category_name FROM product_category";
$result = mysqli_query($conn, $query);

// Check if categories were fetched
if (mysqli_num_rows($result) > 0) {
    $categories = mysqli_fetch_all($result, MYSQLI_ASSOC);
} else {
    $categories = [];
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $product_name = mysqli_real_escape_string($conn, $_POST['product_name']);
    $product_price = mysqli_real_escape_string($conn, $_POST['product_price']);
    $product_desc = mysqli_real_escape_string($conn, $_POST['product_desc']);
    $product_size = mysqli_real_escape_string($conn, $_POST['product_size']);
    $product_fabrics = mysqli_real_escape_string($conn, $_POST['product_fabrics']); // Changed to fabrics
    $product_occassion = mysqli_real_escape_string($conn, $_POST['product_occassion']);
    $product_category = mysqli_real_escape_string($conn, $_POST['product_category']);
    $product_sku = mysqli_real_escape_string($conn, $_POST['product_sku']);
    $fabrics = mysqli_real_escape_string($conn, $_POST['fabrics']);
    $product_status = mysqli_real_escape_string($conn, $_POST['product_status']);
    $trending = isset($_POST['trending']) ? 1 : 0;  // Check if 'trending' checkbox is selected
    $featured = isset($_POST['featured']) ? 1 : 0;  // Check if 'popular' checkbox is selected

    $created_at = date('Y-m-d H:i:s');

    // Handle image uploads
    $imageFields = ['product_img_1', 'product_img_2', 'product_img_3', 'product_img_4', 'product_img_5', 'product_img_6'];
    $uploadedImages = [];

    foreach ($imageFields as $field) {
        if (!empty($_FILES[$field]['name'])) {
            $targetDir = "uploads/products/";
            $fileName = basename($_FILES[$field]['name']);
            $targetFilePath = $targetDir . $fileName;

            // Check if the file is an image (optional validation)
            $check = getimagesize($_FILES[$field]['tmp_name']);
            if ($check === false) {
                echo '<script>alert("File is not an image for ' . $field . '");</script>';
                continue;  // Skip this file
            }

            // Check file size (optional)
            if ($_FILES[$field]['size'] > 5000000) { // 5MB limit
                echo '<script>alert("File is too large for ' . $field . '");</script>';
                continue;  // Skip this file
            }

            // Move uploaded file to the target directory
            if (move_uploaded_file($_FILES[$field]['tmp_name'], $targetFilePath)) {
                $uploadedImages[$field] = $fileName;
            } else {
                echo '<script>alert("Error uploading ' . $field . '");</script>';
                $uploadedImages[$field] = null;  // Handle failure
            }
        } else {
            $uploadedImages[$field] = null;  // If no file was uploaded
        }
    }

    // Insert product into database
    $query = "INSERT INTO products (product_name, product_price, product_desc, product_size, fabrics, product_occassion, product_category, 
                product_img_1, product_img_2, product_img_3, product_img_4, product_img_5, product_img_6, product_sku, featured, trending, product_status, created_at) 
              VALUES ('$product_name', '$product_price', '$product_desc', '$product_size', '$fabrics', '$product_occassion', '$product_category',
                      '{$uploadedImages['product_img_1']}', '{$uploadedImages['product_img_2']}', '{$uploadedImages['product_img_3']}',
                      '{$uploadedImages['product_img_4']}', '{$uploadedImages['product_img_5']}', '{$uploadedImages['product_img_6']}',
                      '$product_sku', '$featured', '$trending', '$product_status', '$created_at')";

    if (mysqli_query($conn, $query)) {
        echo '<script>alert("Product added successfully."); window.location.href = "products.php";</script>';
    } else {
        echo '<script>alert("Error adding product: ' . mysqli_error($conn) . '");</script>';
    }
}
?>


<!DOCTYPE html>
<html lang="en">

<head>
    <?php require('style.php'); ?>
</head>

<body>
    <div class="page-wrapper compact-wrapper" id="pageWrapper">
        <div class="page-body-wrapper">
            <?php require('sidebar.php'); ?>

            <div class="page-body">
                <div class="container-fluid">
                    <div class="page-title">
                        <h3>Add Product</h3>
                    </div>
                    <div class="container">
                        <form method="POST" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <label for="product_name" class="form-label">Product Name</label>
                                        <input type="text" name="product_name" id="product_name" class="form-control" required>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_price" class="form-label">Product Price</label>
                                        <input type="number" name="product_price" id="product_price" class="form-control" required>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_desc" class="form-label">Product Description</label>
                                        <textarea name="product_desc" id="product_desc" class="form-control" required></textarea>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_size" class="form-label">Product Size</label>
                                        <input type="text" name="product_size" id="product_size" class="form-control">
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_fabrics" class="form-label">Fabrics</label>
                                        <input type="text" name="fabrics" id="product_fabrics" class="form-control" placeholder="Cotton, Silk, Wool" required>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_occassion" class="form-label">Occasion</label>
                                        <select name="product_occassion" id="product_occassion" class="form-control">
                                            <option value="Wedding">Wedding</option>
                                            <option value="Sangeet">Sangeet</option>
                                            <option value="Haldi">Haldi</option>
                                        </select>
                                    </div>

                                </div>
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <label>Product Category</label>
                                        <select class="form-control" name="product_category" required>
                                            <option value="">Select Category</option>
                                            <?php foreach ($categories as $category) { ?>
                                                <option value="<?php echo $category['product_category_id']; ?>">
                                                    <?php echo $category['product_category_name']; ?>
                                                </option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_sku" class="form-label">SKU</label>
                                        <input type="text" name="product_sku" id="product_sku" class="form-control">
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_status" class="form-label">Status</label>
                                        <select name="product_status" id="product_status" class="form-control">
                                            <option value="Active">Active</option>
                                            <option value="Inactive">Inactive</option>
                                        </select>
                                    </div>
                                    <div class="mb-3">
                                        <label for="trending" class="form-label">Trending</label>
                                        <input type="checkbox" name="trending" id="trending" value="1" class="form-check-input">
                                    </div>
                                    <div class="mb-3">
                                        <label for="featured" class="form-label">Featured</label>
                                        <input type="checkbox" name="featured" id="featured" value="1" class="form-check-input">
                                    </div>
                                    <?php for ($i = 1; $i <= 6; $i++): ?>
                                        <div class="mb-3">
                                            <label for="product_img_<?= $i ?>" class="form-label">Product Image <?= $i ?></label>
                                            <input type="file" name="product_img_<?= $i ?>" id="product_img_<?= $i ?>" class="form-control">
                                        </div>
                                    <?php endfor; ?>
                                </div>
                            </div>
                            <button type="submit" class="btn btn-primary">Add Product</button>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php require('footer.php'); ?>
</body>

</html>