有没有办法自动调整数据库名称，用户名和密码

Question

I'm currently in the process of making a website using PHP and mysql for the database. I'm pretty much juggling between a local server with WAMP for debugging and sending to the live server. So I was wondering if there was a way to automatically adjust the database name, the username and the password according to the server the website is on. Currently, I'm just doing it manually but I keep forgetting about it and it becomes annoying especially since I'm uploading to the live server several times a day for my friends to test. I've tried using $_SERVER['REMOTE_ADDR'] but for some reason, it doesn't work. Do you guys have any solution or should I just continue doing it manually?

Answer 1

There's several ways to go about it.

• Check for server name with gethostname and switch credentials based on that.
• Create a file on each server with the credentials, with the same name/path. Do not update that file when uploading to the live server.

If your code allows for environment files such as .env, use that.