Publishing System Settings Logout Login Register
Integrating MySQL to build a Login Application
TutorialCommentsThe AuthorReport Tutorial
Tutorial Avatar
Rating
Add to Favorites
Posted on August 13th, 2005
14407 views
Adobe DreamWeaver
download sample files
View Sample Page


Requirements:
Dreamweaver MX (2004)
A Page with a login form (download sample)
A MySQL table providing a username and password to login with


Intro:
In the previous tutorial, we learnt how to set up a local testing server using Dreamweaver. This tutorial extends on that topic by adding MySQL support. This way we can access our Database through Dreamweaver and it will be a lot easier to code database commands and we can see the database layout right in Dreamweaver. As an example of how to do this, I will be creating a little login page which requires MySQL to validate the inputs from the user. And to make the whole thing even easier, we will even let Dreamweaver build the login script FOR US! Minimum Effort for a Maximum output.


The Tutorial:
First off, we want to open the example file or any other file you have created which includes a login form. Make sure that you are using you�re local testing server which we set up in the last tutorial. My Dreamweaver currently looks like this:
Support Image - Not neccesary to understand Tutorial

If you�re Dreamweaver looks a bit differently, this might be because you chose the �Design View� as a standard the first time you ran Dreamweaver. I am currently using the �Coder View�. There is no difference in performance, it just rearranges the windows to suit coders.

As you can see on the bottom left, I am using my local server I set up in the first tutorial. The great thing is that now I can see all images and files in that folder in just one click and open or delete them. Above that you can see my �Server Behaviours� window, which we will be using in a second. If you do not have these two windows open, you can do so by accessing the �View� Menu in your Toolbar and choosing �Files� and �Server Behaviours�.

First off we want to establish a connection to our MySQL database. For this we have to use the �Server Behaviours� Window. Click on the plus (+) sign and select �Recordset� from the menu. Now a little box will ask you for your MySQL Connection details. This should be very straight-forward, if you don�t understand something click on the help button or contact me
Support Image - Not neccesary to understand Tutorial



This little screenshot should illustrate what you should be doing right now. Remember to name your connection something that�s easy to remember, as you will have to refer to it later.
After defining a MySQL connection you select the table you want to retrieve the data from, in our case the table with your login info. Mine is called �login�, therefore the name of the connection. Leave the rest of the settings as they are and choose OK. Congrats, you have built your first Dreamweaver MySQL Connection. In the window �Server Behaviours� you can now see your table has been indexed
Support Image - Not neccesary to understand Tutorial

Now you want to build your login script. This can become a little hassle when you code it yourself, so why not let Dreamweaver do it for us. Click on the plus(+) sign again and this time select �User Authentication > Log In User�, as displayed below
Support Image - Not neccesary to understand Tutorial

Now a little pop-up box appears. You enter the information it requests, below is a screenshot of the input I provided to make the example page work.
Support Image - Not neccesary to understand Tutorial

A little description of what every field requires:

Get input from form: Select the form which will serve as the login form. For this to function your form will have to have a name, mines called �login�
Username field: Select the name of the text field where the user inputs their name
Password field: Same as above, only select the password field

Validate using connection: Here you select the connection we just made. As you will remember mine was called �twodded�.
Table: Select the table you want to retrieve the login data from
Username Column: The column in the table which contains the username
Password column: Same as above, only select password column

The rest are extremely self-explanatory. As you can see if the login succeeds, my user will be redirected to Google, if it fails he will be directed to Yahoo. After selecting the OK button. You will notice a bunch of PHP code at the top of your page. Do not edit this, as this is the code which makes the magic work. Also there will be 2 new folders in your Server directory called �Connections� and �_mmServerScripts�. These folders stores all MySQL connection you will ever create on that server, and all scripts necessary for the login. Also be very careful not to delete those as they are also vital for a functioning website. If you now select F12 to test your page, you will have a working login script in a fraction of the time you normally would.

Hope you enjoyed this tutorial and learned something new wink.gif
Premium Publisher
Dig this tutorial?
Thank the author by sending him a few P2L credits!

Send
Apache

CSS and Standards Passionate. When not
designing websites, he blogs away on the
Useless-List.com, his personal website
View Full Profile Add as Friend Send PM
Pixel2Life Home Advanced Search Search Tutorial Index Publish Tutorials Community Forums Web Hosting P2L On Facebook P2L On Twitter P2L Feeds Tutorial Index Publish Tutorials Community Forums Web Hosting P2L On Facebook P2L On Twitter P2L Feeds Pixel2life Homepage Submit a Tutorial Publish a Tutorial Join our Forums P2L Marketplace Advertise on P2L P2L Website Hosting Help and FAQ Topsites Link Exchange P2L RSS Feeds P2L Sitemap Contact Us Privacy Statement Legal P2L Facebook Fanpage Follow us on Twitter P2L Studios Portal P2L Website Hosting Back to Top