I am trying to learn how to create a mysql database using macromedia Dreamweaver MX 2004 and php. I am a newbie to php and mysql. I have been using Dreamweaver for many years building static sites.

I need to learn how to build dynamic web sites using Dreamweaver, PHP and mysql.

My plan of attack is to set up on my local computer apache 2.0.50.(win 32) server, php 4.01, and mysql server -mysql 4.0.20d-win.

After I am successful in learn how t do this on my local computer I will then move everything to my remote Linux server.

I have installed apache, mysql and php on my local computer. I also have installed Dreamweaver.

I am having a problem getting php and apache to work together. I have apache info as follows from the conf file:

Server root = C:/Program Files/Apache Group/Apache2/
Server Admin = my email address
Server Name = business-net.com One of my domains
Document Root = C:/Program Files/Apache Group/Apache2/htdocs
Directory = C:/Program Files/Apache Group/Apache2/htdocs
UserDir = My Documents/My Web Sites
Directory Index = index.html index.html.var

I went into Dreamweaver and set up the site definitions for php:

Local Site:
Site name = RU Playing
Local Root Folder = C:\Documents and Settings/Robert/My Documents/My Websites/ruplaying-php/
Default Image Folder = C:\Documents and Settings/Robert/My Documents/My Websites/ruplaying-php/Images/
Remote Site:
http:// address = http://ruplaying.com/
Remote Folder = C:\Documents and Settings/Robert/My Documents/My WebSites/ruplaying-php/
Images/

Testing Server:
Server Model = PHP Mysql
Access = Local/Network
Testing Server Folder = C:\Documents and Settings/Robert/My Documents/My Websites/ruplaying-php/
URL Prefix = http://localhost/ruplaying-php/

When I test a piece of php code in index.php I get he following
when I try to display it in live data view I get the following:

http error 2 occurred while attempting to request the file http://localhost/ruplaying-php/index_c967csopq.php from the server.

Here are some possible reasons for the problem:
1) Files in the “C:/Documents and Settings/Robert/My Documents/My Web Sites/replaying-php/”
Folder that have “.php” file extensions are not being processed by the Testing Server.
2)The C:/Documents and Settings/Robert/My Documents/My Web Sites/replaying-php/” folder does not map to http://localhost/ruplaying-php/ URL on the testing server. Verify that the URL Prefix maps to the root of your site.

If I put http://localhost/ruplaying-php/ in a browser, I get the following:

Index of /ruplaying-php
Name Last modified Size Description
________________________________________
Parent Directory -
Images/ 03-Mar-2005 08:55 -
index.php 03-Mar-2005 08:51 377
________________________________________
Apache/2.0.50 (Win32) Server at localhost Port 80


From here I am lost and do not know what to do?

After I confirm that PHP is working on my computer, the next phase is to build the database with mysql
Again using Dreamweaver and php.
Any help in this area would be appreciated

Your testing folder is wrong in dreamweaver.

You said:
...Testing Server Folder = C:\Documents and Settings/Robert/My Documents/My Websites/ruplaying-php/

I believe your LOCAL ROOT folder setting is right. But the TESTING folder should be:
C:/Program Files/Apache Group/Apache2/htdocs/
...If that is where your Apache is installed.

I made that mistake too. That is where dreamweaver is going to look for the Apache server/php parser...



But before I figured it out I was like WTF..

another thing to mention
if i'm right apache and php dont like directories that have a space in the name. I know that when i was installing php, mysql and apache on my computer i was warned several times about this...

some setups of mysql clients wont allow dreamweaver to connect with it. i always make my sites localls with a local setup of apache, sql and php prebundled enovative dose this and many others. i then copy the sql from phpmyadmin into my remote host and upload my connection file cloak my local connection folder and edit it to my local details so i can still test and connect via both without having to change setting all the time

brokensoul2271 is right best to use _ or - and be careful with capitals linux hosts can have folders named: Folder and folder in the same directory both completely different

Dreamweaver is a designer and coder package. You cannot create a complete package with this.

If you want to test your php and html packages, then please look into a php/server

Appserver will do this in one download and install. Search google for appserve and install it. If not, then you will never run what you want in dreamweaver

Steve

I used XAMPP. It prebundles PHP/MySQL/MySQL Admin/Apache together in a neat clean install. Only thing you have to do is set up security if u have multiple users. But it got me up and running very quickly. Did my first content management system as a result.

Try Google for it.

i use XXAMP as well but i have one problem with it the sql seems different to the sql commands used on my host. it puts alot of commands in which arnt needed and i seem to have to edit it all the time but i cant falt it for beaing easy to use and install

really I haven't experienced that but thats because I am running it locally. How do you get around that issue?

Do you think that I would have that issue when I move my PHP/MySQL sites to a host? or is it probably a host specific issue?

good input

I've got my testing server set up so that the pages display in IE, but without the PHP includes...also Firefox and Netscape only show the Source Code when previewing on the testing server.
The file works fine when posted on the actual server.

Testing Server Settings:
Model: PHP/MySql
Access: Local/Network
Testing Server Folder: C:\Program Files\Apache Group\Apache2\htdocs\testing\
http://localhost/testing/

Am I missing something?
Waffles

Thats something i don't lyke with dreamweaver it's better when wirtting a scripts use notepad

PHP has to be parsed through a server. you can't "run" it straight off the hard drive.

This forum seems to be very cut and dry unlike confusing advice from others. So let's see if I can be. First, I installed XAMPP for dummies and Mac Os X users. I'm running 10.4.6 and ran my UNIX TERMINAL to fire up the new software. Awesome as it did most everything I need. I even configured the config.inc.php admin file to allow me to login secure through my website. All sytems go and my database through webassist, a 3rd party shopping cart is enable. However, when xampp was installed it was installed into my applications folder when normally I'm used to testing locally in my sites folder. So I put all php files inside htdocs and can test http://localhost/ now I am stuck with this:

1) There is no testing server running on the server machine.
2) the testing server specified for this site does not map to the http://127.0.0.1/xampp/htdocs/store_...s/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site.

It's right in front of me and I have been stuck for 3 days....help.help.help????