false, 'messages' => array()); if($_POST) { $orderId = $_POST['orderId']; $payAmount = $_POST['payAmount']; $paymentType = $_POST['paymentType']; $paymentStatus = $_POST['paymentStatus']; $paidAmount = $_POST['paidAmount']; $grandTotal = $_POST['grandTotal']; $updatePaidAmount = $payAmount + $paidAmount; $updateDue = $grandTotal - $updatePaidAmount; $sql = "UPDATE orders SET paid = '$updatePaidAmount', due = '$updateDue', payment_type = '$paymentType', payment_status = '$paymentStatus' WHERE order_id = {$orderId}"; if($connect->query($sql) === TRUE) { $valid['success'] = true; $valid['messages'] = "Successfully Update"; } else { $valid['success'] = false; $valid['messages'] = "Error while updating product info"; } $connect->close(); echo json_encode($valid); } // /if $_POST