My requirement is to integrate 2 payment gateways(Eway & Stripe) in my website.
This integration should be such that when the customer fills the payment form, certain inputs has to be stored in a remote MySQL database & also should be passed to the gateway though [url removed, login to view], the other hand certain inputs should be only sent to the gateways & some other inputs should only be stored in the MySQL remote database.
FOR EXAMPLE :
A customer fills the following inputs in the form :
3> Landline Number
4> Cell Phone Number
10> Date of Birth
11> IP Address (This will be automatically collected by the form)
12> Service Department
14> Credit/Debit card number (Card type should be automatically detected)
15> Expiry Date
Now Input No: 1,2,3,5,6,7,8,9 & 13 should be both stored as well as sent to the gateway through API.
Whereas, Input No: 4,10,11 & 12 should only be stored in the remote MySQL database AND Input No: 14,15 & 16 should only be sent to the gateway.
ON EACH ENTRY TO THE DATABASE, A UNIQUE ID SHOULD BE GENERATED FOR THAT PARTICULAR ENTRY. NOW, WHEN WE HAVE AN APPROVED STATUS FOR THE PAYMENT & GET THE RESULT FROM THE GATEWAY THROUGH CALL BACK OPTION, THE TRANSACTION ID SHOULD BE STORED IN THE REMOTE MYSQL DATBASE AGAINST THAT UNIQUE ID & THE UNIQUE ID SHOULD BE DISPLAYED IN THE RESULTS PAGE.