Consult bank on another server

Question

I have a Mysql database and need to consult it from another server using PHP. What’s the best way to do this?

It is possible to activate a function on the database server and make it return the result of the query?

Answer 1

If the mysql server does not have an "input" firewall it can access normally with mysqli or PDO, just point to the IP of the "mysql server" or its host address (if).

Example with mysqli:

<?php
$nomedoservidor = "mysql.outro-host.com";
$usuario = "username";
$senha = "password";
$banco = "banco1";

$conn = new mysqli($nomedoservidor, $usuario, $senha, $banco);

If it’s a "fixed ip":

<?php
$nomedoservidor = "203.40.1.2"; //Exemplo fictício
$usuario = "username";
$senha = "password";
$banco = "banco1";

$conn = new mysqli($nomedoservidor, $usuario, $senha, $banco);

Recommend who reads:

• PHP only connects to Mysql?
• What’s the difference between Mysql and phpMyAdmin?
• What a difference from Xampp, Wamp, Easyphp, Zwamp and PHP?

These posts will help you understand where the Mysql server is, where PHP is, where Apache is and what it is Mysql API.