Hello everyone, we are in need as a payment process script between MySQL and PayPal. We are using the PayPal payflow Pro gateway.

We need a store procedure written within MySQL that will take credit card information and process it with PayPal. We are using PayPal payflow Pro gateway.

This is what we need exactly:

We need a store procedure that:

  1. Receives input variables for the credit card number, expiration month, expiration year, CC code, address, city, state, zip code, account number, and the amount to process.
  2. Process the payment threw PayPal payFlowPro.
  3. Inputs results into database table called transaction history