php test server

Report · Jul 20, 2010

i'm working on my first site that's using php and mysql. setup wamp on my pc and it works fine and the site works fine.

I want it so i can point at my hosting providers mysql server while using local apache as my testing server. However when i do this i have to make my URL prefix of the testing server the accual domain name (not local host) or my database connection is toast. However if it's set as the actual domain name then "live view" doesn't work.

any idea's,

matt

Report · Jul 21, 2010

maybe there is a better way then what i'm doing.

pics are worth a thousand words

when i have local host as the url prefix the live view works but my "mysql" connection to my hosting provider gives me this.

and vise/verse if i have the proper domain name of the site I'm developing for (which is the hosting providers server) then live view dies and the mysql connection works fine.

In developing static pages in the past i have always setup my local as testing and remote as production. Should i be looking at doing something differently when developing dynamic pages?

Any help is greatly appreciated!!