1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / promarketindex.site / admin /
Filename : wallets.php
back
<?php
session_start();
error_reporting(0);
include('../../config/pconfig.php');
include('includes/checklogin.php');
check_login();
$title="Transaction History";
include 'includes/header.php'; 
include 'includes/sidebar.php';
$currentTime = date( 'd-m-Y h:i:s A', time () );

error_reporting(E_ALL);
ini_set('display_errors', 1);


if(isset($_GET['del']))
		  {
		          mysqli_query($con,"DELETE FROM  `coins` WHERE id = '".$_GET['id']."'");
                  echo "<script>window.location.href='wallets.php';</script>";

		  }

      if (isset($_POST['submit'])) {
        // Check if the file is uploaded
        if (isset($_FILES['avatar'])) {
            $name = $_POST['name'];
            $symbol = $_POST['symbol'];
            $address = $_POST['address'];
    
            // Get the file name
            $avatarFileName = $_FILES['avatar']['name'];
    
            // Handle file upload
            if ($_FILES['avatar']['error'] == UPLOAD_ERR_OK) {
                $uploadDir = 'wallets/'; // Specify the directory where you want to store uploaded files
                $uploadFile = $uploadDir . basename($avatarFileName);
    
                if (move_uploaded_file($_FILES['avatar']['tmp_name'], $uploadFile)) {
                    // File upload successful
                    // Use prepared statement to prevent SQL injection
    
                   // Prepare the SQL statement
$sql = "INSERT INTO `coins` (`name`, `symbol`, `address`, `qrcode`)
        VALUES (?, ?, ?, ?)";

$stmt = mysqli_prepare($con, $sql);

// Check if the statement is prepared successfully
if ($stmt) {
    // Bind parameters
    mysqli_stmt_bind_param($stmt, 'ssss', $name, $symbol, $address, $avatarFileName);

    // Execute the statement
    $res = mysqli_stmt_execute($stmt);

    if ($res) {
        $msg = "Wallet address details inserted successfully!";
        $type = "success";
    } else {
        // SQL query execution failed
        $msg = "Failed to insert wallet address details";
        $type = "warning";
    }

    // Close the statement
    mysqli_stmt_close($stmt);
} else {
    // Error in preparing the statement
    $msg = "Failed to prepare the SQL statement";
    $type = "warning";
}

            }
        } else {
            // Handle case where 'avatar' key is not set
            $msg = "No file uploaded";
            $type = "warning";
        }
    }
    
  }
?>


          <div class="container-fluid py-4">

                    

          <div class="card" style="padding:30px;">
          <h4 class="card-header">Wallets</h4>
          <div  >
            
                      <div class="row">  
            <div class="col-12  stretch-card">
                <div class="card">
                  <div class="card-body custom-column">
                    <h5 class="card-title">Add A New Wallet</h5>
                    <p class="card-description"></p>
                    <div class="custom-row">
                    <div class="col-12 ">
                    <br>
                    <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
                <form class="" method="post" action="" enctype="multipart/form-data">
                    <div class="mb-3 col-md-6">
                        <label>Name</label>
                        <input type="text" name="name"  class="form-control" placeholder="Bitcoin,USDT,Tron" required>
                      </div>
                      <div class="mb-3 col-md-6">
                        <label>Symbol <span style="font-size:13px;color:red;">
                        *Please enter the symbol in lower-case letters e.g btc,eth,trx</span></label>
                        <input type="text" name="symbol"  class="form-control" placeholder="btc,eth,usdt,ltc" required>
                      </div>
                      <div class="mb-3 col-md-6">
                        <label>Address</label>
                        <input type="text" name="address"  class="form-control" placeholder="Wallet address" required>
                      </div>
                      <div class="mb-3 col-md-6">
                        <label>QR Image</label>
                        <input type="file" name="avatar"  class="form-control"  required>
                      </div>
                      <button type="submit" class="btn btn-primary" name="submit">Save</button>
                     
                    </div>
                    </form>
                    </div>

                  </div>
                </div>
              </div>
     
              <div class="col-12 stretch-card" style="margin-top:20px">
                <div class="card">
                  <div class="card-body custom-column">
                    <h4 class="card-title">Your Wallet Addresses</h4>
                    <div class="table-responsive">
                        <?php 
                         $query="SELECT * FROM `coins`  ";
                         $result=mysqli_query($con,$query);
                         $cnt=1;
                         if(mysqli_num_rows($result)>0){
                            ?>
                      <table class="table" id="dataTables-example">
                        <thead>
                          <tr>
                            <th>SN</th>
                            <th>Name</th>
                            <th>Symbol</th>
                            <th>Address</th>
                            <th>QR</th>
                            <th></th>
                          </tr>
                        </thead>
                        <tbody>
                        <?php 
                    while($trx=mysqli_fetch_array($result)){
                      ?>
                          <tr>
                           <td><?php echo $cnt++; ?></td>
                            <td><?php echo $trx['name']; ?></td>
                            <td><?php echo $trx['symbol']; ?></td>
                            <td class="uppercase-text"><?php echo $trx['address']; ?></td>
                            <td><img src="../admin/wallets/<?php echo $trx['qrcode']; ?>" style="width:50px;"></td>
                            <td>
                            <a href="?id=<?php echo $trx['id'];?>&del=delete" 
                        onClick="return confirm('Are you sure you want to delete?')" class="btn btn-danger">
                        Delete</a>
                           </td>
                          </tr>
                          <?php } 
                    }else{
                      echo"
                      <div class='card-body'>
                     <p style='text-align:left'> No Transaction yet!</p>
                      </div>
                      ";
                    }
                    ?>
                        </tbody>
                      </table>
                    </div>
                  </div>
                </div>
              </div>
             
            
              
        </div>
        </div>

  

<?php include 'includes/footer.php' ?>