Do you HAVE TO have a testing server in order to build php pages that will connect to your mysql db?

I'm having LOTS of trouble setting up local instance (when I learned that I couldn't remotely connect to a testing instance on my live server) just so I can build (using DW) these php pages that need to access a mysql db (one table) created with phpMyAdmin.

Is there a way to NOT need this testing sever. Can I build pages in DW, create the queries to the db THEN upload to live server to test? If so - How! Help!
sock2meAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RouchieCommented:
You could do this, but you'd have to do all the coding yourself.  Dreamweaver needs the testing server's server-side language to be configured so that it can accurately create database connection strings automatically for you, and then (to some degree) let you execute server-side code on the development machine to see the page's outcome.

>> Can I build pages in DW, create the queries to the db THEN upload to live server to test?

Go to Site >> Manage Sites and set up a new site on your local PC.  When it asks for a server technology select NONE, then on the next step select EDIT LOCAL COPIES ON MY MACHINE.

The obvious downside to this is that you won't be able to test out the files on your machine to see if they're working,  so you lose that aspect of debugging.  You also need to know the connection strings and queries that you'll be using because DW will not provide these for you.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.