A client has approached me seeking the following for a web site…
He wants to add ‘Events’ to his site and enter the number of participants that can attend each event. Easy enough.
He then would like to receive deposits for ‘bookings’ made on the site.
So if an event costs an individual £50, and there were 15 places for it, once the payment was made he would receive 10% of the £50 through PayPal and confirmation of this would then update the MySQL database to say only 14 places were available.
Should I be looking to use PayPal IPN along with PHP and a MySQL database. I’m comfortable with the last two, but never used PP IPN.
I assumed the SQL table structure could be:
attendees - if necessary
id | username | email | event_id
id | event_id | date_of_payment | paypal_email_id | amount
id | date_of_event | title_of_event
Is this the right way? Where should I start with PayPal integration?
Thanks for any helpers.