How to track sandbox Paypal recurring transactions in Wordpress by manually with MySQL
Try this mate, I think it will help you,
<?php /* Template Name: All Payments History */ get_header(); echo "<pre>";print_r($_REQUEST); global $wpdb; //global query variable $wpdb->show_errors(); if (!empty( $_REQUEST) && $_REQUEST['st']=='Completed'){ $wpdb->insert('wp_paypal_payments_tracking', array( 'transaction_id' => $_REQUEST['tx'], 'transaction_status' => $_REQUEST['st'], 'amount' => $_REQUEST['amt'], 'currency_type' => $_REQUEST['cc'], 'item_number' => $_REQUEST['item_number'], )); echo "Payment Done Successfully, We will update you soon!!!"; } get_footer(); ?>