I have a testing server at localhost, after making amendments fixing bugs etc. I upload to a hosted web server. Problem is I have to change all the mysql_connect_db statements before uploading due to parameter 1 of the mysql_connect_db statement on the testing server being set to "localhost" and on the live server it's info provided by the web hosting company.
Is there any way I can set something in my localhost testing environment (or a completely different method) that simulates the same as the live environment
I see what you mean and I found this hassle. How many times are you calling that function? Do you have multiple databases or just one?
Just upload your local version. When it is live, go into your host directories and manually edit all the connection stuff. Then you've only done it once and you also keep a copy of your original localhost versions of the files. Once you got a live version, you can work locally, then just copy paste the code into your live version by going into the bit where you upload and editing the file which is online directly.
Hope it helps.
Maybe someone can give you better information and good tips to keep in mind. This is what I do but I'm no expert.