1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / machineswift.net / admin /
Filename : remove-profit.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.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'];

      $oldbal = $row['profit'];
      $newbal = $oldbal - $amount;

      $sql1="UPDATE `users` SET `profit`='$newbal' WHERE `id`='$uid' ";
      $result1=mysqli_query($con,$sql1);
    if($result1){ 

      $sql1="INSERT INTO `transactions` (`user_id`,`amount`,`type`,`status`)
                                 VALUES ('$uid','$amount','Deduction','Confirmed')";
      $result1=mysqli_query($con,$sql1);

      $msg="Profit Deducted Successfully";
      $type = "success";
      }else{
      $msg="something went wrong,please try again";
      $type = "warning";
      }  
}


?>

<!-- partial -->
<div class="main-panel">
          <div class="content-wrapper">
            <div class="page-header">
              <h3 class="page-title">Deduct Profit - <?php echo $row['first_name'] ?> <?php echo $row['last_name'] ?> </h3>
            
            </div>
            <div class="row">
              
            <div class="col-12  stretch-card">
                <div class="card">
                  <div class="card-body custom-column">
                    <h4 class="card-title">
                   
                    Current Profit: $<?php echo $row['profit'] ?>
                    </h4>
                    <p class="card-description">Please enter the amount you want to deduct</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">
                        <label>Enter amount(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">Deduct</button>
                    </form>
                    </div>
                    </div>

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

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