使用函数连接到远程mysql服务器

Question

I'm using wordpress and I have a remote mysql server for some other data not stored on wordpress db.

Now I want to connect to that remote mysql server in a form of a php function but i don't know how or if it is possible. Basically this function serves as to check if $orderid exist on the remote mysql server.

function check_orderid($orderid) {
// Connect to database
// Check if $orderid exist if yes return true.
}

The remote server does accept remote connections.

Also, Is it okay and will not affect wordpress db connection?

Answer 1

Connecting to a remote server is not different from connecting to a local server, besides the host address. Just replace the 'localhost' with a resolvable dns name, or the ip address from your remote server, and you should be fine.