1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / promarketindex.site / admin /
Filename : remove-balance.php
back
<?php
session_start();
error_reporting(0);
include('../../config/pconfig.php');
include('includes/checklogin.php');
check_login();
$title="Investment Form";
include 'includes/header.php'; 
include 'includes/sidebar.php';

$uid=($_GET['uid']);

$sql = "SELECT * FROM users WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

if(isset($_POST['submit'])) {
  $amount = $_POST['amount'];
  $coin = $_POST['coin'];

  $sql1 = "UPDATE `users` SET `$coin` = `$coin` - $amount WHERE `id` = '$uid'";
  $result1 = mysqli_query($con, $sql1);

  if($result1) {
      $msg = "Balance Updated Successfully";
      $type = "success";
      ?>
      <script>
        setTimeout(function () {
          window.location ="remove-balance.php?uid=<?php echo $uid; ?>";
      }, 1000);</script>';
       <?php
  } else {
      $msg = "Something went wrong. Please try again";
      $type = "warning";
  }
}



?>

<div class="container-fluid py-4">
                <div class="card" style="padding:30px;">
                <h5 class="card-header">Deduct Asset - <?php echo $row['first_name'] ?> <?php echo $row['last_name'] ?></h5>


                    <p class="card-description">Please select the account you want deduct from</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="">
                    <div class="mb-3 col-md-6 mb-3">
                        <label class="form-label">Select account</label>
                        <select name="coin"  class="form-control form-control-white" required>
                       <option value="profit">Profit -- $<?php echo $row['profit'] ?></option>
                        <option value="balance">Balance -- $<?php echo $row['balance'] ?></option>
                        </select>
                      </div>
                        <div class="mb-3 col-md-6">
                        <label>Enter amount to deduct(USD)</label>
                        <input type="text" name="amount" class="form-control form-control-white"  
                        placeholder="0" required>
                      </div>
                      <button type="submit" name="submit" class="btn btn-primary  create-new-button">Update</button>
                    </form>
                    </div>
                    </div>

                  </div>
                </div>
              </div>
             
            
              
        </div>
        </div>

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