Check host exist in MySQL/PHP

See more:

PHP

MySQL

web_development

Hi all,

Say I want to connect to a database in a different PC through PHP. So I could do something like this,

<?php
    $username = "root";
    $password = "sa";
    $host = "192.168.2.20";
    $database = "database";

    $link = mysql_connect($host, $username, $password);
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
                
    mysql_select_db ($database);
?>

That 192.168.2.20 IP (or the PC) exist in the network, and say it shutdown and try to connect into it as above. Before report the connection error by the above PHP code segment, it'll retry till the connection timeout.

I want to find out that the database is available before inert data into it and notify to the user if he/she cannot do that. Hope you all are clear with my requirement.

Thanks in advance :)