D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
slg.encodersunlimited.com
/
slgadmintoys
/
Filename :
add_product.php
back
Copy
<?php include 'config.php'; if ($_SERVER["REQUEST_METHOD"] == "POST") { $name = mysqli_real_escape_string($conn, $_POST['name']); $age_category = mysqli_real_escape_string($conn, $_POST['age_category']); $size = mysqli_real_escape_string($conn, $_POST['size']); $weight = mysqli_real_escape_string($conn, $_POST['weight']); $material = mysqli_real_escape_string($conn, $_POST['material']); $category_id = mysqli_real_escape_string($conn, $_POST['category_id']); $price = mysqli_real_escape_string($conn, $_POST['price']); // New Price Field $colors = isset($_POST['colors']) ? implode(',', $_POST['colors']) : ''; $stock_quantity = mysqli_real_escape_string($conn, $_POST['stock_quantity']); $description = mysqli_real_escape_string($conn, $_POST['description']); $uploadDir = "uploads/"; $imagePaths = []; for ($i = 0; $i < 5; $i++) { $inputName = "image_" . ($i + 1); if (isset($_FILES[$inputName]) && $_FILES[$inputName]['error'] == 0) { $fileName = time() . "_" . basename($_FILES[$inputName]['name']); $targetFilePath = $uploadDir . $fileName; if (move_uploaded_file($_FILES[$inputName]['tmp_name'], $targetFilePath)) { $imagePaths[] = $targetFilePath; } else { $imagePaths[] = ''; } } else { $imagePaths[] = ''; } } $sql = "INSERT INTO slgtoys_products (name, image_1, image_2, image_3, image_4, image_5, age_category, size, weight, material, category_id, price, color, stock_quantity, description) VALUES ('$name', '$imagePaths[0]', '$imagePaths[1]', '$imagePaths[2]', '$imagePaths[3]', '$imagePaths[4]', '$age_category', '$size', '$weight', '$material', '$category_id', '$price', '$colors', '$stock_quantity', '$description')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('Product added successfully!'); window.location.href='add_product.php';</script>"; } else { echo "Error: " . mysqli_error($conn); } } ?> <!DOCTYPE html> <html lang="en" data-theme="light"> <head> <?php include 'style.php'; ?> </head> <body> <?php include 'sidebar.php'; ?> <main class="dashboard-main"> <?php include 'header.php'; ?> <div class="dashboard-main-body"> <h6 class="fw-semibold mb-0">Add Product</h6> <form action="" method="POST" enctype="multipart/form-data"> <div class="row gy-3"> <div class="col-12"> <label class="form-label">Name</label> <input type="text" name="name" class="form-control" required> </div> <div class="col-12"> <label class="form-label">Select Age</label> <select class="form-select" name="age_category" required> <option selected>Select Age Category</option> <option value="8-9">8 - 9</option> <option value="10-11">10 - 11</option> <option value="12-13">12 - 13</option> </select> </div> <div class="col-12"> <label class="form-label">Product Size</label> <input type="text" name="size" class="form-control" placeholder="Height * Width * Depth" required> </div> <div class="col-12"> <label class="form-label">Weight</label> <input type="text" name="weight" class="form-control" required> </div> <div class="col-12"> <label class="form-label">Material</label> <input type="text" name="material" class="form-control" required> </div> <div class="col-12"> <label class="form-label">Select Category</label> <select class="form-select" name="category_id" required> <option selected>Select Category</option> <?php $query = "SELECT category_id, category_name FROM product_category WHERE category_status = 'Active'"; $result = mysqli_query($conn, $query); while ($row = mysqli_fetch_assoc($result)) { echo "<option value='{$row['category_id']}'>{$row['category_name']}</option>"; } ?> </select> </div> <div class="col-12"> <div class="card h-100 p-0"> <div class="card-header border-bottom bg-base py-16 px-28"> <h6 class="text-lg fw-semibold mb-0">Select Colour</h6> </div> <select id="tagSelect" class="form-select" multiple="multiple"> <option value="html">HTML</option> <option value="css">CSS</option> <option value="javascript">JavaScript</option> <option value="php">PHP</option> <option value="mysql">MySQL</option> </select> </div> </div> <div class="col-12"> <label class="form-label">Select Images</label> <?php for ($i = 1; $i <= 5; $i++) { ?> <input class="form-control mb-3" type="file" name="image_<?php echo $i; ?>"> <?php } ?> </div> <div class="col-12"> <label class="form-label">Stock Quantity</label> <input type="number" name="stock_quantity" class="form-control" required> </div> <div class="col-12"> <label class="form-label">Price</label> <input type="text" name="price" class="form-control" required> </div> <div class="col-12"> <label class="form-label">Description</label> <textarea name="description" class="form-control" rows="4" required></textarea> </div> <div class="col-12"> <button type="submit" class="btn btn-primary w-100">Submit</button> </div> </div> </form> </div> <?php include 'footer.php'; ?> </main> </body> </html> <?php mysqli_close($conn); ?>