Database Connections in Dreamweaver

[awild1]

Ok, Let me give you all some background, I am fresh out of the gate when it comes to PHP and server-side scripting. So hence, I am in the process of setting up a Testing Server in Dreamweaver CS4 to try things and teach myself PHP. I have found plenty of tutorials for setting this up on my local machine, but none that focus on the proper methods when using a service like HM where PHP, MySQL, and APACHE are already installed and running. The following is a rundown of what I have or have done already:

- I have an existing "Site" configured and working for FTP back and fourth in Dreamweaver, but none of the testing server parameters have been filled out.
- I created a folder entitled 'test' in my Public_html folder to house all of this.
- I have gone onto my CPanel and created a new database, a user for it, and set the privileges, then I imported some tables to this database.

What I don't know is how to marry these things together in Dreamweaver using the Site Definitions/Testing Server settings and the Database panel. I have the understanding that at this point all I need is to fill out the proper settings, and I be able to connect to my database. If anyone can let me in on the proper settings or point me in the right direction or let me know if I dont know what I am talking about, I would be eternally grateful. I have spent too much time on this without getting any results. Thanks in advance for your help.

[shadmego]

Greetings.

I have CS2, and the tutorials page for Hostmonster is done in CS3.

http://tutorials.hostmonster.com/dreamweavercs3

The following site is the best I've found to help with the mysql connection through Dreamweaver. I believe this will give you all the information you need to get started.

http://kb2.adobe.com/cps/165/tn_16575.html

The above article is broken into three sections. Don't bother with the first, as you have already configured your mysql environment.

There are two things left out in the above tutorial also:

1. You must have a php page open already. It can be a new page you haven't saved yet, but you have to have a php page open and ready for editing.

2. You get to the database window by going through Windows -> Database
reference this site:

http://www.siteground.com/tutorials/dreamweaver/dreamweaver_mysql.html

Come back if you have any more questions.

~regards

[awild1]

Thanks a TON shadmego, and excellent response time to boot, I'll get started on it right away. As a side note, I was actually lurking on the forum this afternoon too and noticed that you do a great job with helping ppl out. I just want to praise you for your diligence and I LOVE the Jim Ellliot quote too!

Rev 3:20
-- Andy --

[D0gSoldi3r]

Well this isn't the exact answer you're looking for (onorthdaux ways) just telling you how i do things when i want to mess around with PHP on my desktop, I use Joomla for my content management system and i use wamp to be able to display all my php enviroments. WAMP is alot easier to set up than IIS, and generally speaking wamp is the one most people get into when they want to get their hands dirty for the 1st time, because with IIS you need fancy versions of XP or Vista when wamp works on anything. I've mostly just been editing it live on my ftp because i had a few frustrating hard drive crashes a while back and gave up on editing PHP on my desktop. Wamp also has a great community if you ever need help setting it up. Cool little trick wamp can do is broadcast your website from you're pc which i kinda think is a kinda cool feature, not the greatest but it is fun doing it. :D

Never been a fan of Dreamweaver, once i get use to the interface they change it the following year making you feel alienated, but i guess Adobe do that with all their products :)