Forum Moderators: buckworks
I'm now working on a subscription service that will exclusively accept Paypal. I'm just wondering how automated I can get things. I have a mySQL database set up with customer records in it, and I'm wondering if there is any way I can update the database with input from Paypal.
I'm just wondering if it's possible for me to set things up so it proceeds as follows:
A) User signs up for free and logs into site.
B) After logged in, user decides they want to pay to get on my mailing list. They click on subscribe which takes them to Paypal. Upon completion of payment their record in my database gets updated so that they are automatically on the mailing list.
C) This part isn't necessary, but it would be handy if, when they cancelled their subscription, I could update their record to say that they no longer should receive the newsletter. I could do this part manually though, because it's not as important to remove them in a timely fashion as it is to get them on the mailing list immediately.
-------------------------
I'm not familiar with the ins and outs of Paypal, but I guess I'm essentially asking if it's possible to have the subscribe button send the username in a hidden form to Paypal, and then upon completion of payment the user gets sent to a page on my site that receives the username in a hidden form and updates their record so that they are on the mailing list.
The only problem I can see with this is that once somebody subscribes they could just bookmark the page that adds them to the mailing list, allowing them to sign up for free any time they wanted.
As usual, I'm probably missing some simple solution to my problem. I just need to be sure people pay before they get on the mailing list, and I need them to be added to the list immediately after they pay. I would hate to have to manually add each person to the list all day long so that they won't miss their first newsletter.
Any help would be appreciated, and I thank you in advance.
