We need a User registration system similar to the one provided at [url removed, login to view]
The back-end needs to be written in PHP / MYSQL.
Preferably it should be be implemented in Adobe Flex with an AMFPHP Backend.
Other solutions will be considered as well.
User input needs to be validated before the registration form can be submitted.
Each email address must be unique and can't exist twice in the database.
The provided email is used as login name and can not be changed later on.
The registration form just needs a standard white background and black foreground colors.
Once a user has filled out all required form items he will get an email confirmation with an activation link.
After clicking on the activation link his account will be enabled and he can log in to the system to review, change his details.
After a user logs in he has the option to buy a monthly recurring subscription that is payable through paypal.
We have 4 products for sale. Each product can be configured with addons.
The price of the monthly subscription will depend on the product and how many addons.
For this to work flexible the implementation needs to be able to read the pricing model from two database tables: products and addons
e.g. products table + content
name | price
product1 | 30
product2 | 40
product3 | 50
product4 | 60
e.g. addons table + content
name | price
addon1 | 10
addon2 | 20
If the payment was successful, the date and the amount of the payment needs to be stored in the user database. If a subscription is canceled the last_payment_date field and last_payment_amount fields need to be set to null
Required fields for sign up form
First Name //required
Last Name //required
email //required, must be unique in database
Country //required - choose from combobox - use another database table with countries as dataprovider
repeat password //passwords must match - min length 5 chars
e.g. client database table fields
account_activated // 0 or 1