Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Script for a quick PHP MySQL DB connection test.
# 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)) {
#echo $tbl[0]."<br />\n";
if (!$tblCnt) {
echo "There are no tables<br />\n";
} else {
echo "There are $tblCnt tables<br />\n";
Copy link

dinushkarukshan commented May 18, 2020

Thank you!

Copy link

ModeratorPS commented Apr 11, 2022

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.
Bildschirmfoto 2022-04-11 um 20 57 18

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment