Script for a quick PHP MySQL DB connection test.

db-connect-test.php

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php

$dbname = 'name';
$dbuser = 'user';
$dbpass = 'pass';
$dbhost = 'host';

$link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'");

$test_query = "SHOW TABLES FROM $dbname";
$result = mysqli_query($link, $test_query);

$tblCnt = 0;
while($tbl = mysqli_fetch_array($result)) {
  $tblCnt++;
  #echo $tbl[0]."<br />\n";
}

if (!$tblCnt) {
  echo "There are no tables<br />\n";
} else {
  echo "There are $tblCnt tables<br />\n";
}

Hi there.

Are you running this script in /var/www/ ??
Save it as db-connect-test.php in /var/www/html and try there

Regards J

wonderfull, thanks.

Cool. So It said there is 1 table, and when I added another table, it updated to 2 tables. i assume this is a positive result?

Cool. So It said there is 1 table, and when I added another table, it updated to 2 tables. i assume this is a positive result?

Correct

PHP Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: H�te inconnu. in C:\inetpub\wwwroot\db-connect-test.php on line 10
PHP Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: H�te inconnu. in C:\inetpub\wwwroot\db-connect-test.php on line 10

If you send me the working fix as pull-request, I could include it into the repository and publish an updated version on SF:

• https://github.com/chatelao/php-addressbook

Thank you!

I have tested the script and the connection works well.
But, I got following error: There are no tables

Any idea why?

I have only one table, but this one should be shown.