How do I allow guests on my site to have accounts so they can have interactivity with certain site features.?

Question

I know I need the MySql DB, but I cannot figure out how to connect the registration page I built to the SQL DB. What's up?

Answer 1

You can actually do this with html and javascript but the passwords will not be totally secure for anyone who has the right knowledge. Does that matter?

You can also do this with server side processing.
So now the question. What do you want a database for? Well it is good to have as a buzz word but if you don't know how to use one then why have it?
Using text files can be simple, flexible and easy to program without a great deal of knowledge.

If you must persist with the database then be prepared for all the learning that you will have to do.

Good luck.

Answer 2

In your php or whatever scripts set security levels for the secure pages into the script, this could look up the database for a level set against the user and make a decision based on it. You can then choose the people you want to give access and set a level for each person. This way you can have multiple levels.

Answer 3

I run ASP.NET on my dynamic web site with an ADODB back end (access). You create a "connection string" which allows your dynamic web server application to query the DB.

You will need some sort of server side application written in PhP, or ASP.NET instead of, or along side of, html.

Answer 4

I agree with all of the above if you are into programming.
But a quick and dirty solution would be to install some free full featured application like PHP-Nuke where many such options are already available and it's also customizable.

Answer 5

You are going to require a server-side backend dynamic language such as php or ASP.net to communicate with your SQL.

I first learned about it with the book 'PHP & MySQL for Dummies' - great read!