.-.-.-.-.-

<?php

session_start();
include('../connection.php');
include '../function_lib.php';

if (isset($_POST['submit'])) {
    $login_id = $_POST['uid'];
    $uid = mysqli_fetch_object(mysqli_query($connection, "SELECT uid FROM user WHERE login_id = '$login_id'"))->uid;
    if(!empty($uid)){
    $amount = $_POST['amount'];
    //$pmode = $_POST['pmode'];
    $month = $_POST['month'];
    $year = $_POST['year'];
    $date = date('Y-m-d');

$referid = mysqli_fetch_object(mysqli_query($connection, "select refer_id from user where uid = '$uid'"))->refer_id;
    $sql_insert_amount = "INSERT INTO invest_amount (amount, uid, month, year, date ) VALUES($amount, $uid, $month, '$year', '$date' )";
    mysqli_query($connection, $sql_insert_amount);
    $iaid = mysql_insert_id();
    if ($iaid) {
        $commission_amount = $amount * 0.1;
        $sql_insert_commission = "INSERT INTO invest_commission (iaid, uid, amount, date ) VALUES($iaid, $referid, $commission_amount, '$date' )";
        mysqli_query($connection, $sql_insert_commission);
        setMessage('Successfully done', 'succ');
        redirect('invest_done.php?id='.$iaid);
    } else {
        setMessage('Some error occur. Please try again', 'error');
        redirect('invest.php');
    }
    }
}
redirect('invest.php');
?>

/home2/wtmwscom/public_html/doc/../admin/styles/../invest_model.php