squireless

Back Back Up Advanced Editor

<?php
session_start();
require_once('vendor/autoload.php');
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_stripe=paid'</script>";