Connecting to mysql using dreamweaver

In this tutorial I’m going to show you how you can connect your php application to mysql using dreamweaver. If you already know how to connect mysql and php, and you are looking for an alternative way to connect those two together then this tutorial is for you.

Things you’ll need

  • Adobe Dreamweaver – You can use either cs4 or cs5.
  • Wampserver

 

 

Things to do

First open up Dreamweaver. Then create a new site if you haven’t created a site yet.

image

Just name the new site to whatever you want and browse for the site folder. The path should be something like:

c:/wamp/www/newsite

Next, click on the servers tab. Then click on the add button to add a new server.

image

 

On the Basic tab, type in any server name you want. But connect using Local/Network. The server folder should be the root directory or the www directory if you are using wamp. Web URL should be http://localhost since this is only a testing machine where you develop applications. If not then you might want to type in the ip address of the computer where wampserver is installed. It may look something like: http://192.168.250.300:8080. That’s just a sample ip address, don’t go ahead and type that one.

image

Next click on advanced tab. Set server model as PHP MySQL

image

Next, uncheck the remote, and check testing. And click save.

image

Then you have to switch to app developer plus workspace. On the right-hand panel, select the databases tab, then select databases tab again. Click on the add button, and select MySQL Connection.

image

Connection name should be anything you want, MySQL server would be localhost, default username would be root and you can just type in the name of the database  that you are going to work with or just click on the select button and select the database from the list. Lastly, click on the test button to check if you are really connected or not. You might want to launch wampserver first, and that its already online before clicking on the test button.

image

You can now see that the database tab is already filled with table information, views , and stored procedures.

image

 

 

Conclusion

That’s it for this tutorial, next time I’ll be showing you how you can create forms based on the fields on the tables in the database. Of course, this will all be done without actually coding a single line of code.
But I do not actually recommend this method if you are still learning about php and mysql. Because you wouldn’t actually learn how to code things if you do it this way. Its much better if you also know how to code things and fully understanding how they work before you dive in the shortcut methods to accomplish things such as these.

One thought on “Connecting to mysql using dreamweaver

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s