1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / 192.168.204.133 / admin /
Filename : mainlogo.php
back
<?php
//DB Configuration
include 'database/db.php';
error_reporting(0);
// Check if the form has been submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Get the form data
    $name = $_POST['name'];
    $parent = $_POST['parent'];
    $description = $_POST['description'];
    $thumbnail = $_FILES['thumbnail'];

    // Generate a random filename for the uploaded file
    $random_filename = substr(str_shuffle('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 0, 6);

    // Get the file extension
    $file_extension = pathinfo($thumbnail['name'], PATHINFO_EXTENSION);

    // Create the full filename
    $filename = $random_filename . '.' . $file_extension;

    // Upload the file to the uploads/categories folder
    $upload_dir = 'uploads/categories/';
    $upload_file = $upload_dir . $filename;

    // Check if the file was uploaded successfully
    if (move_uploaded_file($thumbnail['tmp_name'], $upload_file)) {
        // Insert the data into the categories table
        $sql = "INSERT INTO categories (name, parent, description, thumbnail) VALUES ('$name', '$parent', '$description', '$filename')";
        if ($conn->query($sql) === TRUE) {
            echo "<script>
            alert('First banner added successfully. Banner Name: " . $name . "');
            window.location.href = 'firstbanner.php';
          </script>";
        } else {
            echo "Error: " . $sql . "<br>" . $conn->error;
        }
    } else {
        echo "Error uploading file!";
    }
}







if (isset($_POST['delete'])) {
    $id = $_POST['id'];
    $sql = "SELECT * FROM categories WHERE id = '$id'";
    $result = mysqli_query($conn, $sql);
    $row = mysqli_fetch_assoc($result);
    $thumbnail = $row['thumbnail'];

    // Delete the category from the database
    $sql = "DELETE FROM categories WHERE id = '$id'";
    if (mysqli_query($conn, $sql)) {
        // Delete the thumbnail image from the uploads/categories folder
        $upload_dir = 'uploads/categories/';
        $upload_file = $upload_dir . $thumbnail;
        if (file_exists($upload_file)) {
            unlink($upload_file);
        }
        echo "<script>alert('Category deleted successfully.'); window.location.href = 'categories.php';</script>";
    } else {
        echo "Error deleting category: " . mysqli_error($conn);
    }
}

// Close the database connection
?>

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

<head>
    <?php include 'parts/css.php' ?>
    <title>Kaiadmin - Bootstrap 5 Admin Dashboard</title>

</head>

<body>
    <div class="wrapper">
        <?php include 'parts/sidebar.php' ?>
        <div class="main-panel">
            <?php include 'parts/header.php'; ?>
            <div class="container">
                <div class="page-inner">
                    <div class="page-header">
                        <h4 class="page-title">Update Logo</h4>
                        <ul class="breadcrumbs">
                            <li class="nav-home">
                                <a href="index.php">
                                    <i class="icon-home"></i>
                                </a>
                            </li>
                            <li class="separator">
                                <i class="icon-arrow-right"></i>
                            </li>
                            <li class="nav-item">
                                <a href="index.php">Appearence</a>
                            </li>
                            <li class="separator">
                                <i class="icon-arrow-right"></i>
                            </li>
                            <li class="nav-item">
                                <a href="mainlogo.php">Update Logo</a>
                            </li>
                        </ul>
                    </div>
                    <div class="page-category">
                        <!-- body starts here -->
                        <form class="row g-3" method="post" action="" enctype="multipart/form-data">
                            <div class="col-12">
                                <label for="thumbnail" class="form-label">Logo :</label>
                                <input type="file" class="form-control" id="thumbnail" name="thumbnail" accept="image/*">
                            </div>
                            <div class="col-12">
                                <button type="submit" class="btn btn-primary">Update Logo</button>
                            </div>
                        </form>










                        <!-- body ends here  -->
                    </div>
                </div>
            </div>
            <?php include 'parts/footer.php' ?>
        </div>
    </div>
    <!--   Core JS Files   -->
    <?php include 'parts/js.php'; ?>
</body>

</html>