1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / eidvoice / main / admin /
Filename : services_category.php
back
<?php
session_start();
include "../includes/config.php";

if (isset($_SESSION['login']) && $_SESSION['login'] == 'true') {

    $name = '';
    $image_name = '';
    $update_mode = false;
    $update_id = '';

    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $name = $_POST['name'];
        $update_id = $_POST['update_id'];

        if (!empty($_FILES['image']['tmp_name'])) {
            $extension = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
            $imgname = uniqid();
            $cropped_filename = $imgname . "-416x555." . $extension;

            move_uploaded_file($_FILES['image']['tmp_name'], "./uploads/services/" . $imgname . "." . $extension);
            $source = imagecreatefromstring(file_get_contents("./uploads/services/" . $imgname . "." . $extension));

            list($width, $height) = getimagesize("./uploads/services/" . $imgname . "." . $extension);
            $cropWidth = 416;
            $cropHeight = 555;
            $x = max(0, ($width - $cropWidth) / 2);
            $y = max(0, ($height - $cropHeight) / 2);

            $cropped = imagecrop($source, ['x' => $x, 'y' => $y, 'width' => $cropWidth, 'height' => $cropHeight]);
            if ($cropped !== FALSE) {
                imagepng($cropped, "./uploads/services/" . $cropped_filename);
                imagedestroy($cropped);
                $image_name = $cropped_filename;
            }
            imagedestroy($source);

            unlink("./uploads/services/" . $imgname . "." . $extension);
        }

        if (!empty($update_id)) {
            if ($image_name != '') {
                $result = $conn->query("SELECT image FROM services_category WHERE id = '$update_id'");
                if ($result && $row = $result->fetch_assoc()) {
                    if (!empty($row['image']) && file_exists("./uploads/services/" . $row['image'])) {
                        unlink("./uploads/services/" . $row['image']);
                    }
                }
                $sql = "UPDATE services_category SET name='$name', image='$image_name' WHERE id='$update_id'";
            } else {
                $sql = "UPDATE services_category SET name='$name' WHERE id='$update_id'";
            }
        } else {
            $sql = "INSERT INTO services_category (name, image, status) VALUES ('$name', '$image_name', 1)";
        }

        if ($conn->query($sql) === TRUE) {
            header('location:services_category.php');
        } else {
            echo "<div class='alert alert-danger'>Error: " . $conn->error . "</div>";
        }
    }

    if (isset($_GET['delete_id'])) {
        $delete_id = $_GET['delete_id'];
        $sql = "UPDATE services_category SET status = 0 WHERE id = '$delete_id'";
        if ($conn->query($sql) === TRUE) {
            header('location:services_category.php');
        } else {
            echo "<div class='alert alert-danger'>Error: " . $conn->error . "</div>";
        }
    }

    if (isset($_GET['edit_id'])) {
        $edit_id = $_GET['edit_id'];
        $result = $conn->query("SELECT * FROM services_category WHERE id='$edit_id'");
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            $name = $row['name'];
            $update_mode = true;
        }
    }
?>

<?php include "includes/header.php"; ?>
<?php include "includes/leftmenu.php"; ?>
<?php include "includes/topbar.php"; ?>
</head>

<body>
    <div class="container-fluid">
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb my-0 ms-2">
                <li class="breadcrumb-item">
                    <a href="#">Home</a>
                </li>
                <li class="breadcrumb-item active"><span>Service Category Create</span></li>
            </ol>
        </nav>
    </div>
    </header>
    <div class="body flex-grow-1 px-3">
        <div class="container-lg">
            <div class="card mb-4">
                <div class="card-header">Service Category Create</div>
                <div class="card-body">
                    <form method="POST" action="services_category.php" enctype="multipart/form-data" onSubmit="return validate();">
                        <div class="row">
                            <input type="hidden" name="update_id" value="<?php echo $update_mode ? $edit_id : ''; ?>">
                            <div class="mb-3">
                                <label class="form-label" for="">Name</label>
                                <input class="form-control" id="Name" type="text" name="name" placeholder="Name" value="<?php echo $name; ?>">
                                <div> <span id="title_error" style="color:red"></span></div>
                            </div>
                            <div class="mb-3">
                                <label class="form-label" for="">Image</label><br>
                                <input class="" id="image" type="file" name="image">
                                <div> <span id="title_error" style="color:red"></span></div>
                            </div>
                            </br>
                        </div>
                        <div><input type="submit" class="btn btn-primary" value="<?php echo $update_mode ? 'Update' : 'Submit'; ?>"></div>
                    </form>

                    <table class="table mt-5">
                        <thead class="table-dark">
                            <tr>
                                <th scope="col">S.No</th>
                                <th scope="col">Name</th>
                                <th scope="col">Image</th>
                                <th scope="col">Edit</th>
                                <th scope="col">Delete</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $result = $conn->query("SELECT * FROM services_category WHERE status = 1");
                            if ($result->num_rows > 0) {
                                $i = 1;
                                while ($row = $result->fetch_assoc()) {
                                    echo "<tr>";
                                    echo "<td>" . $i++ . "</td>";
                                    echo "<td>" . $row['name'] . "</td>";
                                    echo "<td><img src='./uploads/services/" . $row['image'] . "' width='60'></td>";
                                    echo "<td><a href='services_category.php?edit_id=" . $row['id'] . "'>Edit</a></td>";
                                    echo "<td><a href='services_category.php?delete_id=" . $row['id'] . "' onclick='return confirm(\"Are you sure to delete this product?\");'>Delete</a></td>";
                                    echo "</tr>";
                                }
                            } else {
                                echo "<tr><td colspan='5'>No records found.</td></tr>";
                            }
                            ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <script>
        function validate() {
            document.getElementById("title_error").innerHTML = "";

            var Name = document.getElementById("Name").value.trim();
            var valid = true;

            if (Name === "") {
                document.getElementById("title_error").innerHTML = "Please enter a name";
                valid = false;
            }

            return valid;
        }
    </script>
</body>
<?php include "includes/footer.php"; ?>

<?php } else {
    header("location:index.php");
} ?>