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';

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the db '$dbname'");

$test_query = "SHOW TABLES FROM $dbname";
$result = mysql_query($test_query);

$tblCnt = 0;
while($tbl = mysql_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";
}

Says no tables when there are some.

thank you

Thanks!

That really worked perfect and it is fantastic! I tried so many scripts, and that worked excellent. Many thanks.

Great! Obrigado!

thanks

great for fast implementation

I forked this to make some edits to deal with deprecated functions but I'm not sure how to push it back to yours for approval if you so choose to commit the changes.

thank you! works great.

mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

gives me 403 error

Updated to use Mysqli: https://gist.github.com/M165437/421cd2d23e53a111541a483971f7368b

Nice. Simple, useful, direct and to the point. Thanks!

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /var/www/html/car/db-connect-test.php:10 Stack trace: #0 {main} thrown in /var/www/html/car/db-connect-test.php on line 10

500 error. what missing

i am getting uncaught error for call to undefined function mysql_connect
please provide me the solution fast

This contains old code, use this one https://gist.github.com/M165437/421cd2d23e53a111541a483971f7368b

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\sample\mycoonect.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\sample\mycoonect.php on line 8

showwing this error i have tried so many times .. with your code and with my own code but showing the same error

works perfectly for a quick test. Thanks a lot.

Hi @ALL

Very useful script. Thanks a lot.
Using arch-linux and maria-db the mysql do not work, so the code was changed as listed below -- and then executed succesfully.

I hope this helps,
https://gist.github.com/FGDATA/37e8c0d4ca6b15ac7046ad7c28e9ef42
https://gist.github.com/FGDATA/37e8c0d4ca6b15ac7046ad7c28e9ef42/revisions

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

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

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

$test_query = "SHOW TABLES FROM $dbname";
$result = mysqli_query($connect, $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";
}

Here is a script that shows the error as well: https://ardamis.com/2008/05/26/a-php-script-for-testing-a-mysql-database-connection/

Well detailed script. Thanks

Hi Chris,

Many thanks for your script, I've updated it with an html form section, if anyone needs to test the same via a browser. The name of the *.php files corresponds to the name depicted in the form section (form action="index.php”)' currently, this can be changed to match the name of the php file. I've tested it with RDS MySQL.

<?php

if(isset($_POST['dbname']) && isset($_POST['dbuser']) && isset($_POST['dbpass']) && isset($_POST['dbhost']))

{

        $dbname = $_POST['dbname'];
        $dbuser = $_POST['dbuser'];
        $dbpass = $_POST['dbpass'];
        $dbhost = $_POST['dbhost'];


        $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";
                }

                }
?>


<form action="index.php" method="post">
        Enter Database_name: <input type="text" name="dbname" />
        Enter Database_username: <input type="text" name="dbuser" />
        Enter Database_password: <input type="password" name="dbpass" />
        Enter Database_host: <input type="text" name="dbhost" />
<input type="submit" value="Submit" />
</form>

what is the error I am getting when I do php.script.php

Fatal error: Uncaught Error: Call to undefined function mysql_connect()

thanks!

PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\inetpub\wwwroot\db-connect-test.php:10
Stack trace:
#0 {main}
thrown in C:\inetpub\wwwroot\db-connect-test.php on line 10

Using on MariaDB Implemented on RaspberryPi
I found this code very helpful i’m new to php and this code was just the job.
Many thanks
Phil

Thank you!

Thanks bro!

Thanks man!