jrobinsonc
10/12/2016 - 7:52 PM

Test MySQL connection.

Test MySQL connection.

<?php

$mysqli = new mysqli('host', 'user', 'pass', 'db_name');

if ($mysqli->connect_errno) {
    echo "Error: Failed to make a MySQL connection, here is why: \n";
    echo "Errno: " . $mysqli->connect_errno . "\n";
    echo "Error: " . $mysqli->connect_error . "\n";
}
<?php

require 'vendor/autoload.php';

$dotenv = new Dotenv\Dotenv(__DIR__);
$dotenv->load();

print_r([getenv('DB_HOST'), getenv('DB_USER'), getenv('DB_PASSWORD'), getenv('DB_NAME')]);

$mysqli = new mysqli(getenv('DB_HOST'), getenv('DB_USER'), getenv('DB_PASSWORD'), getenv('DB_NAME'));

if ($mysqli->connect_errno) {
    echo "Error: Failed to make a MySQL connection, here is why: \n";
    echo "Errno: " . $mysqli->connect_errno . "\n";
    echo "Error: " . $mysqli->connect_error . "\n";
}
<?php 

$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if ($mysqli->connect_errno) {
    echo 'Error: Failed to make a MySQL connection, here is why: <br />';
    echo 'Errno: ' . $mysqli->connect_errno . '<br />';
		echo 'Error: ' . $mysqli->connect_error . '<br />';
		exit;
}

echo "👍";
exit;