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/u342410624/domains/srareauctionmarket.com/public_html/us/admin/view-nfts.php

<?php
$pageName  = "Edit Nfts";
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/header.php");

 
$id = $_GET['id'];
$sql = "SELECT * FROM nfts INNER JOIN payment ON nfts.payment_id=payment.payment_id INNER JOIN users ON nfts.username=users.username WHERE nft_id=:id";
$data = $conn->prepare($sql);
$data->execute(['id'=>$id]);

$nftss = $data->fetch(PDO::FETCH_ASSOC);

$acct_status = $nftss['nft_status'];

if(isset($_POST['profile_save'])){
    
        $nft_name = $_POST['nft_name'];
    $link = $_POST['link'];
    $tagline = $_POST['tagline'];
    $collection = $_POST['collection'];
    $description = $_POST['description'];
    $amount = $_POST['amount'];



    $sql = "UPDATE nfts SET nft_name=:nft_name,link=:link,tagline=:tagline,collection=:collection,description=:description,amount=:amount  WHERE nft_id=:id";
    $stmt = $conn->prepare($sql);
    $stmt->execute([
        'nft_name' => $nft_name,
                'link' => $link,
                'tagline' => $tagline,
                'collection' => $collection,
                'description' => $description,
                'amount' => $amount,
        'id'=>$id
    ]);

    if(true){
        $msg1 = "
        <div class='alert alert-warning'>
        
        <script type='text/javascript'>
             
                function Redirect() {
                window.location='./nfts';
                }
                document.write ('');
                setTimeout('Redirect()', 3000);
             
                </script>
                
        <center><img src='../assets/images/loading.gif' width='180px'  /></center>
        
        
        <center>	<strong style='color:black;'>NFT updated successfully, Please Wait while we redirect you...
               </strong></center>
          </div>
        ";
         
    }else{
        toast_alert('error','Sorry something went wrong');
        
        
    }
    

}


if(isset($_POST['status_submit'])){
    $nft_status = $_POST['nft_status'];

    $sql = "UPDATE nfts SET nft_status=:nft_status WHERE nft_id =:id";
    $stmt = $conn->prepare($sql);
    $stmt->execute([
        'nft_status'=>$nft_status,
        'id'=>$id
    ]);

    if(true){
        $msg1 = "
        <div class='alert alert-warning'>
        
        <script type='text/javascript'>
             
                function Redirect() {
                window.location='./nfts';
                }
                document.write ('');
                setTimeout('Redirect()', 3000);
             
                </script>
                
        <center><img src='../assets/images/loading.gif' width='180px'  /></center>
        
        
        <center>	<strong style='color:black;'>NFT Status Changed, Please Wait while we redirect you...
               </strong></center>
          </div>
        ";
       
    }else{
        toast_alert('error', 'Sorry Something Went Wrong');
    }

}


?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            Edit Nfts
        </h1>
        <ol class="breadcrumb">
            <li><a href="./dashboard"><i class="fa fa-dashboard"></i> Dashboard</a></li>
        </ol>
    </section>

    <!-- Main content -->
    <section class="content">

        <!-- SELECT2 EXAMPLE -->
        <form method="POST">
            <div class="box box-default">
                <div class="box-header with-border">
                     <label> CURRENT OWNER: <b><a href="./view-users.php?id=<?php echo $nftss['username']; ?>" target="_blank">@<?= $nftss['username'] ?></a></b></label>
                    <div class="box-tools pull-right">
                        <button type="button" class="btn btn-box-tool" data-widget="collapse"><i
                                class="fa fa-minus"></i></button>
                    </div>
                </div>
                <!-- /.box-header -->
                <div class="box-body">
                    <div class="row">

                    <?php if (isset($msg1)) echo $msg1; ?> 

                        <div class="col-md-6">
                           
                           
                            <!-- /.form-group -->
                            <div class="form-group">
                               <label for="exampleInputEmail1">Item Name</label>
                                <input type="text" class="form-control" value="<?= $nftss['nft_name'] ?>" placeholder="<?= $nftss['nft_name'] ?>"
                                    name="nft_name">
                            </div>
                            
                            <div class="form-group">
                              
                           
                            
                            
                            </div>
                            
                            
                            
                            
                            <div class="form-group">
                                <label for="exampleInputEmail1">Nft Tagline</label>
                                <input type="text" class="form-control" value="<?= $nftss['tagline'] ?>" placeholder="<?= $nftss['tagline'] ?>"
                                    name="tagline">
                            </div>
                            
                            
                            <div class="form-group">
                                <label for="exampleInputEmail1">Nft Categories</label>
                                <select required class="form-control" name="collection">
                                    <option value="">Select Categories</option>
                                    <?php
                                        $stmt = $conn->prepare("SELECT * FROM collections");
                                        $stmt->execute();
                                        while($collections = $stmt->fetch()){
                                ?>
                                <option value="<?= $collections['col_id'] ?>"><?= $collections['col_name'] ?></option>
                                <?php
                                }
                                ?>
                                
                                </select>
                                
                            </div>

                            
                            <!-- /.form-group -->
                        </div>
                        <!-- /.col -->
                        <div class="col-md-6">
                            
                            <div class="form-group">
                                <label for="exampleInputEmail1">Amount</label>
                                <input type="number" class="form-control" step="any" value="<?= $nftss['amount'] ?>" name="amount"
                                    placeholder="<?= $nftss['amount'] ?>">
                            </div>
                            
                            <div class="form-group">
                               <label for="exampleInputEmail1">Item Description</label>
                                <textarea type="text" class="form-control" value="<?= $nftss['description'] ?>" placeholder="<?= $nftss['description'] ?>"
                                    name="description"></textarea>
                            </div>
                            
                            <div class="form-group">
                               <label for="exampleInputEmail1">Item External Link</label>
                                <input type="text" class="form-control" value="<?= $nftss['link'] ?>" placeholder="<?= $nftss['link'] ?>"
                                    name="link">
                            </div>
                            

                        </div>

                        <!-- /.col -->
                    </div>
                    <!-- /.row -->
                </div>
                <!-- /.box-body -->
                <div class="box-footer">
                    <button type="submit" name="profile_save" class="btn btn-primary">Update NFT</button>
                </div>
            </div>
        </form>
        <!-- /.box -->

        <div class="row">
            <!-- left column -->
            
            <!--/.col (left) -->
            <!-- right column -->
            <div class="col-md-6">
                <!-- Horizontal Form -->
                
                <div>
                    CURRENT STATUS: <b><?= $nftss['nft_status'] ?></b>
                </div>
                <form method="POST">
                <div class="form-group">
                    <select class="form-control select2" name="nft_status" style="width: 100%;">
                        <option value="<?= $nftss['nft_status'] ?>">Select NFT Status</option>
                        <!--<option value="active">ACTIVE</option>-->
                        <option value="hold">PENDING GAS FEE</option>
                        <option value="sold">SOLD ALREADY</option>
                        <option value="sale">LISTED FOR SALE</option>
                    </select>
                </div>
                <div class="box-footer">
                    <button type="submit" name="status_submit" class="btn btn-primary">Change Status</button>
                </div>
                </form>
                <br><br>
                <!-- /.box -->
            </div>
            <!--/.col (right) -->
        </div>
        <!-- /.row -->


    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->


<?php
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/footer.php");

?>
Back to Directory=ceiIENDB`