Question

How to get host information after connect to database using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = mysqli_connect("localhost", $db_user, $db_password, $db_name);

if (!$con) {
    echo "Error connect to MySQL" . PHP_EOL;
    echo "errno: " . mysqli_connect_errno() . PHP_EOL;
    exit;
}

echo "Host information: " . mysqli_get_host_info($con);

mysqli_close($con);


/*
run: 

Host information: localhost via TCP/IP 

*/

 

70+ SQL courses for beginners and professionals