Блог

Я установил панель на сервере AWS. Я перевел свой веб-сайт на AWS с общего хостинга Namecheap. когда я перенес свой веб-сайт на веб-сайт AWS, он нормально работал без страницы вывода средств. Затем я попробовал на сервере XAMPP, и он отлично работает. Он не записывает данные в базу данных на сервере AWS.

 <?php 
        include('config.php');
        session_start();
        $uid=$_SESSION['user']['user_id'];
        date_default_timezone_set('Asia/Dhaka');
        $date=date("Y-m-d h:i");
        $status=1;

        $statement290 = $pdo->prepare("SELECT * FROM tbl_member WHERE user_id=?");
        $statement290->execute(array($uid));
        $result290 = $statement290->fetchAll(PDO::FETCH_ASSOC);
        foreach ($result290 as $row290){
        $wcredit=$row290['credit'];
        }
        $amount=$_POST['withdraw_amount'] 10;
        
    if  
        ($amount >= $wcredit)
        {
        $status=0;
        echo json_encode(array("wstatues"=>"<div role='alert' class='alert alert-danger'>
        <strong>Your withdraw amount is more than your balance!</strong>
        </div>"));
        }
    else if 
        ($amount < 500)
        {
        $status=0;
        echo json_encode(array("wstatues"=>"<div role='alert' class='alert alert-danger'>
        <strong>Minimum withdraw 500tk !</strong>
        </div>"));
        }
    if ($status==1){

        $state = $pdo->prepare("SELECT * FROM tbl_member WHERE user_id=?");
        $state->execute(array($uid));
        $results = $state->fetchAll(PDO::FETCH_ASSOC);
        foreach ($results as $row) {
            $credit = $row['credit'];
        }
        $final_amount = $credit-$_POST['withdraw_amount'];
        $statement = $pdo->prepare("UPDATE tbl_member SET credit=? WHERE user_id=?");
        $statement->execute(array($final_amount,$uid));
        $a="0";
        $statement = $pdo->prepare("INSERT INTO tbl_withdraw (request_by, amount, method, send_to, account_type, date, withdraw_status) VALUES (?,?,?,?,?,?,?)");
        $statement->execute(array($uid,$_POST['withdraw_amount'],$_POST['withdraw_method'],$_POST['withdraw_to'],$_POST['account_type'],$date,$a));

        echo json_encode(array("wstatues"=>"<div role='alert' class='alert alert-success'>
            <strong>Your withdraw has been successfully requested!</strong>
            </div>"));
        $id = $pdo->lastInsertId();
        $detail="Withdraw Request By You";
        $date=date("Y-m-d h:i");
        $type="Withdraw-R";
        $statement2 = $pdo->prepare("INSERT INTO tbl_transaction 
        (detail_id, type, description,transaction_date,user_balance)
        VALUES (?,?,?,?,?)");
        $statement2->execute(array($id,$type,$detail,$date,$final_amount));
        }
?>