MySql Connection Problem

[Terry_Lowndes]

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

[Newsgroup_User]

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/

[StormyCrow]

Wow! David Powers! Hey - Listen to this guy, he knows his stuff and writes really great books about this.

[Terry_Lowndes]

David,

Thank you very much for you post and the information you supplied. Yes, the book I am using is very old and yes I am still using MX. One day I hope to be able to upgrade (money is the only obstacle)!!! However, despite your comments I guess I should still be able to make a connection if I can get teh "Testing Server Folder" right and then I could work through the DreamweaverHotel information to at least make some progress with learning PHP and MySQL.

Regards,

Terry

[Newsgroup_User]

Terry Lowndes wrote:
> Thank you very much for you post and the information you supplied. Yes, the
> book I am using is very old and yes I am still using MX. One day I hope to be
> able to upgrade (money is the only obstacle)!!! However, despite your comments
> I guess I should still be able to make a connection if I can get teh "Testing
> Server Folder" right and then I could work through the DreamweaverHotel
> information to at least make some progress with learning PHP and MySQL.

I read the book that uses the Dreamweaver Hotel case study a long time
ago, and remember that the Glasshaus edition had quite a few mistakes in
it. The errata were posted on the Glasshaus website, but no longer exist
because the book was acquired by Wiley after the Glasshaus/Wrox collapse
in 2003. I don't know if the errata have been picked up by Wiley.

The implementation of PHP/MySQL in Dreamweaver MX was rather poor. It
produces insecure and outdated code. If you're not in a position to
upgrade, you would probably be better off learning to hand code PHP.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/