Viewing File: /home/rareljzw/public_html/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.php';
                }
                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.php';
                }
                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.php"><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");

?>