Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Script for a quick PHP MySQL DB connection test.
<?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";
}
@chrisdrogaris

This comment has been minimized.

Copy link

commented Mar 30, 2015

Says no tables when there are some.

@aeroson

This comment has been minimized.

Copy link

commented Sep 13, 2015

thank you

@joaoBeno

This comment has been minimized.

Copy link

commented Sep 29, 2015

Thanks!

@changlee2

This comment has been minimized.

Copy link

commented Dec 27, 2015

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

@lexblagus

This comment has been minimized.

Copy link

commented Mar 31, 2016

Great! Obrigado!

@abhinov2

This comment has been minimized.

Copy link

commented Apr 14, 2016

thanks

@ron4stoppable

This comment has been minimized.

Copy link

commented Apr 28, 2016

great for fast implementation

@BretMishler

This comment has been minimized.

Copy link

commented May 3, 2016

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.

@stephangriesel

This comment has been minimized.

Copy link

commented Jun 10, 2016

thank you! works great.

@omalave

This comment has been minimized.

Copy link

commented Jun 13, 2016

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

@ChimpGamer

This comment has been minimized.

Copy link

commented Aug 4, 2016

gives me 403 error

@M165437

This comment has been minimized.

Copy link

commented Sep 2, 2016

@ultrablue

This comment has been minimized.

Copy link

commented Oct 13, 2016

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

@abdulsalam1447

This comment has been minimized.

Copy link

commented Mar 23, 2017

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

@abdulsalam1447

This comment has been minimized.

Copy link

commented Mar 27, 2017

500 error. what missing

@Shivani-Band

This comment has been minimized.

Copy link

commented Apr 7, 2017

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

@mikkelbiz

This comment has been minimized.

Copy link

commented Apr 29, 2017

@BestaTechnology

This comment has been minimized.

Copy link

commented Sep 28, 2017

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

@Nordinz

This comment has been minimized.

Copy link

commented Oct 10, 2017

works perfectly for a quick test. Thanks a lot.

@FGDATA

This comment has been minimized.

Copy link

commented Feb 17, 2018

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";
}
@Jogai

This comment has been minimized.

Copy link

commented Jul 3, 2018

@hargi12

This comment has been minimized.

Copy link

commented Aug 6, 2018

Well detailed script. Thanks

@davegog

This comment has been minimized.

Copy link

commented Oct 9, 2018

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>


@waseemmir1

This comment has been minimized.

Copy link

commented Jan 1, 2019

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

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

@jonasrafael

This comment has been minimized.

Copy link

commented Feb 12, 2019

thanks!

@HATIMEDIA

This comment has been minimized.

Copy link

commented Jul 24, 2019

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.