How do you test a php file on windows when it requires a MySQL database to read from?

[The Informer]

Specifically, I want to be able to view and run a website that is programmed in PHP (on windows) before I upload it to my site. But of course you know that you can't view php pages that are reading from a MySQL database by just viewing it from a local folder on your computer like you do html pages... How would I go about doing this on my computer while offline?

[tpennetta]

Sure you can view, test, edit, etc Databases on your own computer, as well as view and edit PHP files.

You need to install a local test server on your machine in order to do all of this. Along with a test server is a compatible SQL server.

I would recommend downloading XAMPP from http://www.apachefriends.org

It is auto-installing, simple to setup and understand.

Once you set it up, you can start editting and testing, then upload your final version to your destination online.

Hope this Helps! Best of Luck!

[yakuza]

copy the file to the root folder and run using local host

[Jerry M]

Install WAMP (Windows Apache MySQL PHP)