PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u403625155/domains/connecttogetherwith.com/public_html/admin/categories.php

<?php
require "header.php";
?>
<style>
    th {
        color: #000 !important;
    }
</style>

<div class="row">
    <div class="col-12">
        <div class="card bg-white">
            <div class="card-header h3 text-dark">
                Packages
                <button class="float-end btn btn-primary" data-bs-toggle="modal" data-bs-target="#create-modal">
                    + Create Category
                </button>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table" id="table">
                        <thead>
                            <tr>
                                <th>Category Name</th>
                                <th>Edit</th>
                                <th>Delete</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $get_users = mysqli_query($conn, "SELECT * FROM categories ORDER BY id DESC");
                            if (mysqli_num_rows($get_users) > 0) {
                                while ($task = mysqli_fetch_assoc($get_users)) {
                                    $cid = $task['id'];
                                    $cname = $task['name'];
                                    ?>

                                    <tr>
                                        <td>
                                            <?php echo $cname; ?></td>
                                        <td><button value="<?php echo $cid; ?>" class="btn btn-primary"><i class="bx bx-pencil"
                                                    data-bs-toggle="modal"
                                                    data-bs-target="#package-<?php echo $cid; ?> "></i></button></td>

                                        <td>
                                            <button value="<?php echo $cid; ?>" class="btn btn-danger delete-btn"
                                                onclick="confirmDelete(<?php echo $cid; ?>)">
                                                <i class="bx bx-trash"></i>
                                            </button>
                                        </td>

                                    </tr>
                                    <?php
                                }
                            }
                            ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>



<?php
$get_users = mysqli_query($conn, "SELECT * FROM categories ORDER BY id DESC");
if (mysqli_num_rows($get_users) > 0) {
    while ($task = mysqli_fetch_assoc($get_users)) {
        $cid = $task['id'];
        $cname = $task['name'];
            ?>

        <div class="modal fade" id="package-<?php echo $cid; ?>">
            <div class="modal-dialog modal-dialog-centered">
                <div class="modal-content">
                    <div class="modal-header h3 text-dark">
                        Edit Category
                        <button class="btn btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        <form method="post" enctype="multipart/form-data">
                            <input type="hidden" name="id" value="<?php echo $cid; ?>" />

                            <div class="form-group my-2">
                                <label class="form-label">
                                    Category Name
                                </label>
                                <input type="text" name="name" class="form-control" value="<?php echo $cname; ?>" />
                            </div>
                            <div class="form-group m-3">
                                                            <button name="edit" class="btn btn-primary">
                                                                Edit Category
                                                            </button>
                                                        </div>
                 
                        </form>
                    </div>
                </div>
            </div>
        </div>


        <?php
    }
}
?>

<div class="modal fade" id="create-modal">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content">
            <div class="modal-header h3 text-dark">
                Create Category
                <button class="btn btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <form method="post" enctype="multipart/form-data">
                    <div class="form-group my-2">
                        <label class="form-label">
                            Category Name
                        </label>
                        <input type="text" name="name" class="form-control" required />
                    </div>




                    <div class="form-group m-3">
                        <button name="create" class="btn btn-primary">
                            Create Category
                        </button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>






<?php
require "footer.php";

//edit package



if (isset($_POST['edit'])) {
    $cid = mysqli_real_escape_string($conn, $_POST['id']);
    $cname = mysqli_real_escape_string($conn, $_POST['name']);

  

    $update = mysqli_query($conn, "UPDATE categories SET name ='$cname' WHERE id='$cid'");

    if ($update) {
        ?>
        <script>
            swal('Great', 'Category Edited', 'success')
                .then(() => {
                    location.replace('categories')
                });
        </script>
        <?php
    } else {
        ?>
        <script>
            swal('Oops', 'An error occurred while updating the category', 'error');
        </script>
        <?php
    }
}


if(isset($_POST['create'])) {
    $category_name = $_POST['name'];

    $sql = "INSERT INTO categories (name) VALUES ('$category_name')";
    if(mysqli_query($conn, $sql)) {
        header("Location: categories");
        exit();
    } else {
        echo "Error: " . mysqli_error($conn);
    }

  
}
?>

<script>
    function confirmDelete(id) {
        swal({
            title: "Are you sure?",
            text: "Once deleted, you will not be able to recover this Category!",
            icon: "warning",
            buttons: true,
            dangerMode: true,
        })
            .then((willDelete) => {
                if (willDelete) {
                    // User clicked "Yes", perform the deletion
                    deletePackage(id);
                }
            });
    }

    function deletePackage(id) {
        // Using AJAX to send the delete request to the server
        $.ajax({
            type: 'POST',
            url: 'delete_cat.php',
            data: {
                delete: true,
                id: id
            },
            success: function (response) {
                // Handle the response from the server, if needed
                swal('Great', 'Category Deleted', 'success')
                    .then(() => {
                        location.replace('categories')
                    });
            },
            error: function () {
                // Handle the error, if any
                swal('Oops', 'An error occurred while deleting', 'error');
            }
        });
    }
</script>
Back to Directory=ceiIENDB`