Checking If the MySQL Database Connection is Working?

[glassfish]

Is there an alert method for the MySQL database or something similar?

 

What is the proper way to check if the MySQL database connection is working?

 

I mean other than "creating" and "retrieving" with "insert" and "select".

[Ch0cu3r]

Why not look at the relevant documentation? It explains what each connection method returns and code examples of how to connect and test if the connection works.

• mysql
• mysqli
• pdo

Edited October 7, 2014 by Ch0cu3r

[glassfish]

 

<?php

 

$dbc = mysqli_connect('localhost', 'root', '', 'testing');

 

if(!$dbc){

die('Connect Error ('. mysqli_connect_errno() . ') ' . mysqli_connect_error());

}

 

echo "Success..." . mysqli_get_host_info($dbc) . "\n";

 

mysqli_close($dbc);

 

?>

 

Success...localhost via TCP/IP

 

 

When is it set? What is the return value?

Edited October 7, 2014 by glassfish

[jcbones]

Well, from your example, the mysqli_get_host_info($dbc) returned 'localhost via TCP/IP', but specifically according to documentation

Manual says

    Return Values ¶
    A character string representing the server hostname and the connection type.

    Otherwise your example shows the connection to the database through mysqli, and IF IT FAILS the script dies (exits, quits) while outputting the the returned values of mysqli_connect_errno() and mysqli_connect_error().
    Which are sequentially:
mysql_connect_errno()
 

        Return Values ¶
        An error code value for the last call to mysqli_connect(), if it failed. zero means no error occurred.
 

mysql_connect_error()

            Return Values ¶
            A string that describes the error. NULL is returned if no error occurred.

 

Edited October 9, 2014 by jcbones

[glassfish]

Thanks for clarifying.