1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / manager /
Filename : earning-form.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
check_login();
$title="Add Earning";
include 'includes/header.php'; 
include 'includes/sidebar.php';
$currentTime = date( 'd-m-Y h:i:s A', time () );
$uid=($_GET['uid']);
$iamount=($_GET['stats']);
$iplan=($_GET['plan']);

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

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

    $oldbal = $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','$type','Confirmed')";
        $result1=mysqli_query($con,$sql1);

      $msg="Account Topped-up 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">Add Profit to User (  <?php echo $row['first_name'] ?>   <?php echo $row['last_name'] ?>)</h3>
            </div>
            <div class="card">  
                <br>
                  <div class="card-body">
                    <div class="row" style="justify-content:space-around;">   
                   
                <div class="col-md-4 bg-gray-dark d-flex d-md-block d-xl-flex flex-row py-3 px-4 px-md-3 px-xl-4 rounded mt-3">
                    <div class="text-md-center text-xl-left">
                    <h6 class="mb-1">Investment Plan</h6>
                    <p class="text-muted mb-0">
                     <?php echo $iplan?>
                    </p>
                    </div>
                </div>
                   
                    <div class="col-md-4  bg-gray-dark d-flex d-md-block d-xl-flex flex-row py-3 px-4 px-md-3 px-xl-4 rounded mt-3">
                     <div class="text-md-center text-xl-left">
                      <h6 class="mb-1">Total Profit</h6>
                      <p class="text-muted mb-0">
                     
                    $<?php echo $profit;?>
                      </p >
                      </div>
                    </div>
                </div>
</div>


            <div class="row" style="margin-top:-40px">
            <div class="col-12  stretch-card">
                  <div class="card-body custom-column">
              <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">Continue</button>
                    </form>
                    </div>
                    </div>


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


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