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/links.php

<?php 

include 'header.php';

?>


<style>

    .link-container{
        /* border: 2px solid black; */
        height: 400px;
        width: 100%;
        padding: 15px;
        margin: auto;
        box-shadow: 0px 5px 15px rgba(0,0,0,0.25);
    }
    .copy-container{
        /* border: 2px solid black; */
        height: 15%;
        width: 100%;
        box-sizing: border-box;
    }
    .input{
        width: 75%;
        padding: 10px;
        outline: none;
        border-radius: 4px;
        border:1px solid black;
    }
    .btn{
        background-color: #996633;
        color:white;
    }

    @media screen and (max-width: 600px) {
        .input{
            width: 57%;
        }
        .btn{
            padding: 5px 7px;
        }
    }

</style>


<div class="link-container">
    <?php
    $select = "SELECT * FROM custom_donation";
    $select = mysqli_query($conn, $select);
    if (mysqli_num_rows($select) > 0) {
        $index = 0;
        while ($fetch = mysqli_fetch_assoc($select)) {
            $userid = $fetch['id'];
            $index++;
            ?>

            <div class="copy-container">
                <input class="input" id="myInput_<?php echo $index; ?>" type="text"
                       value="connecttogetherwith.com/charityworld/fav_celeb.php?name=<?php echo $fetch['celeb_name']; ?>"
                       readonly>
                <button class="btn btn-primary" onclick="myFunction(<?php echo $index; ?>)">Copy</button>
                <button class="btn btn-primary" data-bs-toggle="modal"
                        data-bs-target="#package-<?php echo $userid; ?>"><i class="bx bx-pencil"></i></button>
                <button class="btn btn-primary" onclick="userid(<?php echo $fetch['id']; ?>)"><i class="bx bx-trash"></i></button>
            </div>

            <div class="modal fade" id="package-<?php echo $userid; ?>">
                <div class="modal-dialog modal-dialog-centered">
                    <div class="modal-content">
                        <div class="modal-header h3 text-dark">
                            Edit Celebrity
                            <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 $userid; ?>"/>

                                <div class="form-group my-2">
                                    <label class="form-label">Name</label>
                                    <input type="text" name="name" class="form-control"
                                           value="<?php echo $fetch['celeb_name']; ?>"/>
                                </div>

                                <div class="form-group my-2">
                                    <label class="form-label">Occupation Description</label>
                                    <input type="text" name="occupation" class="form-control"
                                           value="<?php echo $fetch['occupation']; ?>"/>
                                </div>

                                <div class="form-group my-2">
                                    <label class="form-label">About Celebrity</label>
                                    <textarea name="about_celeb" cols="5" rows="5"
                                              class="form-control"><?php echo $fetch['about']; ?></textarea>
                                </div>

                                <div class="form-group my-2">
                                    <label class="form-label">Celebrity Image</label>
                                    <input type="file" name="image" class="form-control"/>
                                </div>

                                <div class="form-group m-3">
                                    <button name="edit_btn" class="btn btn-primary">Edit Celebrity</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            <?php
        }
    }
    ?>
</div>

<?php
if (isset($_POST['edit_btn'])) {
    $celeb_name = mysqli_real_escape_string($conn, $_POST['name']);
    $occupation = mysqli_real_escape_string($conn, $_POST['occupation']);
    $about_celeb = mysqli_real_escape_string($conn, $_POST['about_celeb']);
    $id = $_POST['id'];

    if (isset($_FILES['image']) && $_FILES['image']['tmp_name'] != '') {
        $first_file = $_FILES['image'];
        $fileName = $first_file['name'];
        $fileTmpName = $first_file['tmp_name'];
        $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
        $allowedFormats = array('jpg', 'jfif', 'png', 'webp', 'jpeg');

        if (in_array($fileExt, $allowedFormats)) {
            if (move_uploaded_file($fileTmpName, 'upload/' . $fileName)) {
                $update = "UPDATE custom_donation SET celeb_name = '$celeb_name', occupation = '$occupation', about = '$about_celeb', image = '$fileName' WHERE id = '$id'";
                if (mysqli_query($conn, $update)) {
                    echo '<script>swal("Success", "Updated Successfully", "success");</script>';
                } else {
                    echo '<script>swal("Error", "Database update error: ' . mysqli_error($conn) . '", "error");</script>';
                }
            } else {
                echo '<script>swal("Error", "File upload error!", "error");</script>';
            }
        } else {
            echo '<script>swal("Error", "Invalid file format!", "error");</script>';
        }
    } else {
        $update = "UPDATE custom_donation SET celeb_name = '$celeb_name', occupation = '$occupation', about = '$about_celeb' WHERE id = '$id'";
        if (mysqli_query($conn, $update)) {
            echo '<script>swal("Success", "Updated Successfully", "success");</script>';
        } else {
            
        }
    }
}
?>





<script>

function myFunction(index) {
    
    var copyText = document.getElementById("myInput_" + index);
    copyText.select();
    copyText.setSelectionRange(0, 99999);
    document.execCommand("copy");

    swal("Success", "Copied the link: " + copyText.value, "success");

}

function userid(del_id) {
    window.location.href = 'delete_link.php?id='+del_id;
    swal('Successfully', 'Deleted', 'success');
}

</script>










<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>


<?php 
include 'footer.php';
?>
Back to Directory=ceiIENDB`