I need a system somehow that sends a Paypal Bill to all the users in a database or something with a bill for a monthly subscription to an advertisement on a site, can anyone suggest a way to do this? Here are some specs: * Must somehow let the database know they have paid when the payment is completed * I dont mind if I have to go to a page and click send bill, I just need a way to make the system automated as far as the billing, checking, and updating database goes. Would prefer to use a MySQL database, but dont mind other solutions, anything to get the job done. Thanks in advance.
First option is to use PayPals reoccuring payment option thus allowing paypal to generate the bills to your customers and from memory it does do an API call back to confirm payment has succeeded/ failed so just consume the callback to update your db. Alternatively there should be an API call for pushing requests for PayPal to invoice if you want. Finally the option is to set up a page on your site, you send out the payment request that contains a link to your site which then passes them off to PayPal as normal to complete the transaction. All are easily enough automated with Cron jobs or equiv
Thanks for the reply mate. Is it possible to have a PHP script that sends a Paypal bill to all the emails in a database when invoked? Is there a tutorial or something that would help me do it?
We don't use PHP but there is no reason why it can't. The best guides are simply on the PayPal site if you're wanting to use their APIs etc