login script

I am making a site and I would like to have something which allows users to login, create a account, and are able to go to a page where they can edit their information (ex: change password, where they live, etc.). I have MySQL and Microsoft SQL installed (I don't know which one is better)

I am not sure how to link the text boxes with the database so users can login or create an account. It would also be nice if somebody could tell me how to make an error messages appear if information is invalid.

I am good at programming but i am new to working with a database.

If anybody has a template with all this set up so I could build the site around the template that would be great.

Here are my columns:

Username
Password
Day_Birth
Month_Birth
Year_Birth
Email
First_Name
Last_Name
Country
City
State_Province
IP (im not sure how to retrieve the ip address)
Date_Created
ID

First of all, what server side language are you using in building up your site? ASP, PHP or maybe .NET?

Of course MySQL is better than MSSQL! Not just it is free and widely used, but they are fast!
Some people thinks MSSQL is better then MySQL, but that depends on your main usage! Other people just admire and love MySQL.

The advantage of MySQL over Access(MSSQL) is scalability, MySQL handles multiple user connections better and is far better suited to web applications.However Access is far easier to use and set up, to be quite frank I once messed about trying to set up MySQL for about 2 hours. I got nowhere, gave up and tried a few times again before I successfully installed them.

Access is a good PERSONAL database application, but is not server sofware and is not suited for simultaneous user connections...which web apps, by nature, require...

So back on topic...

If you are using ASP, then you can just check out my very own ASP-MySQL Login Tutorial in the ASP Forum here in webforumz!
If it is PHP then, you might want to visit this lovely PHP Login Script that I found really interesting!

Hope that's help you
Cheers...

If your just starting out with PHP and MySQL i would recommend using Dreamweaver as it does a lot of the database code in just a few clicks.

I know a lot of people here will kill me suggesting to use it but tbh i love using it as it cuts coding time down so much when working with databases

That's is totally the opposite way to learn. The proper way is like this

If your just starting out with PHP and MySQL, I would recommended you to hard coded (manually typing) your page without the help form any WYSIWYG program such as DW. That way you learn and you know every single code that you see on the screen!

When you do feel comfortable and expert enough later in the day, then I would recommend using Dreamweaver as it does a lot of the database code in just a few clicks.

That's is my humble opinion

Not going to kill you, but I will disagree strongly IMO, it's a huge mistake in the long run unless you just want to mess around and have a little fun. It's like learning how to swim in the kiddie pool.

If I had to choose one db program, I'd also pick MySQL. If you learn any flavor of SQL, it's pretty easy to transition to another, i.e. 80-90% of what you learn from MySQL will apply to MSSQL.

i think it down to time. If you have a lot of spare time to learn it all then go the coding way, but if your like me and spare time is a rare thing Dreamweaver is an excelent product.

I would be great if I could use Dreamweaver for it but for some reason I will not detect my MySQL database. Here is the information I am entering:

server: localhost
username: root
password: ************
database: database1

I have created that database andhave the correct password but can not connect.

mysql by default has no password, just blank. Unless you set one in which case i'll get me coat...

Do you use WAMP?
If you do, I have a tutorial on how to set up your PHP and MySQL in a window based operating system

wamp, xampp - cramp and damp, whatever next

I use xampp, btw, really easy to set up. I have installed apache, php and mysql manually before - never again

Nice flow there

could some body PLEASE answer my original question. Does anybody know a really good template for this so i dont have to do the programming and tell me why dreamweaver doesn't connect. I have all the information that is showed above with a correct password. And i downloaded MySQL from here http://dev.mysql.com/get/Downloads/M...m/pick#mirrors
and it wont connect to dreamweaver.

Your question was answered. If you need more instruction (like a hand held walkthrough) then you're in the wrong place.

As I've work with MICROSOFT ACCESS (MSSQL) Database before, connecting MySQL Database is much more simple and even the way you tell your PHP page to connect to the database is really simple!

What do you mean by "it wont connect to dreamweaver"? What error you are getting?
This might be your MySQL Installation Setting problem. I've learn that from Lynda.com as I've mention before in my post ^

1. Setting Up PHP 5 for Windows with Apache or IIS
2. Setting Up MySQL 5 for PHP in Windows