get_wallet_amount($_SESSION['user_id']); $db->query("INSERT INTO `payments`(`zar`, `user_id`,`booking_id`) VALUES ('-$wallet_amount','{$_SESSION['user_id']}',{$_GET['booking_id']})"); } $payment_id = $db->query("INSERT INTO `payments`(`zar`, `user_id`,`booking_id`) VALUES ('$_GET[amount]','{$_SESSION['user_id']}',0)"); $payment_id = $db->query("INSERT INTO `payments`(`zar`, `user_id`,`booking_id`) VALUES ('-$_GET[amount]','{$_SESSION['user_id']}',{$_GET['booking_id']})"); $db->query("INSERT INTO `visit_trans`(`amount`, `user_id`, `booking_id`, `payment_id`,`type`) VALUES ('1','{$_SESSION['user_id']}',{$_GET['booking_id']},$payment_id,'{$_GET['type']}')"); $db->query("INSERT INTO `visit_trans`(`amount`, `user_id`, `booking_id`, `payment_id`,`type`) VALUES ('-1','{$_SESSION['user_id']}',{$_GET['booking_id']},0,'{$_GET['type']}')"); $db->query("UPDATE `bookings` SET `status` = 1 WHERE `record_id` = {$_GET['booking_id']}"); echo ""; } if (isset($_GET['credits'])) { $payment_id = $db->query("INSERT INTO `payments`(`zar`, `user_id`,`booking_id`) VALUES ('$_GET[zar]','{$_SESSION['user_id']}',0)"); $payment_id = $db->query("INSERT INTO `payments`(`zar`, `user_id`,`booking_id`) VALUES ('-$_GET[zar]','{$_SESSION['user_id']}',-1)"); // get park package $package_res = $db->query("SELECT * FROM `park_prices` WHERE `record_id` = {$_GET['credits']}"); $package = $package_res->fetch_assoc(); $db->query("INSERT INTO `visit_trans`(`amount`, `user_id`, `booking_id`, `payment_id`,`type`) VALUES ('{$package['credits']}','{$_SESSION['user_id']}',0,$payment_id,'PARK')"); echo ""; }