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
Yes i get the idea what you are saying. I will attempt to get wamp working in order to test but If i code the pages with a Mysql connection it should work via the MYSQL database so i could skip testing ? It seems dreamweaver is much more compatible with coldfusion than it is with PHP funnily enough.
yes i should of said that i had the database already set up on the host its the testing server that is the problem so if i wrote the correct connection string in my php page then presumably it would connect to the remote database and work fine.
I really need to test though so i have got wamp working and hopefully i can get that to work with dreamweaver localhost
Im studying some lynda.com material just now so hopefully i can get this Mysql connection working my php has been fine its not the problem .
I appreciate the advice though
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.
Technorati Tags: coldfusion, Connection String, Correct Direction, Database Error, Domain Name, dreamweaver, Error Results, Ip, Local Host, Localhost, Mysql Connection, mysql database, Mysql Php, Path, Php Mysql, Real Genius, Reason, Small Changes, Url, Wamp
