Viewing PHP pages locally

[jc_gmk]

Is there any way that I can test my PHP pages locally rather than having to upload them first. (using IE and firefox)

If i try and load my index.php page locally the browsers that I use try to download the php file instead of displaying them.

any ideas?

[tech_support]

You could make your computer a local server.
Download a WAMPP package (I would recommend this (http://www.apachefriends.org/en/xampp.html)) and install it.
Your home directory would be drive name:\xampp\htdocs

[djr33]

Browsers don't parse PHP. You need a server.
Either make your computer a server as tech_support says, or just upload to your server and test from there.

[iwantyoutospamme]

use easyphp

easyphp.org

[NairB]

Download http://www.devside.net/server/webdeveloper

I used this absolutely brilliant bit of software that makes your PC a localhost in seconds.....and its free ;)

ps...just look at all the stuff you get with it, scroll down the devside website and look at components.

-NairB

[jc_gmk]

I've now made my pc a server by installing Apache.
It works fine I can view all my PHP pages locally execpt if I try and connect to a remote MySQL database (not stored locally.)

I get the message:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'myusername@123.123.123.123' (Using password: YES) in K:\Websites\index.php on line 2
Access denied for user: 'myusername@123.123.123.123' (Using password: YES)

Any Ideas?

[mwinter]

... I can view all my PHP pages locally execpt if I try and connect to a remote MySQL database (not stored locally.)

The best security for a database server is achieved not only when user credentials are checked, but also the IP address of the incoming connection. As your request will come from an unrecognised IP address, it will be rejected - at least that's what I would expect.

[Twey]

Yes, you'll need to modify the permissions on the database server to allow access from your PC.

[jc_gmk]

Any ideas how I do that?
Do I need to edit one of the files?

The server isn't my own it is provided by a hosting company.