Test script for database MySQL / MariaDB connection.

test_database_connect.php

<?php

	define('DB_HOST', 'localhost');
	define('DB_NAME', 'XXX');
	define('DB_USER', 'XXX');
	define('DB_PASSWORD', 'XXX');
	// Port : 3306

	$messages = array(
		'no_Host' => 'Unable to Connect to "'. DB_HOST.'".',
		'no_Name' => 'Could not open the db "'. DB_NAME.'".',
		'no_Table' => 'There are no tables.',
	);

	// Test HOST
	$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD) or die( $messages['no_Host'] );

	// Test Database Name
	mysqli_select_db($link, DB_NAME) or die( $messages['no_Name'] );
	
	// Check Nr of Tables
	$test_query = "SHOW TABLES FROM DB_NAME";
	$result = mysqli_query($link, $test_query);
	$nr_tables = 0;

	while( $table = mysqli_fetch_array($result) ) {
	  $nr_tables++;
	}

	if ( ! $nr_tables ) {
	  echo $messages['no_Table'];
	} else {
	  echo "There are $nr_tables tables<br />\n";
	}