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:
- 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.
- Process the payment threw PayPal payFlowPro.
- Inputs results into database table called transaction history