One Hat Cyber Team

Your IP : 216.73.216.186

Server IP : 88.222.243.152

Server : Linux in-mum-web1837.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64

Server Software : LiteSpeed

PHP Version : 8.2.28

Buat File | Buat Folder

Dir : ~/home/u322583024/domains/awaha.in/public_html/

View File Name : save-payment.php

<?php
include 'admin/connection.inc.php'; // Include your database connection

// Set timezone to IST
date_default_timezone_set('Asia/Kolkata');

// Capture the current IST time
$payment_done_on = date('Y-m-d H:i:s');

$order_id = $_POST['order_id'];
$user_id = $_POST['user_id'];
$total_amount = $_POST['total_amount'];
$billing_name = $_POST['billing_name'];
$billing_address = $_POST['billing_address'];
$billing_city = $_POST['billing_city'];
$billing_state = $_POST['billing_state'];
$billing_zip = $_POST['billing_zip'];
$billing_phone = $_POST['billing_phone'];
$billing_email = $_POST['billing_email'];
$company_name = $_POST['company_name'];
$payment_method = $_POST['payment_method'];
$razorpay_payment_id = $_POST['razorpay_payment_id'];
$order_status = $_POST['order_status'];
$cart_ids = $_POST['cart_ids'];
$products = $_POST['products'];
$created_at = date('Y-m-d H:i:s'); // Also set created_at in IST

$query = "INSERT INTO orders (order_id, user_id, total_amount, billing_name, billing_address, billing_city, billing_state, billing_zip, billing_phone, company_name, payment_method, razorpay_payment_id, order_status, cart_ids, products, created_at, payment_done_on) 
VALUES ('$order_id', '$user_id', '$total_amount', '$billing_name', '$billing_address', '$billing_city', '$billing_state', '$billing_zip', '$billing_phone', '$company_name', '$payment_method', '$razorpay_payment_id', '$order_status', '$cart_ids', '$products', '$created_at', '$payment_done_on')";

if (mysqli_query($conn, $query)) {
    // Clear the cart after successful order insertion
    $delete_cart_query = "DELETE FROM cart WHERE user_id = '$user_id'";
    mysqli_query($conn, $delete_cart_query);

    echo json_encode(["status" => "success", "razorpay_payment_id" => $razorpay_payment_id]);
} else {
    echo json_encode(["status" => "error", "message" => mysqli_error($conn)]);
}

mysqli_close($conn);
?>