Skip to main content
Participant
July 10, 2008
Question

MySql Connection Problem

  • July 10, 2008
  • 4 replies
  • 395 views
I'm trying to set up a site on my local standalone PC to run the Dreamwearver Hotel tutorial to learn PHP/MySQL but I can't get the connection to work. To make installing Apache/PHP/MySQL easier I've used the Wamp installer to install all three programmes automatically.The file setup is as follows:-
C:\wamp\bin\apache\
C:\wamp\bin\mysql\
C:\wamp\bin\php\
The site folder is located at C:\wamp\www\DreamweaverHotel\ and the MySQL database is located at c:\wamp\bin\mysql\mysql5.0.51b\data\DreamweaverHotel\ (I've succesfully created the database through phpMyAdmin).
When it comes to site definition I'm confused about what to enter for the "Testing Server Folder" and I'm confused about what to put in the MySQL Connection dialogue fields.
As you can tell from my question I am a complete novice when it comes to dynamic sites but until now I have had no problems setting up standard sites.
I'd appreciate any help you can give.
Thanks,
Terry
This topic has been closed for replies.

4 replies

Inspiring
July 10, 2008
Terry Lowndes wrote:
> When it comes to site definition I'm confused about what to enter for the
> "Testing Server Folder" and I'm confused about what to put in the MySQL
> Connection dialogue fields.

Testing server folder: C:\wamp\www\DreamweaverHotel\
URL prefix: http://localhost/DreamweaverHotel/

MySQL Connection: localhost

If you're using "DreamweaverHotel", you're using a very old book
(written for Dreamweaver MX). If you're using Dreamweaver MX, you should
be aware that it uses outdated and insecure code. If you're using
Dreamweaver 8.0.2 or CS3, be aware that there have been several
important changes to the Recordset dialog box.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Participant
July 10, 2008
Wow! David Powers! Hey - Listen to this guy, he knows his stuff and writes really great books about this.