1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / promarketindex.site / admin /
Filename : add-investment-user.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']))
{
    $plan=$_POST['plan'];
    $amount=$_POST['amount'];

      //Check for the last login and give the user a bonus
      $sql = "SELECT * FROM `investment` WHERE `id`='$plan' AND `status`='1'";
      $res = mysqli_query($con, $sql);
      $planres = mysqli_fetch_assoc($res);
      $oldbal = $planres['amount'];
      $newbal = $oldbal + $amount;

      $sql1="INSERT INTO  `investment` (`user_id`,`amount`,`plan`,`status`) 
                                VALUES ('$uid','$amount','$plan','1')";
      $result1=mysqli_query($con,$sql1);
    if($result1){ 

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

      $msg="Investment Added Successfully";
      $type = "success";
      }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">Add Investment - <?php echo $row['first_name'] ?> <?php echo $row['last_name'] ?></h5>

              
            <div class="col-12  stretch-card">
                <div class="card">
                  <div class="card-body custom-column">
                    <h4 class="card-title">
                    <?php 
                    $query = "SELECT * FROM `investment` WHERE `user_id`='$uid' ";
                    $result = mysqli_query($con, $query);
		    		$sum = 0;
                    while($r=mysqli_fetch_array($result))
                    { 
					   $amount = $r['amount'];
					   $sum += (int)$amount;
                    }  
		            ?>
                    Current Investment: $<?php echo $sum?>
                    </h4>
                    <p class="card-description">Please enter the amount you want to add and select the package you want to top-up</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>Investment Plan</label>
                        <input type="text" name="plan" class="form-control form-control-white"  
                        placeholder="e.g Starter,Gold,Silver" required>
                      </div>
                        <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">Add Investment</button>
                    </form>
                    </div>
                    </div>

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

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