1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / www / admin-panel / category /
Filename : add-category.php
back
<?php

session_start();
include('../include/connect.php'); // Include your database connection

if (isset($_POST['submit'])) {
    // Get the category name and status from the form
    $category_name = $_POST['category_name'];
    $category_status = $_POST['category_status'];
    $image = $_FILES['category_image'];

    // Check if the category name, status, and image are not empty
    if (!empty($category_name) && !empty($category_status) && !empty($image['name'])) {
        // Check if the category already exists
        $check_query = $con->prepare("SELECT * FROM category WHERE category_name = ?");
        $check_query->bind_param("s", $category_name);
        $check_query->execute();
        $result = $check_query->get_result();

        if ($result->num_rows > 0) {
            // If the category exists, show an alert message
            echo "<script>
                    window.onload = function() {
                        Swal.fire({
                            icon: 'warning',
                            title: 'Category Exists',
                            text: 'The category already exists. Please choose a different name.',
                            confirmButtonText: 'OK'
                        });
                    }
                  </script>";
        } else {
            // Handle the image upload
            $target_dir = "../category/category-images/";
            if (!is_dir($target_dir)) {
                mkdir($target_dir, 0777, true);
            }

            $image_name = time() . "-" . basename($image['name']); // Create a unique file name
            $target_file = $target_dir . $image_name;
            $imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));

            // Validate the image file type (Only allow .webp)
            if ($imageFileType != "webp") {
                echo "<script>
                        window.onload = function() {
                            Swal.fire({
                                icon: 'error',
                                title: 'Invalid Image',
                                text: 'Only WEBP images are allowed.',
                                confirmButtonText: 'OK'
                            });
                        }
                      </script>";
            } else {
                // Move the uploaded file to the target directory
                if (move_uploaded_file($image['tmp_name'], $target_file)) {
                    // Insert the category into the database with the image name
                    $stmt = $con->prepare("INSERT INTO category (category_name, category_image, category_status) VALUES (?, ?, ?)");
                    $stmt->bind_param("sss", $category_name, $image_name, $category_status);

                    if ($stmt->execute()) {
                        echo "<script>
                                window.onload = function() {
                                    Swal.fire({
                                        icon: 'success',
                                        title: 'Category Added',
                                        text: 'The category has been added successfully.',
                                        confirmButtonText: 'OK'
                                    }).then(() => {
                                        window.location.href = 'add-category.php';
                                    });
                                }
                              </script>";
                    } else {
                        echo "<script>
                                window.onload = function() {
                                    Swal.fire({
                                        icon: 'error',
                                        title: 'Error',
                                        text: 'There was an error adding the category.',
                                        confirmButtonText: 'OK'
                                    });
                                }
                              </script>";
                    }
                    $stmt->close();
                } else {
                    echo "<script>
                            window.onload = function() {
                                Swal.fire({
                                    icon: 'error',
                                    title: 'Upload Failed',
                                    text: 'There was an error uploading the image.',
                                    confirmButtonText: 'OK'
                                });
                            }
                          </script>";
                }
            }
        }
        $check_query->close();
    } else {
        echo "<script>
                window.onload = function() {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Warning',
                        text: 'Please enter all required fields and upload an image.',
                        confirmButtonText: 'OK'
                    });
                }
              </script>";
    }
}

$con->close();
?>




<!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="UTF-8">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Argus Computers | Add Category | Admin Panel</title>



    <link rel="preconnect" href="https://fonts.gstatic.com">

    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@300;400;600;700;800&display=swap" rel="stylesheet">

    <link rel="stylesheet" href="../assets/css/bootstrap.css">



    <link rel="stylesheet" href="../assets/vendors/perfect-scrollbar/perfect-scrollbar.css">

    <link rel="stylesheet" href="../assets/vendors/bootstrap-icons/bootstrap-icons.css">

    <link rel="stylesheet" href="../assets/css/app.css">

    <link rel="stylesheet" href="../assets/vendors/sweetalert2/sweetalert2.min.css">

    <link rel="shortcut icon" href="../assets/images/logo/argus-favicon.png" type="image/x-icon">

</head>



<body>

    <div id="app">

        <div id="sidebar" class="active">

            <div class="sidebar-wrapper active">

                <?php include('menu.php') ?>

                <button class="sidebar-toggler btn x"><i data-feather="x"></i></button>

            </div>

        </div>

        <div id="main">

            <header class="mb-3">

                <a href="#" class="burger-btn d-block d-xl-none">

                    <i class="bi bi-justify fs-3"></i>

                </a>

            </header>



            <div class="page-heading">

                <div class="page-title">

                    <div class="row">

                        <div class="col-12 col-md-6 order-md-1 order-last">

                            <h3>Add Category Page</h3>

                        </div>

                        <div class="col-12 col-md-6 order-md-2 order-first">

                            <nav aria-label="breadcrumb" class="breadcrumb-header float-start float-lg-end">

                                <ol class="breadcrumb">

                                    <li class="breadcrumb-item"><a href="../dashboard.php">Dashboard</a></li>

                                    <li class="breadcrumb-item active" aria-current="page">Add Category</li>

                                </ol>

                            </nav>

                        </div>

                    </div>

                </div>

                <!-- Input Style start -->

                <section id="input-style">

                    <div class="row">

                        <div class="col-md-12">

                            <div class="card">



                                <div class="card-body">

                                    <div class="row">

                                        <div class="col-sm-12">

                                            <form method="POST" enctype="multipart/form-data">

                                                <div class="form-group">

                                                    <h6>Add Category</h6>

                                                    <input type="text" id="category_name" name="category_name" class="form-control round"

                                                        placeholder="Type the category of the product" required>

                                                </div>

                                                <div class="form-group">

                                                    <h6>Category Image</h6>

                                                    <input type="file" name="category_image" class="form-control" required>

                                                </div>

                                                <div class="form-group">

                                                    <h6>Select Status</h6>

                                                    <fieldset class="form-group">

                                                        <select class="form-select" id="basicSelect" name="category_status" required>

                                                            <option value="">Choose Status</option>

                                                            <option value="Active">Active</option>

                                                            <option value="Inactive">Inactive</option>

                                                        </select>

                                                    </fieldset>

                                                </div>

                                                <div class="form-group">

                                                    <button type="submit" name="submit" class="btn btn-primary">Add Category</button>

                                                    <button type="reset" class="btn btn-danger">Reset</button>

                                                    <a href="../dashboard.php" class="btn btn-success">Go Back</a>

                                                </div>

                                            </form>

                                        </div>

                                    </div>

                                </div>

                            </div>

                        </div>

                    </div>

                </section>

                <!-- Input Style end -->

            </div>



            <?php include('footer.php') ?>



        </div>

    </div>

    <script src="../assets/vendors/perfect-scrollbar/perfect-scrollbar.min.js"></script>

    <script src="../assets/js/bootstrap.bundle.min.js"></script>

    <script src="../assets/js/main.js"></script>

    <script src="../assets/js/extensions/sweetalert2.js"></script>

    <script src="../assets/vendors/sweetalert2/sweetalert2.all.min.js"></script>

</body>



</html>