I have a website that offers information on a particular subject. I want visitors to be able to click and sign up with their information so they can get access to members section. Additionally there will be a paid members section as well. I need scripts to communicate the following between the website and database. Login/logout, registration, edit profile, upgrade membership, and so on so forth. Most of this should be basic to the average programmer but I don't have time to learn the scripting language. I would like scripts to be in PHP to communicate with my MySql database that came with my webhost package
A. When user enters their email and password, information goes to database, checks for errors and then either returns user to I. Finds in members database and directs to 8. II. Finds in gold members database and directs to 11. III. Doesn’t find and directs to 7. B. When user clicks to edit profile database takes their name, email, and password and sends to blank spots on the page 9. C. When user clicks the change button the information will automatically update the members database and direct them to 8. D. When member clicks submit, their information is moved from members database to gold database and they are directed to 11. E. When user clicks to edit profile database takes their name, email, and password and sends to blank spots on page 12. (This will be similar to B. with the exception that each page (1 for members, 1 for gold) will have a different template. F. When user clicks the change button the information will automatically update to gold members database and direct them to 11. G. When user clicks logout, they will be logged out and directed to 1. H. When user clicks submit the information is not moved to a database but held, user will be redirected to 4. I. If user clicks no, information that was previously held over from H. is moved to members database and email is automatically sent to their email address that must be confirmed. (This is optional, an alternative would be just a redirect to 8.) J. When user clicks submit for payment they are redirected to 11. logged in and the information that was held over from H. should be moved to gold members database.
Here is the information about the server provided by my webhost company operating system FreeBSD 4.11-STABLE mysql version mysql Ver [url removed, login to view] Distrib [url removed, login to view] perl version perl, v5.8.3 php version PHP 4.4.1