I am creating a product that people can subscribe to on a monthly basis.
I need someone to be able to 'sign up' for the product. So they go to a form to signup. They have to pay for the subscription (PayPal) (monthly subscription). Once they have paid it automatically inserts a new user into my MySQL database and sends the person a confirmation email, including their User Primary Key id and their password (Primary Key should jsut auto increment when someone is added to DB as a new user, also will need to randomly generate a password for them).
It could work where it just inserts the auto incremented primary key and an auto generated password into my database, then emails that info to the person with a link to a page (passing the user_id variable that was just auto generated when they signed up) which i will create where they can enter all their info.
OR, even better,
They can get first month subscription for free then it starts charging their card after 1 month. Still setup the same way as above though.
I am a developer with Pretty good skills in PHP, MySQL, CSS, HTML. So pretty much everything is all set up... except for this checkout process!! ..and a check to make sure the person has been paying when they log in..