setting up php testing server

Report · Mar 23, 2008

hello, i want to set up a php testing server.

i have created a web site called data test, which sits in the c:\my documents folder.

what settings and routes should i put in the site definition(advanced) for local info and testing server?

i have experimented a few times, but cannot get it to work.

i am running dreamweaver 8,

Report · Mar 23, 2008

malcster2 wrote:
> hello, i want to set up a php testing server.
>
> i have created a web site called data test, which sits in the c:\my documents
> folder.

The testing server folder must be inside the web server document root.
It's no good in your my documents folder.

Assuming you installed PHP with Apache, it should be inside the Apache
htdocs folder.

In the Testing server section of the site definition, set Testing server
folder to C:\path\to\htdocs\mysite. Set URL prefix to
http://localhost/mysite.

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

Report · Mar 23, 2008

where can i download the latest apache server from?

Report · Mar 23, 2008

malcster2 wrote:
> where can i download the latest apache server from?

http://httpd.apache.org/download.cgi

Choose the Win32 binary without crypto (apache_2.2.8-win32-x86-no_ssl.msi)

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

Report · Mar 23, 2008

i have succesfully installed apache with php. i have also installed mysql to work alongside.
i am however having trouble accessing databases i have set up on mysql.

i am going to application, creating a connection name, using local host as the server, setting up a user name and password, but i cannot seem to find, or connect to a db i have set up on the mysql command screen.

any ideas?

Report · Mar 23, 2008

please read the above post before this one......

i have also downloaded php admin, which i understand is a good tool to work with mysql.
however, i have no idea how to install. there is a install file in the download, but this is not associated with any programs. any ideas?

Report · Mar 23, 2008

That is a separate install:

http://www.phpmyadmin.net/home_page/index.php

This is a GUI for MySQl:

http://www.heidisql.com/

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com

"malcster2" <webforumsuser@macromedia.com> wrote in message
news:fs63mj$7t2$1@forums.macromedia.com...
> please read the above post before this one......
>
> i have just realized, i have installed php 5, which seems to have
> installed ok.
>
> but should i not have a phpadmin opin on the start menu?

Report · Mar 23, 2008

thanks for the hedisql tip. saves me mucking about with phpmyadmin.

but i am still having trouble connecting to a database from dreamweaver. i am creating a new connection, am inputting my username as root(is that the default username?), and using my password which i created on mysql set up.

so why can i not see the database?

i am using the localhost as my server, but am getting message 404, file not found.

please help!!!

Report · Mar 23, 2008

thanks for the hedisql tip. saves me mucking about with phpmyadmin.

but i am still having trouble connecting to a database from dreamweaver. i am creating a new connection, am inputting my username as root(is that the default username?), and using my password which i created on mysql set up.

so why can i not see the database?

i am using the localhost as my server, but am getting message 404, file not found.

please help!!!

Report · Mar 23, 2008

If you know the name of teh database just try typing it in that box.

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com

"malcster2" <webforumsuser@macromedia.com> wrote in message
news:fs68p6$csn$1@forums.macromedia.com...
> thanks for the hedisql tip. saves me mucking about with phpmyadmin.
>
> but i am still having trouble connecting to a database from dreamweaver. i
> am
> creating a new connection, am inputting my username as root(is that the
> default
> username?), and using my password which i created on mysql set up.
>
> so why can i not see the database?
>
> i am using the localhost as my server, but am getting message 404, file
> not
> found.
>
> please help!!!
>
>
>

Report · Mar 24, 2008

no, i keep getting the message:

HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem.

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://localhost/_mmserverscripts/mmhttpdb.php URL. Verify that the URL prefix maps to the root of the site.

i am currently running mysql as well as apache in the background. i can connect to the mysql server through mysql gui programs, as well as the command line. just cannot connect through dreamweaver.

any ideas?

Report · Mar 24, 2008

See if one of these help:

http://www.adobe.com/go/kb00112

http://www.adobe.com/go/tn_15711

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com

"malcster2" <webforumsuser@macromedia.com> wrote in message
news:fs7ncg$qk$1@forums.macromedia.com...
> no, i keep getting the message:
>
> HTTP Error Code 404 File Not Found. Here are some possible reasons for the
> problem.
>
> 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://localhost/_mmserverscripts/mmhttpdb.php URL. Verify that the URL
> prefix
> maps to the root of the site.
>
> i am currently running mysql as well as apache in the background. i can
> connect to the mysql server through mysql gui programs, as well as the
> command
> line. just cannot connect through dreamweaver.
>
> any ideas?
>

Report · Mar 24, 2008

hmmmm...

still not to sure about this one, novice you see.

here is my dir setup, for clarity.

on my c drive i have the folder web. inside that i have 2 folders websites, and web server(which contains mysql, php and apache 2)....does that seem correct?

when i'm creating a new site, would i need to save the site inside one of the web server folders, or i could i just save them anywhere, i.e, the web sites folder?

i am saving the web pages as php, as i that is what i am teaching myself at the moment

Report · Mar 24, 2008

malcster2 wrote:
> when i'm creating a new site, would i need to save the site inside one of the
> web server folders, or i could i just save them anywhere, i.e, the web sites
> folder?

You need to set up your website in the Apache server root, which is a
folder called htdocs. The location of htdocs will depend on how you
installed Apache.

For your testing server details in the Dreamweaver site definition, set
Testing server to this:

C:\path\to\htdocs\mysite

URL prefix should be this:

http://localhost/mysite

If you're just starting out with PHP, you might want to take a look at
my book "The Essential Guide to Dreamweaver CS3 with CSS, Ajax, and
PHP". It covers installation and setup details, all the PHP server
behaviors in Dreamweaver, and a lot more besides. For more details,
follow the link in my sig.

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

Report · Mar 24, 2008

thanks for all your help on this one. i believe i now have it sorted. the problems were 2 fold.

1) i was saving my sites locally. i am now saving the site folders directly in my apache2 folder.

2) i had the wrong drive selected in the mysql route in php.ini.

i am still on dreamweaver 8, becuase i cannot install dw cs3 on my computer. i always get the error message, check your disk space and write privelages, no matter what folder i install to. i no this is a very commom problem. do you know anything about this?