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

@chrisdrogaris chrisdrogaris commented Mar 30, 2015

Says no tables when there are some.

@aeroson

This comment has been minimized.

Copy link

@aeroson aeroson commented Sep 13, 2015

thank you

@joaoBeno

This comment has been minimized.

Copy link

@joaoBeno joaoBeno commented Sep 29, 2015

Thanks!

@changlee2

This comment has been minimized.

Copy link

@changlee2 changlee2 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

@lexblagus lexblagus commented Mar 31, 2016

Great! Obrigado!

@abhinov2

This comment has been minimized.

Copy link

@abhinov2 abhinov2 commented Apr 14, 2016

thanks

@ron4stoppable

This comment has been minimized.

Copy link

@ron4stoppable ron4stoppable commented Apr 28, 2016

great for fast implementation

@BretMishler

This comment has been minimized.

Copy link

@BretMishler BretMishler 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

@stephangriesel stephangriesel commented Jun 10, 2016

thank you! works great.

@omalave

This comment has been minimized.

Copy link

@omalave omalave 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

@ChimpGamer ChimpGamer commented Aug 4, 2016

gives me 403 error

@M165437

This comment has been minimized.

Copy link

@M165437 M165437 commented Sep 2, 2016

@ultrablue

This comment has been minimized.

Copy link

@ultrablue ultrablue commented Oct 13, 2016

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

@abdulsalam1447

This comment has been minimized.

Copy link

@abdulsalam1447 abdulsalam1447 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

@abdulsalam1447 abdulsalam1447 commented Mar 27, 2017

500 error. what missing

@Shivani-Band

This comment has been minimized.

Copy link

@Shivani-Band Shivani-Band 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

@mikkelbiz mikkelbiz commented Apr 29, 2017

@BestaTechnology

This comment has been minimized.

Copy link

@BestaTechnology BestaTechnology 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

@Nordinz Nordinz commented Oct 10, 2017

works perfectly for a quick test. Thanks a lot.

@FGDATA

This comment has been minimized.

Copy link

@FGDATA FGDATA 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

@Jogai Jogai commented Jul 3, 2018

@hargi12

This comment has been minimized.

Copy link

@hargi12 hargi12 commented Aug 6, 2018

Well detailed script. Thanks

@davegog

This comment has been minimized.

Copy link

@davegog davegog 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

@waseemmir1 waseemmir1 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

@jonasrafael jonasrafael commented Feb 12, 2019

thanks!

@HATIMEDIA

This comment has been minimized.

Copy link

@HATIMEDIA HATIMEDIA 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

@cambmon

This comment has been minimized.

Copy link

@cambmon cambmon commented Jan 3, 2020

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

@dinushkarukshan

This comment has been minimized.

Copy link

@dinushkarukshan dinushkarukshan commented May 18, 2020

Thank you!

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.