Help I have asked my host this and they cant help me i have a real bad feeling that i am forgetting something fundamental.
Its hard to explain but here are the errors that dreamweaver throws up when i try to connect and view tables on the database.
Error results
http://www.u501.com/result.htm
http://www.u501.com/result2.html
http://www.u501.com/err4.htm
If you have any questions shoot but please remember that i have spent 2 days on this problem And got two so called experts help so many small changes have already been tried .
The testing server should i be using wamp or something i managed to get a MYSQL database connected when i was using coldfusion but it seems 500 times harder with PHP for some reason. But coldfusion had its own localhost server
The URL path i have tried the IP tried the domain name tried local host and localhost:8500
Can somebody please point me in the correct direction before i go back to making static pages
#1 by csanon at July 7th, 2009
Q
The testing server should i be using wamp or something i managed to get a MYSQL database connected when i was using coldfusion but it seems 500 times harder with PHP for some reason. But coldfusion had its own localhost server
End Q
Precisely. PHP is just a programming language. Well, so is Coldfusion, but Macromedia provides a server as well. PHP doesn’t. The professional method is to install Apache first, and then PHP. When you “installed” PHP, you saw a lot of directions on configuring Apache right?
Connecting to a MySQL database is all well and fine, but you aren’t connecting to it. Your PHP scripts are. But to run your PHP scripts, you need to have them run through a web server, with PHP enabled.
If installing Apache scares you, look at XAMPP or WAMP.
Additional response:
“but If i code the pages with a Mysql connection”: all this means is that you have code that attempts to connect to a MySQL database.
“it should work via the MYSQL database”: What do you mean by this? MySQL is a database server. If you want to run your server-side code, you need a server and you need to be able to run that code. MySQL has nothing to do with it. Perhaps you should take MySQL out of the picture for a moment. Write code that displays “Hello world” on the screen. Does it make more sense why MySQL is irrelevant when it comes to actually running the code?
“It seems dreamweaver is much more compatible with coldfusion”: Dreamweaver has very high support for PHP, make no mistake. But I wouldn’t be surprised about their compatibility with Coldfusion. Macromedia, the original makers of Dreamweaver, bought Coldfusion. Adobe bought Macromedia. Short story: the same people who make Dreamweaver make Coldfusion.
#2 by Doug V at July 7th, 2009
The messages you are getting are pretty straightforward: You haven’t properly set up your testing server, so none of the scripts Dreamweaver is generating for you will work.
I am assuming you can test this at http://www.u501.com. Before you begin, create a directory at that Web site address named “testing”, e.g., http://www.u501.com/testing/
1. Start Dreamweaver
2. Choose Site –> Manage Sites
3. Select the site you are working on and click Edit.
4. Make sure you have the Advanced tab selected
5. Choose Testing Server
6. Make sure you have chosen PHP MySQL as your Server model
7. Under Access, choose FTP
8. Provide the name of the FTP host for http://www.u501.com in the space provided.
9. In the host directory, specify the testing directory you just created, e.g., testing/
10. Provide your FTP user name and password in the spaces provided.
11. Choose the passive, firewall and secure FTP checkboxes as appropriate (if you’re unsure, check them all off).
12. In the URL prefix box, give the full path to the testing directory, e.g., http://www.u501.com/testing/
13. Click OK, then Done
You will now test all scripts out of the testing directory on your Web site. This will allow you to use the same environment, database, etc. that you will be using in production for testing purposes, and it should stop all the error messages.
In the meantime, you might want to learn some basic PHP coding so you can stop wasting time with Dreamweaver’s peculiarities and do this yourself. You’ll be better off in the long run.
#3 by John P at July 7th, 2009
To be honest i don’t understand what’s for problem. Are you running PHP+Mysql at http://www.u501.com ? If yes, just upload your scripts and test it. If not install some WAMP distribution on your computer.http://www.wampserver.com/en/download.ph…