1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / 192.168.49.128 / admin /
Filename : allcategories.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>
    <title>Manage Categories | Admin </title>
    <?php include 'parts/css.php' ?>
</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">Dashboard</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="categories.php">Pages</a>
                            </li>
                            <li class="separator">
                                <i class="icon-arrow-right"></i>
                            </li>
                            <li class="nav-item">
                                <a href="#">Add Categories</a>
                            </li>
                        </ul>
                    </div>
                    <div class="page-category">
                        <!-- body starts here -->
                        <!-- Table starts  -->
                        <table class="table" id="myTable">
                            <thead>
                                <tr>
                                    <th scope="col">#</th>
                                    <th scope="col">Thumbnail</th>
                                    <th scope="col">Name</th>
                                    <th scope="col">Parent</th>
                                    <th scope="col">Description</th>
                                    <th scope="col">Edit</th>
                                    <th scope="col">Delete</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php 
                                $sqlo = "SELECT * FROM `categories` ORDER BY `id` DESC";
                                $resulto = mysqli_query($conn, $sqlo);
                                $snoo = 0;
                                while ($rowo = mysqli_fetch_assoc($resulto)) {
                                    $snoo = $snoo + 1;
                                    $categoriesparent = $rowo['parent'];
                                    $sqloq = "SELECT * FROM `categories` WHERE `id` = '$categoriesparent'";
                                    $resultoq = mysqli_query($conn, $sqloq);
                                    $rowoq = mysqli_fetch_assoc($resultoq);
                                    echo
                                    " 
            <tr>
                <th scope='row'>$snoo</th>
                <td> <img src='uploads/categories/$rowo[thumbnail]' height='100px' width='100px'></td>
                <td>$rowo[name]</td>
                <td>$rowoq[name]</td>
                <td>$rowo[description]</td>
                <td><button type='button' class='btn btn-outline-warning'> <i class='fas fa-edit'> </i> Update</button></td>
                <td>
                    <form action='' method='post'>
                        <input type='hidden' name='id' value='$rowo[id]'>
                        <button type='submit' class='btn btn-outline-danger' name='delete'> <i class='fas fa-trash-alt'></i> Delete</button>
                    </form>
                </td>
            </tr> 
            ";
                                }
                                ?>
                            </tbody>
                        </table>
                        <!-- Table ends Here  -->


                        <!-- body ends here  -->
                    </div>
                </div>
            </div>
            <?php include 'parts/footer.php' ?>
        </div>
    </div>
    <!--   Core JS Files   -->
    <?php include 'parts/js.php'; ?>
    <script src="https://code.jquery.com/jquery-3.7.1.js" integrity="sha256-eKhayi8LEQwp4NKxN+CfCh+3qOVUtJn3QNZ0TciWLP4=" crossorigin="anonymous"></script>
    <script src="http://cdn.datatables.net/2.2.1/js/dataTables.min.js"></script>
    <script>
        let table = new DataTable('#myTable');
    </script>
</body>

</html>