$connection->connect(); $fe1 = new FileEditor("log.txt"); $fe1->writeToFile("Run"); try { $verified = $listener->processIpn(); } catch (Exception $e) { // fatal error trying to process IPN. $fe1->writeToFile($e); exit(0); } if (isset($_GET['submission_id'])) { $id = $_GET['submission_id']; } else { $id = 22; // debug } if ($verified) { $post_data = $listener->get_post_data(); $transaction_id = $post_data['txn_id']; $payment_gross = $post_data['mc_gross']; $status = $post_data['payment_status']; $payer_email = $post_data['payer_email']; //not seen by user, so no error redirection try { $connection->insert("insert into confirmation (registerid, total, payment_status, transaction_id, payer_email) values({$id}, {$payment_gross}, '{$status}', '{$transaction_id}', '{$payer_email}');"); } catch (Exception $e) { $fe1->writeToFile("ERROR: " . $e->getMessage()); } } else { $fe1->writeToFile("Failure"); }