File "payment-successful.php"

Full Path: /home/magicrsz/public_html/Paypal/admin/assets/payment-successful.php
File size: 1.13 KB
MIME-type: text/x-php
Charset: utf-8

<?php
session_start();

//Include DB configuration file
require_once("../admin/database.php");


$user_id=$_SESSION['user_id'];
$order_id=$_SESSION['order_id'];


$query="UPDATE orders SET payment_status='paid' where user_id='$user_id'  AND order_id='$order_id'";
$run=db::query($query);

//inventory manage
$getOrderDataQuery = "SELECT * from order_detail where order_id='$order_id'";
$getOrderList = db::getRecords($getOrderDataQuery);

foreach($getOrderList as $k => $orderData) {
    $product_id = $orderData['product_id'];
    $size = $orderData['size'];
    $quantity = $orderData['quantity'];

    $getSizeQuery = "SELECT * from sizes where product_id='$product_id' && size='$size'";
    $getSizeData = db::getRecord($getSizeQuery);

    $remainQuantity = $getSizeData['quantity'] - $quantity;

    $updatequery="UPDATE sizes SET quantity='$remainQuantity' where product_id='$product_id'  AND size='$size'";
    $runQuery=db::query($updatequery);
}

$query="DELETE from temp_cart where user_id='$user_id'";
$del=db::query($query);


echo "<script>location='../final_message.php?payment_paypal=paid'</script>";


?>